Please read the question carefully Write the corresponding requirements specific

Question

Please read the question carefully

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 relationship - Attributes of each entity and relationship (if any) - primary key (PK) - Foreign key (FK)

ment course dept building budget inst dept stud dept instructor TD student ID advisor salary tot cred teaches takes grade section Course time slot saci seneste ACar time sl sec course title credits tday start hwie course id prereq id see class classroomm bunding University database ER diagram for question 2.

Explanation / Answer

Hi,

Please find below the answer-

Ans a) A university has various instructors. It offers various courses. The university has various classrooms. Classroom has various sections.Student is a part of any section. An instructor advises the student. A Department has number of instructors. each section has a time slot assigned to it. The session will run for that time frame alone.An instructor teaches in various sections. Student takes grade after the exams.Each section has number of courses. A department can offer more than one course.

Ans b)
Entities, Attributes and primary keys-
1. department(dept_name,building,budget)
2. student(id, name,tot_cred)
3. Section(sec_id,semester,year)
4. instructor(id,name,salary)
5. course(course_id,title,credits)
6. classroom(building,room_number_capacity)
7. time_slot(time_slot_id,day,start_time,end_time)

Weak entity-
1. sec_course

Relationship-
1. course - department ---> many to one relationship
2. student- department ---> many to one relationship
3. course - section ---> many to one relationship
4. instructor- section ---> one to many relationship
5. section - course ---> many to one relationship
6. instructor- department ---> many to one relationship
7. section - time_slot ---> many to one relationship

Regards,

Vinay

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---

---

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