Database Answer the following questions: [5 points] Name one weak entity set. [5

Question

Database

Answer the following questions:

[5 points] Name one weak entity set.

[5 points] Name one recursive relationship set.

[5 points] What does the double line that joins the entity set instructor with the relationship set inst_dep indicate?

[5 points] What does the double-lined diamond shape around the relationship set sec_course indicate?

[30 points] Translate the lower part of the University E-R diagram, which is shown below into a relational database (i.e., translate this part of the E-R diagram into relational schemas.)

Course title credits prereq course id prereq id Sec course section time slot sec id Semester sec time slot time slot id day Wear start time end time sec class classroom buildin room number capacity

Explanation / Answer

Solution:

No weak entity set is shown in the figure., weak entities are outlined with double line in ER diagram.

sec_course and sec_time_slot is recursive relationship set.

Double lines indicates that there is a recursive relationship between entity set instructor with the set inst_dep

It shows that sec_course is an identifying relationship.

I hope this helps. Don't forget to give a thumbs up if you like this.

Related Questions

Navigate

• Browse (All)
• Browse D
• Subjects

---

---

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