Assignment 1 – Database Management, 90-746

Drawing an Entity Relationship Diagram

Due: Thursday, September 9, 1999

Solution: ERD Diagram, and HBA Schema

Horizon Bound Airlines (HBA) makes daily flights between cities in the continental United States. The major resources of which its information system must keep track are airplanes and flight employees. Each flight that is scheduled must have at least one pilot and at least one crew member (e.g., steward, stewardess). In addition, each flight will have a departure time and location as well as a destination time and location. Pilots and crew members have respective home bases, to which they return at the end of an assigned flight. Each airplane has an assigned maintenance base.

Draw an ERD based on the above scenario. Apply what you have learned about cardinality and generalization/specialization to your development of the diagram. Remember to resolve many-to-many relationships by using relational entities when necessary. If you make assumptions about HBA which will affect the way you draw your diagram, include those assumptions in your solution.

Please include a list of attributes for each entity in your diagram. You don’t need to make your lists complete. Just give enough attributes to show your understanding of what the entity is, what kind of data describe it. For each entity, identify the primary key.

You may use MS Word or PowerPoint to draw your ERD. You can also use a CASE or modeling tool to draw the diagram. If you do, please identify in your homework which tool you used. For your attribute lists, you may use either the bubble or word list notation we saw in class. Or, you can simply include an additional page listing out the entities and attributes.