Question: Please I need your help maksue you write SQL script and create table thank you Q1. [Points 30] (Reference: Textbook Minicase MC6) a) Write CREATE

 Please I need your help maksue you write SQL script and

create table thank you Q1. [Points 30] (Reference: Textbook Minicase MC6) a)

Please I need your help maksue you write SQL script and create table thank you

Q1. [Points 30] (Reference: Textbook Minicase MC6) a) Write CREATE TABLE statements to create the tables for the Jones Dozers Sales and Rentals Database depicted by the relational schema created in mini case MC6 in Chapter 3. Use INSERT INTO statements to insert no fewerthan 2 and no more than 10 records per table in the Jones Dozers Sales and Rentals Database b) You are expected to write a SQL script for Q1 a) that uses CREATE TABLE statements generated using ERDPlus. Upon execution of the SQL script, the Jones Dozers Sales and Rentals database structure should be able to be generated. Name your file Mc6-Jones-Dozers.sql. Upload this file as part of your submission. You are expected to write another SQL script using a text editor for Q1 b) that uses INSERT INTO statements. Upon execution of the SQL script, the Jones Dozers Sales and Rentals database tables should be loaded with data. Name your file Mc6-Jones-Dozers-DataLoad. sql. Upload this file as part of your submission

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!