Create an Entity$-$Relationship logical database design diagram for the

following scenario:

The Utopia College in North Bay wants to create a course registration system for its students.

The system should allow students to register for courses, drop courses, view their schedule, and check

their grades. The particulars of the system follows:

Each course has a unique course code, course name, and credits.

Each course offering has a unique section number, start date, end date, meeting time, room

number, and instructor.

The system should allow the college to maintain a record of all enrolled students. The data

captured for each student can be as follows:

First and Last name

Home address $($street$,$ city, province, and postal code$)$

Cell phone number

Email address,

Major

Current GPA.

A course may exist even if no students are currently enrolled in that course.

Each course is taught by exactly one instructor.

Instructors are supervised by a faculty member called a Dean.

A student must select at least one course per term; and therefore registers in at least one section.

$($HINT: Give each table a unique Primary Key.$)$

Complete the following questions:

The relationship between Student and Section is

The relationship between the Dean and the Instructor is called a$($n$)$

Complete the CREATE Table statement for the Faculty table: