Question: Chapter 3 database systems, problems, number 2 7 modify the ERD created and problem 2 5 to eliminate the problems created by the use of

Chapter 3 database systems, problems, number 27 modify the ERD created and problem 25 to eliminate the problems created by the use of synonyms (hint : Modify the charter table structure by eliminating, the char pilot and the charcoal pilot attributes, then create a composite table named crew to link the charter and employee tables. Some crewmember such as flight attendants may not be pilots. That's why the employee tables enter into this relationship.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!