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

![create table thank you Q1. [Points 30] (Reference: Textbook Minicase MC6) a)](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2024/09/66f2f916c6b2d_51066f2f91645d99.jpg)
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
Get step-by-step solutions from verified subject matter experts
