Question: 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
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. 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 number identifier is guaranteed to be unique per passenger. For each bag we keep track of its color several colors, material and size. Bag size is always specified, while material information does not have to be specified. Present a diagram and write the corresponding formal description for the database
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
