Database systems 2. (40 POINTS) Following is an ER diagram for a university 2.A.

Question

Database systems

2. (40 POINTS) Following is an ER diagram for a university 2.A.) (25 POINTS) Write the corresponding requirements specifications for this ER design Please make sure to consider each component. A good suggestion is to cross out each component as you process it so that nothing is left out. 2.B.) (15 POINTS) Specify the details for the following items: - Entities, weak entities, corresponding identifying relationship Relationships, degree of each relationshijp Attributes of each entity and relationship (if any) primary key (PK) Foreign key (FK)

Explanation / Answer

Question 1

In the following ERD the student takes up a course.Each student is enrolled for a particular course is registered to a particular department.For each department and each course there is a particular instructor.Each instructor is allocated in particular class.Each class has a definate time slot and a particular classroom where it will take place.Each course has a particular department which has a particular class alocated at a particular time.

Question 2

Department

dept_name - Primary Key

Student

ID-Primary Key

Section

sec_id-Primary Key

Instructor

ID-Primary Key

Course

Course_id-Primary Key

Classroom

building-Primary Key

Time_Slot

time_slot_id - Primary Key

Relatioship

a.Student allocated in the department
b.Instructor advises student
c.Each isntructor has a particular department
d.Each section has student.
e.Instructor teaches in a particular section.
f.Each department has a particular course
g.Each section has allocated course
h.Each section has a particular time slot

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.