Building the Physical Model

profilelqkishgriddivz
copy_of_lab3datadictionary_1.xlsx
Home>Computer Science homework help>Building the Physical Model

Sheet1

CIS336 Lab #3 Data Dictionary
Table Name Column Name Description of Data Data Type Lgth NOT NULL PK FK Default
ZIPCODE
Zip Zipcode INTEGER 11 Y
City City name VARCHAR 25 Y
State State CHAR 2 Y
INSTRUCTOR
Instructor_ID Instructor id number INTEGER 6 Y
Salutation Greeting VARCHAR 5
First_name First name VARCHAR 25 Y
Last_Name Last name VARCHAR 25 Y
Street_Address Street address VARCHAR 50
Zip Zipcode INTEGER 11 Y Y
STUDENT
Student_ID Student id number INTEGER 6 Y
Salutation Greeting VARCHAR 5
First_name First name VARCHAR 25 Y
Last_Name Last name VARCHAR 25 Y
Street_Address Street address VARCHAR 50
Zip Zipcode INTEGER 11 Y Y
Phone Local phone number VARCHAR 15 Y
Employer Employer VARCHAR 50
Registration_Date Date registered DATE Y
COURSE
Course_ID Course identifier INTEGER 6 Y
Description Course description VARCHAR 50 Y
Cost Cost of course DECIMAL 8,2
Prerequisite Prerequisite course INTEGER 6 Y
SECTION
Section_ID Section identifier INTEGER 8 Y
Course_Section_Num Section number in course INTEGER 6 Y
Start_Date_Time Date and time course begins DATETIME Y
Location Building and room VARCHAR 10
Capacity Max number of students INTEGER 3
Instructor_ID Instructor identifier INTEGER 6 Y Y
Course_ID Course identifier INTEGER 6 Y Y
ENROLLMENT
Section_ID Section identifier INTEGER 8 Y Y
Student_ID Student identifier INTEGER 6 Y Y
Enroll_Date Date of enrollment DATE Y
Final_Grade Grade CHAR 1

Sheet2

Sheet3