1. (25 points) Following are details of space shuttle flights in 2000. Draw a data model to record details of flights, shuttles, and commanders. NASA requires you to record details of the commander such as full name and date of birth. For a shuttle, it wants to know the date it was built.

Flight	Shuttle	Launch date	Objective	Crew size	Commander
97	Endeavour	02-11-2000	Shuttle Radar Topographic Mission	6	Kregel
98	Atlantis	05-19-2000	ISS-2A.2 SpaceLab Double Cargo Module	7	Halsell
99	Atlantis	09-08-2000	ISS-ISS-2A.2B Outfitting ISS	7	Wilcutt
100	Discovery	10-11-2000	ISS-3A Integrated Truss Structure Z1, PMA-3, CMG's	7	Duffy
101	Endeavour	11-30-2000	ISS-4A ITS P6, Photovoltaic Module, Radiators	5	Kregel

2. (15 points) Create the database designed in answer to question 5. Create the table in the database you use and copy and paste the table creation script here.

3. (10 points) Populate the database created in answer to question 6. Populate the table in the database you use and copy and paste the table insertion script here. Your data should include that provided in the chart a