For this lab , you will be creating SQL statements to build a series of relational tables , using SQL CREATE
statements in a script file format for the Student Database . You will then populate those tables through
the use of INSERT statements with sample data .
You will need to create a script file and name it YourName _ Lab3 . txt containing the following code .
1 . The drop table statements listed later in the specifications of this lab . 2 . The CREATE TABLE statements required to build the six tables . 3 . The INSERT statements necessary to insert all of the sample data .
4 . Six select statements to verify that the data is in the tables and accessible .
To help you accomplish this task successfully , you are being supplied with the ERD Diagram which
follows , and the exact data to be inserted into each table , which may be found via the Doc Sharing tab
on the course website .
The following guidelines are being provided to help assist you in creating your script file .
· Use the names for the tables and columns as listed in the ERD . Do not change them as it will
affect your grade .
· Creating Constraints