ITEC 340 – Spring 2005
Homework 6
National Geographic has hired you to design the database
that will sit behind their new web site EXPEDITION!. The
system will hold information about the world’s highest mountains and the
climbers that conquered them. Data
should include a mountain’s name, height, and location as well as information
on the known expeditions on the mountain.
Included should be the starting date, summit date, and number of camps
for each expedition as well as the climbers in the expedition, how far each
climber went (a camp number or “summit”), their age, their native country, and
whether they lived through the expedition and if not the cause of death. Each expedition has a name which is unique
for that mountain but not necessarily unique for all mountains. For example, there may be a CANADA-98 on
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 Although your author does not do so, please include foreign keys.
· Sample Data
o Create an EXCEL spreadsheet that depicts a relational database 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 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.
Create an RU06 folder in your ITEC 340 submissions folder on Neelix and submit your ERD and Sample Data file by 5:00pm on Wednesday, March 9th.