Problem: You have been tasked with designing a database for a university registration

system. The system allows students to enroll in courses offered by the university. Each

course consists of multiple sections, and students can enroll in multiple courses.

Additionally, students can enroll in multiple sections of the same course. The university

needs to track various information about students, courses, and their enrollment.

Requirements: The following business rules apply:

A student can enroll in multiple courses.

Each course has a unique course ID and a title.

A course is offered through multiple sections, each identified by a unique

combination of course code and section number.

Students enroll in sections of courses. A student can enroll in multiple sections.

For each section, the university needs to track the student's final grade.

The university wants to maintain records of each student's full name, full address,

email address$($es$),$ and final grades.

Assignment: Design a database in third$-$normal form $(3$NF$),$ which is worth $25$ points of

your midterm. Requirements:

The submission must be done in a database design tool such as Lucidchart or

Visio. Handwritten submissions, or those created in a general tool such as

PowerPoint, will not be accepted.

Model must have a clear, unambiguous, and accurate business definition of each

entity.

Model must identify all foreign and primary keys

Rubric:

Entities are correct and have high$-$quality definitions $(5$ points$)$

Model correctly identifies the primary keys in the model as submitted $(5$ points$)$

Model correctly identifies the foreign keys in the model as submitted $(5$ points$)$

Cardinality is consistent with the business rules $(5$ points$)$

Model conforms to third$-$normal form $(5$ points$)$

All attributes are atomic $($indivisible$).$

There are no transitive dependencies.

Each non$-$prime attribute is fully functionally dependent on the

primary key.

Submission format:

Electronic document, such as $.$pdf

Due date and time:

Monday, June $3$rd at $10$:$29$AM$.$

No late assignments will be accepted without prior approval.