Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Problem 6 [35] Please answer each of the questions in brief: 1. Why should we start modeling a real-world Database application with ER diagrams instead

image text in transcribed

Problem 6 [35] Please answer each of the questions in brief: 1. Why should we start modeling a real-world Database application with ER diagrams instead of going directly to a relational model? [5] 2. What are referential integrity constraints? Why are they important from both the data quality aspect, as well as the technical (programming) aspect? [10] 3. What are weak entity sets? Give an example where weak entity sets would be necessary (not the examples given in class think of your own). [10] 4. What is the minimum possible number of attributes of a key for an entity set E? Then what is the maximum? [2] 5. We think of relationships in the ER model as having keys, just as entity sets do. Let R be a relationship between entity sets Ej and E2, where K and Ky are the set of attributes that is a key for entity set Ej and E2, respectively. What is the minimum possible number of attributes of a key for R (in terms of K and K) under the assumption that: a. Ris many-many [2]; b. R is many-one from Eto E2 [2]; c. R is many-one from E2 to E1 [2]; d. R is one-one [2]

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

Professional Microsoft SQL Server 2014 Integration Services

Authors: Brian Knight, Devin Knight

1st Edition

1118850904, 9781118850909

More Books

Students also viewed these Databases questions

Question

Discuss selection in a global environment.

Answered: 1 week ago

Question

6. Be able to choose and prepare a training site.

Answered: 1 week ago