Directions

Create the following five entities using the fields listed below.

Tables:

Student

Course

Zip$\_$code

Schedule

StudentAddress

Instructor

Fields: StudentID $(3),$ Instructor$\_$ID $(2),$ City, Student$\_$firstname, Zipcode $(2),$ State, CourseID $(2),$

Course$\_$num, Instructor$\_$firstname, Course$\_$section, Address$\_$type, Student$\_$lastname, Street, DOB,

year, grade, Entry$\_$date, Instructor$\_$lastname, Instructor$\_$phone, gender, Course$\_$description,

course$\_$hours, semester,

Please finish adding the fields to the entities below. Underline the primary key field$($s$)$ for each table.

Entities

Student$($StudentID$,$ St$\_$FirstName, St$\_$LastName, DOB, Entry$\_$Date, Gender$)$

Course$($

Zip$\_$code$($

Student$\_$address$($

Instructor$($

Schedule$($StudentID$,$ CourseID, Semester, Year, InstructorID, Grade$)$