Question: 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

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!