Question

In this project you will develop a logical design of a relational university database system

by capturing data dependency and performing a complete and optimal normalization
process. The database has the following attributes: CLASS, SECTION, STUDENT,
MAJOR, EXAM, YEAR, INSTRUCTOR, RANK, SALARY, TEXT, DAY, and ROOM.
Intuitively a given CLASS (such as ECE20001) is divided into SECTIONs (such as
Section 2)) each of which has one INSTRUCTOR (such as Smith) and various
STUDENTS (such as Kelly). Each CLASS has a set of TEXTS (such as Introductory
Electric Circuit Analysis), which are used by all SECTIONS of the CLASS. Each SECTION
of a CLASS has various meeting DAYS (such as Wednesday) and on a given DAY, it
meets in one ROOM (such as MSEE239). Each STUDENT has one MAJOR (such as
EE), and one YEAR (such as Sophomore). A STUDENT in a given CLASS and SECTION
has several EXAM scores (such as 93 percent). Each INSTRUCTOR has one RANK
(such as Associate Professor) and one SALARY (such as $90K).
1. Draw a detailed ER model of the above database. Identify degree of relationship,
attributes, and type of participation of all entities Give explanation and reasoning
of your ER model

Answer 1

This detailed answer explains how to draw a detailed ER model of a university database system, including the relationships and attributes of each entity involved.

Step-by-step explanation:

ER Model of the University Database System:

• The entities in this database include CLASS, SECTION, STUDENT, MAJOR, EXAM, YEAR, INSTRUCTOR, and TEXT, each with their respective attributes.
• The relationship between CLASS and SECTION is a one-to-many relationship, where one CLASS can have multiple SECTIONS.
• The relationship between SECTION and INSTRUCTOR is a one-to-many relationship, where one SECTION can have one INSTRUCTOR.
• The relationship between CLASS and TEXT is a many-to-many relationship, where multiple TEXTS can be used by multiple CLASSES and SECTIONS.
• The relationship between SECTION and DAY is a many-to-many relationship, where multiple DAYS can be associated with multiple SECTIONS.
• The relationship between DAY and ROOM is a one-to-many relationship, where one DAY can be associated with one ROOM.
• The relationship between STUDENT and MAJOR is a one-to-one relationship, where one STUDENT can have one MAJOR.
• The relationship between STUDENT and YEAR is a one-to-one relationship, where one STUDENT can have one YEAR.
• The relationship between STUDENT and EXAM is a one-to-many relationship, where one STUDENT can have multiple EXAM scores.
• The relationship between INSTRUCTOR and RANK is a one-to-one relationship, where one INSTRUCTOR can have one RANK.
• The relationship between INSTRUCTOR and SALARY is a one-to-one relationship, where one INSTRUCTOR can have one SALARY.