ITEC 340 – Spring 2006

Homework 5

APOLLO !

NASA has hired you to design the database that will sit behind their new web site APOLLO!. The system will hold information about the Apollo Program. Data should be kept on the various missions of the program including a mission identifier, information on the goal of each mission, the dates and crew of each mission (including each crew member’s role), and the result of each mission, The data should include basic information on astronauts including firstname, lastname, and birthday.

Required:

· An ERD

o Include minimum and maximum cardinalities for all relationships.

o Label each relationship with a well thought out verb or verb phrase (semantic).

o Your ERD must be done electronically, Visio is recommended.

o Field names must be included and primary keys must be identified.

o Please display foreign keys.

· Sample Data

o Create an EXCEL spreadsheet that depicts a relational database that is an implementation of your ERD.

o Be consistent in table and attribute names as you move from your ERD to your sample tables.

o Your tables should include table and column names.

o Primary keys should be identified.

o Include sufficient sample data to fully articulate the relationships in your ERD. What does this mean? If your ERD shows a one-to-many relationship between entity A and entity B then your sample data should show multiple rows for table B for each row of table A. You can use actually Apollo data or you can make up data as long as it is realistic… ie.Apollo missions should not have a single crew member.

Create an RU05 folder in your ITEC 340 submissions folder on Neelix and submit your ERD and Sample Data file by 5:00pm on Wednesday, March 22nd.