Sciaga1 by MSun


0x08 graphic

0x08 graphic
0x01 graphic

0x08 graphic

0x08 graphic
0x01 graphic

0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x01 graphic
0x08 graphic
0x01 graphic

0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x01 graphic

0x08 graphic
0x08 graphic
0x08 graphic

Employee

Department

Salary

Address

13416

24576

43658

98452

88774

Sales

Accounts

Sales

Production

Production

21,950

26,000

23,400

26,000

21,950

1 High St, Toowong

1 George St, City

6 Queen St, City

1 High St, Toowong

4 Rode Rd, Chermside

0x08 graphic
0x08 graphic
0x01 graphic
0x08 graphic
0x01 graphic

0x08 graphic
0x01 graphic

0x08 graphic

0x08 graphic
0x01 graphic

0x08 graphic
0x08 graphic
0x01 graphic

Insect

Herb

Ants Aphids Cabbage Flies Mosqui- Potato Tomato

Moths Toes bug worm

Basil

Borage

Dead Nettle

Flax

Horse radish

Hyssop

Spearmint

X X

X

X

X

X

X

X X

0x08 graphic
0x01 graphic

0x08 graphic

0x08 graphic
0x01 graphic

0x08 graphic

0x08 graphic
0x01 graphic

0x08 graphic
0x01 graphic
0x08 graphic

0x08 graphic

Insect

Herb

Ants Aphids Cabbage Flies Mosqui- Potato Tomato

Moths Toes bug worm

Basil

Borage

Dead Nettle

Flax

Horse radish

Hyssop

Spearmint

X X

X

X

X

X

X

X X

0x08 graphic
0x01 graphic

0x08 graphic

Employee

Manager

Jones

Adams

Wong

Fegan

Crane

Bell G

Spencer

Bell A

Giles

0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
0x08 graphic
Jones

Jones

Giles

Bell G

Jones

Bell G

Jones

0x08 graphic

Name

DAddress

CompanyCar

Job Title

Brown

Smith

Santos

Wong

Ng

Nguyen

1 George St

1 Queen St

1 Queen St

1 George St

78 Elizabeth St

15 Mary St

400NRU

500NRU

100ABC

100BCD

500PQR

400NRU

Sales Rep

Sales Support

Manager

Clerk

Manager

Sales Rep

0x08 graphic
0x01 graphic

0x08 graphic
0x08 graphic

Floor

Room#

Staff Member

2

2

3

2

12

13

12

13

Sally Wong

Tom Smith

Manual Barriga

Johann Schmidt

0x08 graphic
0x08 graphic
0x01 graphic

Employee

Project

Total Allocation (hours)

HoursSpent

E1

E1

E2

E2

E3

E3

P1

P2

P1

P2

P1

P2

50

50

65

35

50

35

24

26

13

15

25

26

0x08 graphic
0x01 graphic

Owner

Address

RegNumber

RegLetters

SpecPlate

Bill Brown

Sally Brown

Mary Jones

Helen Santos

Thom Santos

Peter Perfect

1 George St

1 George St

15 Park Rd

22 Mary St

22 Mary St

77 Mary St

100

100

100

202

ABC

ABC

PQR

ABC

Wowser

Perfect

0x08 graphic

0x08 graphic
0x01 graphic

0x08 graphic

Province

Medals

Gold

Silver

Bronze

Total

Province W

7

5

3

15

Province X

2

2

9

13

Province Y

3

1

3

7

Province Y

4

0

2

6

…..

0x08 graphic
0x01 graphic

0x08 graphic

0x08 graphic
0x01 graphic

0x08 graphic

0x08 graphic

0x08 graphic

0x08 graphic
0x01 graphic

0x08 graphic
0x01 graphic

0x08 graphic
0x01 graphic

0x01 graphic

Leader

offered

delivering

Of start

Offered

in

On the

Lecturer

(Name)

Date

