Identify the entities about which the associated data will be collected and designed.

A college decided to replace their old file system with the relational database one. The college’s IT department has hired a database designer to design a database for their students, courses, classes, and instructors to easily keeping track of their student’s enrollment and assigning classes to the courses. On the other hand, they want to make sure no two courses will be taught at the same date/time in the same classroom.

1 – Identify the entities about which the associated data will be collected and designed

2 – Define the entities attributes

3 – Create an efficient entity relationship diagram and a relational diagram showing the tables representing the entities and their attributes

4 – Create the relationship among the tables using the Primary and Foreign keys