HP Integrity NonStop J-Series - Manual (Page 240)

Sample Project-Tracking System
Checking for Normalization
S5044-062
Projects
proj-code
prof-desc
proj-start-date
proj-end-date
prof-mgr
Events
proj-code/
event-num
event-desc
predict-start-date
predict-end-date
revised-start-date
revised-end-date
change-info
update-emp
Respfor
proj-code/
event-num
emp-no
Employs
emp-no
emp-name
emp-dept
Figure 12-8. Possible Relationships Between Files and Keys
Checking for Normalization
A relational data base is usually normalized. In the simplest
terms, this means that no file in the data base contains
repeating data. As Figure 12-8 shows, no file used by the sample
project-tracking system contains repeating groups. Therefore,
these files are sufficiently normalized for use by an ENABLE
application.
If you are developing your own application, refer to Section 3
for a discussion of the normalization process.
12-12