CIS 336 iLab 3 Building the Physical CIS 336 iLab 3 Building the Physical | Page 6

ERD (provided above) for this lab. Be sure to follow the guidelines given above on how and
where to
create the different types of constraints for each table. This will include PK, FK, and NOT NULL
constraints.
STEP 3: The INSERT Statements for the Data
The third step is to create the insert statements to insert the sample data into the tables
created in
Step 2. The data for each table is contained in text files, named for the table whose data it
contains.
Modify the format of the data (e.g., date formats and add or eliminate quote marks) as needed
to craft
your insert statements, but do not change the inherent value of the data.
STEP 4: The SELECT Statements
The next step of the lab will be to create the select statements to verify the data was inserted
correctly. You should have six select statements; one for each table. The command is SELECT *
FROM
Table_Name; For example, to select all columns from the Student table, the command would
be
SELECT * FROM student;
Be sure to save all of the above statements in your script file.
STEP 5: Testing and Verifying Your Script
Now we come to the point of verifying that your script file works by creating all of the tables
and
inserting and selecting all of the data. Your script should execute without errors, and select the
entire
contents of each table in turn. Inspect your query results to ensure that each column and row
from