CIS 336 STUDY Future Starts Here/cis336study.com CIS 336 STUDY Future Starts Here/cis336study.com | Page 56

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 st atements 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