CIS 336 iLab 3 Building the Physical CIS 336 iLab 3 Building the Physical | Page 4
alphanumeric (remember that any formatting within a numeric string makes it alphanumeric).
· If you are inserting a NULL, do not enclose the word NULL in single quotes, as this will insert
the
word NULL into the row. To insert a null you simply use the word NULL.
Deliverables
The deliverable for this lab will include the following documents.
1. Your script file. Create this file in Notepad, or another PURE TEXT editor—NOT Word. Make
sure
your name is in a comment area at the top of the script file. Use a double dash to create a one-
line comment.
–Jane Smith
–Lab 3
2. Your script file must execute without error. It is recommended that you begin early in the
week,
and post any questions to the Q & A discussion in order to produce a working script by the due
date.
Be sure your name is on all documents and that all documents have been included in a single
zip file for
this week’s assignments.
Refer to the following ERD in constructing your solution.
Student
PKStudent_ID
Salutation
First_Name
Last_Name
Street_Address