Question: Please note these are subquestions for one question, so please answer them all!Thank you! Based on the above diagram, please answer the following subquestions: 1.

Please note these are subquestions for one question, so please answer them all!Thank you!

Based on the above diagram, please answer the following subquestions:

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

2. Which of the following relation schemas would result from translating this ERD?

3. How many columns will the Student table have after we translate this ERD?

4. Which of the following relation schemas would NOT be produced after translating this ERD?

5. Which of the following relation schemas will NOT have a composite (multi-column) PK?

6. Which of the following relationships will become their own tables?

Course courseNum (PK) courseName 1..1 Offers Student Professor profid (PK) lastName email [1..*] Section studentNum (PK) firstName lastName birthDate age Teaches Takes secNum (discriminator) 0.term 0firstName 5746 d. Takes(studentNum,_secNum) b. Professor(profld, firstName, lastName, email) C. Course(courseNum, courseName) d. Section(courseNum, secNum, term) a. b. None of the other choices 4 6 c. d. aTakes(studentNum.courseNum.secNum) b. Section(courseNum, secNum, term, profid) c. Student(studentNum, firstName, lastName, birthDate) d. Offers(courseNum, secNum) Section Professor All of the other choices will have a composite PK a. Teaches b. Offers C. Takes .None of the other choices

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

I need help with the law for business I want to see if my answer are correct 1. Which of the following is the best deseription of the consumer guarantees in Part 32 of the Australian Consumer Law: a....

Hello I need help with requirenments 7-11. please and thank you ACG2021 Comprehensive Financial Statement Analysis Project Spring 2017 Group Members Last Name First Name Instructions: You will need...

Can you please help me with requirements 8-11 here is the links where you can find the imfo...

he homework is due on Feb.25 (Saturaday). Each student must submit one copy of the homework and one copy of the spool file. The following shows the file name format: Zno_FirstName_LastName_HW01.pdf...

Please give me solutions for 2 documents. I have a test soon!!! LANCASTER UNIVERSITY 2012 EXAMINATIONS PART II (SECOND AND FINAL YEAR) ACCOUNTING AND FINANCE AcF 305 INTERNATIONAL FINANCIAL...

Mates Rates Rent-A-Car ( just do the part a) using visual studio code (C#) Criteria sheet - Par A Example supplementary files (readme.pdf) Example supplementary files (class-diagram.pdf) Assignment...

Prepare a Statement of Advice (SOA) for the Martins interviewed for Assignment 1. The case study information is attached as a picture at the bottom of the page. As this assignment is to be a SOA for...

Im having trouble with question 3 part A of the attached file. I know and understand her needs but im not sure if im filling out the table correctly ? Assignment Tier 1 Financial Planning...

Pacifica Manufacturing retired a computerized metal stamping machine on December 31, 2009. Pacifica sold the machine to another company and did not replace it. The following data are available for...

Check the terms set forth in L/C No.94625 with the contents of the under-mentioned S/C No.1023 to see what discrepancies between them exist and then write a letter requesting the buyer to make the...

IT auditors may need to be called in to Pregunta 2 9 Respuesta a . To assist in testing the automated processes. b . None of the alternatives. c . Consider the effects of computer processing on the...

Quigley Inc. owns 20% of the stock of Gray Matter, Inc. Gray Matter, Inc. is a domestic corporation. Quigley has the following information this year, before deducting the DRD: What is Quigley's net...

10. How do volunteer assignments and job experiences contribute to employee development?

9. Discuss the characteristics of the most effective company development strategies. Which characteristic do you believe is most important? Why?

3. Go to General Electrics Web site at www.gecareers.com. Review the entry-level leadership and experienced leadership programs. Overall, what type of development activities are included in these...