Question

course_id course_dept instructor ID name salary inst_dept department dept name building budget teaches stud_dept advisor student ID name tot_cred takes grade course course id title credits prereq prereq_id sec_course section sec_id. semester year sec_class sec_time_slot time_slot time slot id { day start_time end_time { classroom building room number capacity

          course_id
course_dept
instructor
ID
name
salary
inst_dept
department
dept name
building
budget
teaches
stud_dept
advisor
student
ID
name
tot_cred
takes
grade
course
course id
title
credits
prereq
prereq_id
sec_course
section
sec_id.
semester
year
sec_class
sec_time_slot
time_slot
time slot id
{ day
start_time
end_time
{
classroom
building
room number
capacity

courseid
coursedept
instructor
ID
name
salary
instdept
department
dept name
building
budget
teaches
studdept
advisor
student
ID
name
totcred
takes
grade
course
course id
title
credits
prereq
prereqid
seccourse
section
secid.
semester
year
secclass
sectimeslot
timeslot
time slot id
day
starttime
endtime

classroom
building
room number
capacity

Added by Lisa A.

Computer Science and Information Technology

Trishna Knowledge Systems 2018 Edition

Instant Answer

Solved by Expert Anecia Mcmurrin-Bala

Step 1

One weak entity set in the given E-R diagram is the "section" entity set. This is because the section entity set is dependent on the course entity set, and cannot exist without it. The section entity set's primary key includes the foreign key course_id, which Show more…

Show all steps

Thanks for your feedback!

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? department (dept_name, building, budget) course_dept inst_dept stud_dept instructor (ID, name, salary) student (ID, name, tot_cred) advisor teaches takes grade section (sec_id, semester, year) course (course_id, title, credits) time_slot sec_course sec_time_slot time_slot (time_slot_id, day, start_time, end_time) prereq course_id prereq_id sec_class classroom (building, room_number, capacity)