Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Consider the E-R diagram for the university database. Answer the following questions: [5 points] Name one weak entity set. [5 points] Name one recursive relationship

Consider the E-R diagram for the university 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.)

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems 6th Asian Conference Aciids 2014 Bangkok Thailand April 7 9 2014 Proceedings Part I 9 2014 Proceedings Part 1 Lnai 8397

Authors: Ngoc-Thanh Nguyen ,Boonwat Attachoo ,Bogdan Trawinski ,Kulwadee Somboonviwat

2014th Edition

3319054759, 978-3319054759

More Books

Students also viewed these Databases questions

Question

5. Develop the succession planning review.

Answered: 1 week ago