This is database system concept.

Consider the E-R diagram for the university database.

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?

4.What does the double-lined diamond shape around the relationship set sec_course indicate?

5.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.)

department dept name course dept building budget stud dept nst dept student instructor advisor name tot cred salary takes grade teaches section course time slot see id course id course title sec semester sec time slo time slot id veat credits day start time end time prereq prereq id sec class classroom uildin room number capacity Figure 7.15 E-R diagram for a university enterprise