ISTINYE Course Name:

UNIVERSITY

I S T A N B U L

Course Code:

Software System

Analysis and

Design

SWE $307-$ Fall

$2023-2024$

Date:

$31\mathrm{.}01\mathrm{.}2024$

$75$min.

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$,$ ii and iv$.$ Write the components

and main entities through this relationship.

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

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$)$