Consider the E-R diagram for the university database given below. Answer the fol

Question

Consider the E-R diagram for the university database given below. Answer the following questions:

1. Name one weak entity set.

2. Name one recursive relationship set.

3. What does the double line that joins the entity set instructor with the relationship set inst_dep indicate?

course dept inst dept instructor name salary teaches course course id Sec Course title credits prereq prereq id course id department dept name building budget stud dept student ID advisor name tot cred takes grade section time slot sec id. semester sec time slot time slot id day start time end time sec class classroom build in room number capacity

Explanation / Answer

1. Ans:-
- Weak entity is "Section".
- Discrimators of a weak entity are represented by a dashed line.
- Weak entity set is represented by either a single bold or double rectangles.

2. Ans:-
- "Course" entity set is relating to itself thus, gives rise to Recursive relationship as shown in the figure.

3.Ans:-
- double line that joins the entity set instructor with the relationship set inst_dep indicates a sign of total participation of the instructor in the relationship set.

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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