Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

QUESTION 8 Note: Questions 8 to 13 will all deal with developing relational schemas based on the following ERD. I recommend that you try to

image text in transcribed

image text in transcribed

QUESTION 8 Note: Questions 8 to 13 will all deal with developing relational schemas based on the following ERD. I recommend that you try to translate the complete ERD first, and then answer questions 8 to 13 based on your solution. Course courseNum {PK) courseName Offers 0..* Takes Student studentNum {PK) firstName lastName birthDate /age Section discriminator) Teaches 0 * secNum term 0..* Professor profid (PK) firstName lastName email [1..*] 0..1 How many relation schemas (tables) would be created from this ERD? (Count carefully - there is a detail in here that is easy to miss.) O O O O QUESTION 9 The following question refers to the ERD shown in question 8. How many columns will the Student table have after we translate this ERD? O a. 6 b. None of the other choices 0 O c. 5 O d. 4 QUESTION 10 The following question refers to the ERD shown in question 8. Which of the following relation schemas would result from translating this ERD? Professor(profld, firstName, lastName, email) O a. O b. Course(courseNum, courseName) Takes(studentNum, secNum) Section courseNum, secNum, term) Od

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

Step: 3

blur-text-image

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

Lab Manual For Database Development

Authors: Rachelle Reese

1st Custom Edition

1256741736, 978-1256741732

More Books

Students also viewed these Databases questions

Question

2. Why has the conflict escalated?

Answered: 1 week ago

Question

1. What might have led to the misinformation?

Answered: 1 week ago