Database Reference
In-Depth Information
EMPLOYEE
EmpId
Name
Salary
PosnId
DptNo
100
140
160
190
110
120
180
200
130
Simpson
35000
ANLY
TECH
TECH
DBAM
ANLY
ANLY
PGMR
PGMR
ANLY
3
2
4
1
5
5
6
6
3
Beeton
28000
Davis
30000
PROJECT
Berger
45000
ProjNo
ProjDesc
Covino
34000
Brown
35000
23
14
36
45
48
25
31
11
12
13
DB design
Network cabling
Network testing
Physical design
Space allocation
Reports
Forms
Order entry
Inventory Control
Smith
30000
Rogers
32000
Clemens
38000
DEPARTMENT
POSITION
DptNo
DeptName Manager
PosnId
Position
Bonus
3
2
4
1
5
6
Design
Ross
Operations
Invoicing
Martin
ANLY
TECH
DBAM
PGMR
Analyst
5000
Tech Suprt
Lucero
Technician
3000
DB Suprt
Rawlins
DBA
6000
Analysis
Williams
Programming
Goldner
Programmer
4000
Figure 10-6
Data model in Boyce-Codd normal form - part 1.
EMPLOYEE-PROJECT
EmpId
ProjNo
Start
End
Hrs
CHRG-EMP
PROJ-CHRG
100
140
160
160
190
190
100
110
110
120
180
180
200
200
200
100
130
23
14
14
36
45
48
25
31
25
11
31
25
11
12
13
31
23
Apr-02
Jul-02
200
ChrgCD
EmpId
ProjN
o
ChrgCD
Sep-02
Oct-02
120
Sep-02
Nov-02
150
2
14
1
3
45
4
25
3
25
11
3
25
1
1
13
3
23
D100
N140
S160
S160
D190
S190
C100
D110
D110
D120
C180
C180
D200
P200
P200
D100
D130
C100
C180
D100
D110
D120
D130
D190
D200
N140
P200
S160
S190
100
180
100
110
120
130
190
200
140
200
160
190
Nov-02
Dec-02
100
Aug-02
Nov-02
300
Nov-02
Dec-02
80
Oct-02
Nov-02
100
Mar-02
May-02
120
May-02
Jul-02
150
Jul-02
Sep-02
300
Sep-02
Nov-02
250
Nov-02
Dec-02
200
Sep-02
Oct-02
200
Nov-02
Dec-02
200
Nov-02
Dec-02
100
Aug-02
Oct-02
150
Apr-02
Jun-02
200
Figure 10-7
Data model in Boyce-Codd normal form - part 2.
We want to examine the resultant data model further and check whether any
other types of discrepancies are likely to be present. Occasionally, you may have to
take additional steps and go to higher normal forms. Let us consider the nature of
higher normal forms and study the remedies necessary to reach these higher normal
forms.
Search WWH ::
Custom Search