Question: DataBase please i need help it is due today + 2 , Fit to page [.b Page view | A* Read aloud L Add no

DataBase please i need help it is due today

DataBase please i need help it is due today + 2 ,Fit to page [.b Page view | A* Read aloud L Add

+ 2 , Fit to page [.b Page view | A* Read aloud L Add no es | Instructions 1. Reread Coulson's 3NF Tutorial: http://phlonx.com/resourcesf3 2. Write the SQL required to create the following table structures in a MySQL database. Be sure to select appropriate data types and metadata. Enforce referential integrity with properly defined primary and foreign keys order items tems orders order id order_id (PK) customer id (FK) order date d((F )}(PK) item id (PK) tem description temprice (PK) tem id (FK) tem qty customers customer_id (PK) customer name customer address customer_city customer_state + 2 , Fit to page [.b Page view | A* Read aloud L Add no es | 3. Write the SQL required to populate each table with the appropriate data. order items: Table orders : Table 10 id item 125 563 125 851 125 652 126 563 126 652 order id customer idorder date 32 125 126 9/13/2002 2 9/14/2002 500 750 Record: I items : lable tem id customers : lable em descrition item price 3.50 851 Spline End ra Lage) $0 25 $12.00 customer id customer narme customer addre customer cit customer state 563 56" Blue Freen 56 Foo, Inc 2 Freens R Us 23 Main St, Thi Thorpleburg 1600 Pennsylva Washington TX DC 652 3t Red Freen Record: Record: I 4 of 4 4. The SQL for steps 2 and 3 should be included in a single file called assignment5_lastname firstname.sql where lastname and firstname are the student':s last and first name. Test your SQL script thoroughly. A properly functioning script should run without errors or warnings, and produce the database structures with the correct data. 5

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!