It needs to be done on visio.

I also need explaination on the relationship part.

OBJECTIVE

The main goal in this assignment is modelling databases. You are required to complete the

following requirements for the Case 'University Classes' in section $2$ below. Keep in mind that

an ERD cannot model all aspects of a database application.

Read the entire document first. Then, model all the related Entities and relationships. For

each entity, you should indicate its attributes, primary key $($simple or composite$),$ and foreign

key$(s).$ Develop the following three items:

Item$-1$: Dependency Diagrams for each entity type $($show that there are no partial or

transitive dependencies$)$;

Item$-2$: a completed E$-$R diagram that satisfies the $3_{{?}^{?}}(rd)$ Normal Form, along with its

corresponding Transformed Flat Tables;

Item$-3$: a completed Data Dictionary.

SCENARIO: UNIVERSITY CLASSES

This scenario models the courses, students, professors, departments, and the like at a single

university in a single semester. Based on the following scenario, you are expected to figure out an

associative entity, a self$-$recursive relationship, and the aspects that cannot be reflected in your

ERD.

$(1)$ Each student has a SID, a name, and an address.

$(2)$ A professor has a PID, a name and belongs to a department. The age of a professor can be

one of "old," "very old," and "still alive".

$(3)$ Each course has a number, a name, a credit hour number, an offering department, a classroom,

a maximum enrollment, and an actual enrollment.

$(4)$ The actual enrollment must be no more than the maximum enrollment.

$(5)$ Each department has an ID and a unique name.

$(6)$ Each student enrolls in a certain number of courses in this semester.

$(7)$ Each course, after assigned, is fully handled by one professor only.

$(8)$ A course can have multiple pre$-$requisites. A course can be a pre$-$requisite for multiple other

courses. However, a course cannot be a pre$-$requisite for itself.

$(9)$ A student enrolled in a course must have enrolled in all its pre$-$requisites.

$(10)$ At this university, more than one professor can teach a course