Database Design for College: ER Diagram, Summary, and Implementation Plan

Database Design
Student Name :
Professor Name :
Course Title :
Date :

Documentation
Section 1: Database Design Diagram
The Entity Relationship Diagram (Elmasri, 2016) for the college database in Chen’s notation
(Bagui, 2011) is given below.
The table below list the entities and attributes of each of the entity involved in the ER-Diagram.
S. No Entities Attributes
1 Instructor Instructor ID (Primary Key)
Instructor Name
Instructor Address
Instructor Phone Number
Designation
Salary
2 Course Course ID (Primary Key)
Course Name
Course Description
Course Credit
3 Student Student ID (Primary Key)
Student Name
Student Address
Student Phone Number
Student DOB
Student Gender