Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

+ 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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Object Databases The Essentials

Authors: Mary E. S. Loomis

1st Edition

020156341X, 978-0201563412

More Books

Students also viewed these Databases questions

Question

How do you add two harmonic motions having different frequencies?

Answered: 1 week ago