(DD/MM/YY0

Course

(CourseName

Employee

(Empl#)

Offering

Attended

At

Attended by

Attendance

Room

(room#)

0x01 graphic

Correct Schema

Leader

offered

delivering

Of start

Offered

in

On the

Lecturer

(Name)

Date

(DD/MM/YY0

Course

(CourseName

Employee

(Empl#)

Offering

Attended

At

Attended by

Attendance

Room

(room#)

Correct Schema

0x01 graphic

0x01 graphic

Problem 6

Book Supply

0x01 graphic

No join of any two projections on two columns produces original population of the fact type. Therefore, Split of this fact type into two fact types is impossible.

HOWEVER:

0x01 graphic

Problem 5

Is the following Fact Type splitable?

0x01 graphic

Problem 7

Academic results

0x01 graphic

Problem 9

Employees and projects

0x01 graphic

Problem 1.

Employee Details

Empl#

Empl_Id

Identifies

Is identi-fied by

Address

Home_Location

Is of

Located at

Dept_name

Dept_Id

Is earned by

Earns

Dollars

Pay_Id

Is amount of

Of amount

Home

Domicile

Is home of

Lives at

Department

Work Location

Employs

Works for

Salarye

Salary

Is earned by

Earns

Employeee

Problem 2.

Vehicle repairs

Vehicle

Date

Cost

100ABC

100ABC

100ABC

200DEF

200DEF

300GHI

400JKL

900XYZ

18/11/02

25/03/01

14/07/01

10/05/02

18/11/02

01/06/02

14/07/01

25/03/01

350.77

765.00

350.77

357.77

150.00

53.90

980.00

765.00

Alternative

Approach

(with nested FT)

Repair cost

Vehicle repairs

For the cost

Money

Is cost of

Date

Is earned by

Earns

Vehiclee

Dollars

Pay_Id

Is amount of

Of amount

DD/MM/YY

Pay_Id

Is id of

Ident. by

Regl#

Vehicle_Id

Identifies

Is identi-fied by

Repaired on/for

Of

Is the cost

Money

Date

Vehicle repairs

Vehicle

7

ZMA-s3-S

Problem 3.

Employee dates

Employee

Birth_date

Empl_start_date

123456

234567

345678

456789

567890

678901

21/06/60

18/07/55

29/03/55

20/08/65

21/06/60

16/12/72

05/09/83

20/04/86

04/07/90

04/07/90

16/12/72

02/01/92

Problem 4

Pest Control

Date

Id

For the cost

DD/MM/YY

Is cost of

Empl Id

Is iden- tified by

Empl_ID

Is Id of

Empl_Commencement

Of empl start

Started work

Date

Birth

Is DoB of

Born at

Employeee

Herb

Id

For the cost

Herb_name

Is cost of

Pest

Id

Is iden- tified by

Pest_name

Is Id of

Pest Control

Controls

Is control- led by

Herb

Insect

Problem 5

Employee

Department

Salary

Address

13416

24576

43658

98452

88774

Sales

Accounts

Sales

Production

Production

21,950

26,000

23,400

26,000

21,950

1 High St, Toowong

1 George St, City

6 Queen St, City

1 High St, Toowong

4 Rode Rd, Chermside

1. Employee Details

Empl#

Empl_Id

Identifies

Is identi-fied by

Address

Home_Location

Is of

Located at

Dept_name

Dept_Id

Is earned by

Earns

Dollars

Pay_Id

Is amount of

Of amount

Home

Domicile

Is home of

Lives at

Department

Work Location

Employs

Works for

Salarye

Salary

Is earned by

Earns

Employeee

2. Vehicle repairs

Vehicle

Date

Cost

100ABC

100ABC

100ABC

200DEF

200DEF

300GHI

400JKL

900XYZ

18/11/02

25/03/01

14/07/01

10/05/02

18/11/02

01/06/02

14/07/01

25/03/01

350.77

765.00

350.77

357.77

150.00

53.90

980.00

765.00

3. Employee dates

Employee

Birth_date

Empl_start_date

123456

234567

345678

456789

567890

678901

21/06/60

18/07/55

29/03/55

20/08/65

21/06/60

16/12/72

05/09/83

20/04/86

04/07/90

04/07/90

16/12/72

02/01/92

Alternative

Approach

(with nested FT)

Repair cost

Vehicle repairs

For the cost

Money

Is cost of

Date

Is earned by

Earns

Vehiclee

Dollars

Pay_Id

Is amount of

Of amount

DD/MM/YY

Pay_Id

Is id of

Ident. by

Regl#

Vehicle_Id

Identifies

Is identi-fied by

Repaired on/for

Of

Is the cost

Money

Date

Vehicle repairs

Vehicle

9

9

ZMA-s3-S

Empl_Commencement

Of empl start

Started work

Date

(DD/MM/YY)

Birth

Is DoB of

Born at

Employee

(Empl_Id)

Birth

4. Insect Control

Date Id

Of format

DD/MM/YY

Is format of

Empl Id

Is iden- tified by

Empl_ID

Is Id of

Empl_Commencement

Of empl start

Started work

Date

Is DoB of

Born at

Employeee

10

Is iden- tified by

Is Id of

Herb

Id

Herb_name

Pest

Id

Is iden- tified by

Pest_name

Is Id of

Controls

Is control- led by

Herb

Insect

Problem 6

Employees and Managers.

Management

Manages

Is Mana-

Ged by

Employeee

Emp_Id

Problem 7

Employee information.

DeptAddr

(H_Address)

Dept Loc

Is location of

Works at

Car

(NReg#

Car Use

Is used by

uses

Position

(J_T_name)

Occupation

Is job title of

Empl as

Employeee

Emp_Id

Problem 8

Staff Offices

U

has

Room #

of

Is on

Floor

of

Room

Office Location

Is office of

Has office In

Employeee

Emp_Id

Problem 9

Employees and projects

Time spent

For the cost

Is cost of

Total Alloc

For the cost

Time

(Hours)

Is cost of

Projedt

((proj#)

Ihas allocation

Allocated

to

Employee

(Empl#)

Problem 10 Vehicle registration

Problem 11 Medals on a Championship

U

Domicile

Identifies

Lives at

SpecialPlate

SpecialRegoNumbers

identifies

Is identified

RegoLetters

RegoLetters

Is part of rego

Is identified

RegoNunb

RegoNumbers

Is part odf rego

Is identified

Home

(address)

Care

Ownership

Is owned by

owns

Owner

(name)

ORM Schema using binary fact types

* TOTAL

Achieved

Gold

Bronze

Achieved

Medals

(No)

Silver

Achieved

Achieved

Province

(ProvId)

ORM Schema using a ternary fact type

Total Medals *

Has won

In total

Number

(Int)

is number of

Achievement Size

Achievement

Has won

Number

(Int)

Is number of

Medal Type

(colour)

Is earned by

Earns

Province

RoviId)e

Problem 13

Typical fact is here:

Product A in Quarter 1 has reached 2.4 mln $US in sales.

If the year is required to the sale description, the verbalisation will be as follows

Product A in Quarter 1 of 2007 has reached 2.4 mln $US in sales.

Two schema options are presented: Flat - ternary fact type and nested.

Product Sales Value

Achieved for

in

Under sale

Value

($US)

Quarter

(Q_No)

Product

(prod_Id)

Sales Value

Sales

Has reached

Value

($US)

of

Quarter

(Q_No)

in

Under sale

Product

(prod_Id)

Problem 13 (cont)

Quarter

(Q_No)

in

in

Product Sales Value

Achieved for

in

Under sale

Value

($US)

Quarter

(Q_No)

Product

(prod_Id)

Year

(YYYY)

If the year is desired, then the schema must be modified as follows .

Once again two schema options are presented

Sales Value

Sales

Has reached

Value

($US)

of

Quarter

(Q_No)

in

Under sale

Product

(prod_Id)

Problem 15

Election Result

Has achieved

Participation

(%%)

of

Election Result in %%

*

Participation

Has achieved

MPs

(No)

Elected

Election

(Election_ID)

in

Participa-ting

Party

(party_name)

Typical facts are here:

The Labor party in 2008 year election has won 31 seats (in the Parliament)

The Democrats have 10% of seats in the Parliament after 2008 election

Note: the assumption is that there are no more than one election in a single year. If this assumtion is not valid, then other item of election identification could be added : eg 2008/E1 for the first election in 2008

15



Wyszukiwarka

Podobne podstrony:
Sciaga2 by MSun
sciaga by jacek, UE IiE ISIZ, Prezentacje - Sroka, Sroczka, sizm i simeb materiały exam
budownictwo ogolne sciaga by dzik
budownictwo ogolne sciaga by dzik ksiazka
ZJ sciaga by aple4 vol2
socjologia ściaga by MD, GP2, Semestr 2, Socjologia
sciaga?ited by TOM2
wody sciaga by przemodan, edukacja, wykłady i notatki, geologia
Samorząd ściąga by Krupa, GP2, Semestr 2
13 sposobów na ściąganie by bonecollector
Generatory sciaga by PP
ZJ sciaga by aple4
ściąga miue ver by Bhp
ściąga AIRPO by Dyklu
ściąga samorząd by Burza, GP2, Semestr 2
sciaga luc MOD by POTAK, Elektronika i telekomunikacja WAT, Semestr V, SKM, Wykład
sciaga mcik by bumer, Studia, Studia rok I

więcej podobnych podstron