To design a college student information system, you need to create an

Entity$-$Relationship $($E$-$R$)$ model.

A$.$ Main Assets $($Assets$)$

Identify the main assets in your system. "Student", "Course", "Lecturer", "Faculty"

Identify three characteristics $($features$)$ for each entity.

"Student ID$",$ "Name Surname" and "Registration Date" for the "Student" entity

"Course ID$",$ "Course Name" and "Credit" for the "Course" entity

"Course ID$",$ "Faculty Name" and "Department" for the "Lecturer" entity

"Faculty ID$",$ "Faculty Name" and "Faculty Location" for the "Faculty" entity

B$.$ Relationships and Connections:

Briefly explain the relationship between the entities i$,$ ii$,$ iii and iv$.$ Write the components

and main entities through this relationship.

i$.$ A relationship is established between the "Student" and "Course" entities. Indicate

when the student enrolled in this course.

ii$.$ A relationship is established between the "Student" and "Lecturer" entities. Indicate

which lecturer the student is affiliated with through this relationship.

iii. A relationship is established between "Lecturer" and "Faculty" units. Using this

relationship, write how many students a faculty member has in faculty.

iv$.$ A relationship is established between "Course" and "Faculty" units. Using this

relationship, write whether this course is a compulsory course of the faculty.

Draw the components and connections in the Entity Relationships diagram using

equivalent symbols. $(40$ point$)$