Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Create a separate sql file for each create_table statements, chapter 3, slide 22 2. run the files on MySQL client and create tables 3.

  1. 1. Create a separate sql file for each create_table statements, chapter 3, slide 22

2. run the files on MySQL client and create tables

3. create another sql file (insert_data.sql) to insert data into the tables. data is in the textbook. insert at least 5 records.

4. show the contents of the tables by typing:

select * from supplier;

select * from shipment;

select * from part;

5. include all your files and also outputs in a zip file and submit

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

Databases Illuminated

Authors: Catherine Ricardo

2nd Edition

1449606008, 978-1449606008

More Books

Students also viewed these Databases questions