Computer Science

Below are the entities and attributes as per the 3NF relations.

Course (

Course ID ,

Course Name,

Course Title)

Student (

Student Number ,

Name,

Major

)

Instructor (

Instructor ID ,

Instructor Name,

Instructor Location

)

Location (

Zip Code ,

Street,

City,

Country

)

Results (

Student ID ,

Course ID ,

Grade

)

Primary Keys – indicated in bold and underline.

Foreign Keys – indicated in bold.

Unique keys indicated by indent.

The instructor location is referenced to the zip code in Location entity.