CIS336 Lab 3 ERD
Student
PKStudent_ID
Salutation
First_Name
Last_Name
Street_Address
Phone
Employer
Registration_Date
FK1Zip
Zipcode
PKZip
City
State
Enrollment
PK,FK1Section_ID
PK,FK2Student_ID
Enroll_Date
Final_Grade
Course
PKCourse_ID
Description
Cost
FK1Prerequisite
Section
PKSection_ID
Course_Section_Num
Start_Date_Time
Location
Capacity
FK1Instructor_ID
FK2Course_ID
Instructor
PKInstructor_ID
�
Table