Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
+ 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started