Schema Translation - Information Systems Reengineering, Integration and Normalization - page 135

'(3$570(17

'B1DPH

+$6B0$-256

2))(56

&2856( 678'(17

&RXUVHQDPH&RXUVHBQXPEHU &UHGLWBKRXUV 1DPH WXGHQWB1XPEHU ODVV

+$6B6(&7,216

,6B:,7+B35(5(4

+$6B35(5(4

6(&7,21

+$6B*5$'(6

35(5(48,6,7(

6HPHVWHU HDU ,QVWUXFWRU

6HFWLRQB,GHQWLILHU

75$16&5,37

+$6B678'(176

*UDGH

Question 3.2
Translate the following hierarchical database schema into network database DDL
and also into a relational schema.

'(3$570(17

'B1DPH

&2856( 678'(17

&RXUHBQDPH &RXUVHBQXPEHU &UHGLWBKRXUV 1DPH WXGHQWB1XPEHU &ODVV

6(&7,21

35(5(48,6,7(

6HPHVWHU HDU ,QVWUXFWRU

6HFWLRQB,GHQWLILHU

75$16&5,37

*UDGH