Data Normalization - Information Systems Reengineering, Integration and Normalization - page 366

Teaching

idref
0

* * * *

* * * *

id0

sname

hnamw

(e)
Retirement
Plan

(f)
Hourly
Rate

(a)
Employee

(g,h,i)
Course

(I, j)
Tutor

(i)
Student

(j)
Lecturer

(j)
Professor

id4 id8

?

(b)
Head

Age

?

+

id7

*

+

id6 idref

67

id2 id3

idref
8

dname (b,c)

Department

idref
4

(c,d,h)
Instructor

idref
1

(g)
Lab

(g)
Lecture

(i)
Artifact8

|

id1

| *

lbname ltname

(h)
Artifact4

(d)
Full Time

(d)
Part Time

Evaluation

pname

idref
4

idref
2

idref
3

fname

Fig. 9.20 A minimum fragmented and data redundancy freed XML schema

dancy. The revised XML schema stores the data semantics of the derived efficient
XML schema design in Fig. 9.20 is as follows:
The data redundancy freed XML document of Fig. 9.18 has eight fragments un-
der the root element Teaching which is fewer than the ten fragments in the initial
XML schema design in case study as follows: