Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please help with this problem Problem 6 [35] Please answer each of the questions in brief: 1. Why should we start modeling a real-world Database

Please help with this problem

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 E, and E2, where Ki and K2 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 K2) under the assumption that: a. R is many-many [2]; b. R is many-one from E, to E2 [2]; c. R is many-one from E2 to E1 [2]; d. R is one-one [2]; 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 E, and E2, where Ki and K2 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 K2) under the assumption that: a. R is many-many [2]; b. R is many-one from E, to 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_2

Step: 3

blur-text-image_3

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

More Books

Students also viewed these Databases questions

Question

What are represented by the symbols and ? By 1/ and 1/? By ?

Answered: 1 week ago