PLEASE ANSWER THIS COMPLETELY AND PROPERLY.

complete the database design outline, like such ex) for a flight:

FLIGHT(FlightNumber, OriginAirport, DepartureTime, DestinationAirport, ArrivalTime) FLIESONDAY(FlightNumber, Day, PlaneCode) FlightNumber foreign key to FLIGHT PlaneCode foreign key to KINDOFPLANE KINDOFPLANE(PlaneCode, FullPlaneName, SeatingCapacity)

THIS IS THE THIRD TIME THIS QUESTION IS BEING ASKED PLEASE ANSWER IT PROPERLY!!!!!!! WITH THE ABOVE FORMAT ONLY.

3. Following table keeps track of temporary worker assignments at a firm, one row per assignment. Note that the rate per hour is negotiated separately for each assignment. Design a third normal-form database storing the same information. Draw an ER diagram, and write a database design outline. Assignment ID Temp Code Temp Name Dept Code Dept Name Job Code Job Description Date Hours Spent Rate /hour 11772 1013 Bill Wong ENG Engineering TC 2/27/2011 3 $100 11765 1015 Melanie East MKT Marketing TC 1/25/2011 4 $120 11767 2051 $50 Ed North Ed North ACT MKT 2051 Accounting CLR Marketing CLR Sales SC 11768 11769 $55 1/31/2011 2 2/10/2011 4 4 2/15/2011 5 3356 John Edokway Technical Consulting Technical Consulting Clerical Clerical Strategic Consulting Editing Editing Technical Consulting Editing SLS $90 11773 3356 $60 11771 4076 John Edokway MKT Marissa Estevez ENG Hannah Goldberg ENG Marketing EDT Engineering EDT Engineering TC 3/20/2011 6 2/26/2011 7 7 1/25/2011 4 $65 11766 4079 $110 11770 4079 Hannah Goldberg MKT Marketing EDT 2/25/2011 5 $70 3. Following table keeps track of temporary worker assignments at a firm, one row per assignment. Note that the rate per hour is negotiated separately for each assignment. Design a third normal-form database storing the same information. Draw an ER diagram, and write a database design outline. Assignment ID Temp Code Temp Name Dept Code Dept Name Job Code Job Description Date Hours Spent Rate /hour 11772 1013 Bill Wong ENG Engineering TC 2/27/2011 3 $100 11765 1015 Melanie East MKT Marketing TC 1/25/2011 4 $120 11767 2051 $50 Ed North Ed North ACT MKT 2051 Accounting CLR Marketing CLR Sales SC 11768 11769 $55 1/31/2011 2 2/10/2011 4 4 2/15/2011 5 3356 John Edokway Technical Consulting Technical Consulting Clerical Clerical Strategic Consulting Editing Editing Technical Consulting Editing SLS $90 11773 3356 $60 11771 4076 John Edokway MKT Marissa Estevez ENG Hannah Goldberg ENG Marketing EDT Engineering EDT Engineering TC 3/20/2011 6 2/26/2011 7 7 1/25/2011 4 $65 11766 4079 $110 11770 4079 Hannah Goldberg MKT Marketing EDT 2/25/2011 5 $70