You are required to use SQL statements to create the database, the tables and insert sufficient data to test the required reports. You will be given two files to commence with (reflecting the database at the end of Assignment1)and these must be updated to include the changes detailed above.
1. Create a text file called YourStudentId-Create.sql (format xxxxxxx-Create.sql) for example 2225991- Create.sql that will:
a. Create a database calledABCYourStudentID (egABC30011111)
b. Creates all of the required tables including primary keys, foreign keys and their relationships.
2. Create a text file called YourStudentId-Insert.sql (format xxxxxxx-Insert.sql) for example 2225991- Insert.sql that will:
a. Insert sufficient data into each table you have created to test the queries. Sample data has been provided, however, you will need to include further data to test all of the required reports.
b. You are required to include your name as one of the customers; you can provide fake details for the address but you are required to include your full name and use your student number as the phone number for this customer.
3. Create a text file called YourStudentId-Queries.sql (format xxxxxxx-Queries.sql - for exam
Attachment:- ITECH1006-5006-201317-Assign2-Spec.pdf