Question: Draw a E - R diagram and write the corresponding formal written description for the following ( very small ) database: An airline asked you

Draw a E-R diagram and write the corresponding formal written description for the following (very small) database: An airline asked you to model a dedicated database that is going to keep track of passengers and their luggage; this database will be used to handle transportation and recovery of lost bags. Each passenger has a frequent flyer id number (that identifies them) a name and an address where the bags may be mailed (there may be several addresses listed in passengers profile). Bags, of course, do not have a unique identifier but they do get numbered at check-in time to distinguish between different bags for any particular passenger. Thus the bag# identifier is guaranteed to be unique per passenger. For each bag we keep track of its color (possibly several colors listed), material and size. Bag size is always specified, while material information does not have to be specified.

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 Programming Questions!