Question: Design a relational database containing information about music computers, their lives and their compositions, but avoid redundancies similar to those in Figure 9.4 contains inlU
Design a relational database containing information about music computers, their lives and their compositions, but avoid redundancies similar to those in Figure 9.4 
contains inlU ber, address, Social Securly company (job identification, job title, u igure 9.4 A relation containing redundancy Job ld Job Title Skill Code Dept Start Date Term Date Empl ld Name Address SSN F5 Floor FM3 Sales 9-1-2009 9-30-2010 25X15 Joe E. 33 Nowhere 122333 25X15 Joe E 33 Nowhere 111223333 Baker manager D7 Dept. head Sales 10-1-2010 K2 Baker 34Y70 Cheryl H. 563 Downtown 999009999 F5 Floor Sales 10-1-2009 Clark Smith Smith Ave. manager 23Y34 G. Jerr 155 Cirle 1005555 525X Secretary T5 Personnel 3-1-1999 4-30-2010 23Y34 G. Jerry 1555 Circle 111005555 S26z Secretary T6 Accounting 5-1-2010 contains inlU ber, address, Social Securly company (job identification, job title, u igure 9.4 A relation containing redundancy Job ld Job Title Skill Code Dept Start Date Term Date Empl ld Name Address SSN F5 Floor FM3 Sales 9-1-2009 9-30-2010 25X15 Joe E. 33 Nowhere 122333 25X15 Joe E 33 Nowhere 111223333 Baker manager D7 Dept. head Sales 10-1-2010 K2 Baker 34Y70 Cheryl H. 563 Downtown 999009999 F5 Floor Sales 10-1-2009 Clark Smith Smith Ave. manager 23Y34 G. Jerr 155 Cirle 1005555 525X Secretary T5 Personnel 3-1-1999 4-30-2010 23Y34 G. Jerry 1555 Circle 111005555 S26z Secretary T6 Accounting 5-1-2010
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
