Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please need help with this and need answer in full thank you 2- Cardinality ratios often dictate the detailed design of a database. The cardinality

image text in transcribed
image text in transcribed
please need help with this and need answer in full thank you
2- Cardinality ratios often dictate the detailed design of a database. The cardinality ratio depends on the real- world meaning of the entity types involved and is defined by the specific application. For the binary relationships below, suggest cardinality ratios based on the common sense meaning of the entity types. Clearly state any assumptions you make. (20 points) Cardinality Entity 1 Ratio Entity 2 1-many A student may have more than one social security card (legally with the same social security 1. Student unique card social security number) and every social security number belongs to a unique student 2. Student Teacher 3. Class Room Wall 2. Student Teacher 3. Classroom Wall 4. Country Current President 5. Course TextBook Item (that can be 6. Order found in an order) 7. Student Class 8. Class Instructor 9. Instructor Office E-bay 10. Auction E-bay bid item

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

Oracle Database 11g SQL

Authors: Jason Price

1st Edition

0071498508, 978-0071498500

More Books

Students also viewed these Databases questions

Question

1. What are the major sources of stress in your life?

Answered: 1 week ago