Convert the following Grand Travel Airline entity-relationship diagram intoa well-structured relational database. You must indicate primary key fields with a solidunderline and foreign key fields with a dashed underline. Some fields may be both.

 

Questions are attached to pdf

 

1University of MemphisMIS7605/8605Fall 2016Prof. GillensonExam 1 ProblemsName __________________I. (20 points)Convert the following Grand Travel Airline entity-relationship diagram intoa well-structured relational database.You must indicate primary key fields with a solidunderline and foreign key fields with a dashed underline. Some fields may be both.

Attachments:

• 1495175270-MIS 7605 M1 F16 Online Problems 1.pdf