Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started