Answered step by step
Verified Expert Solution
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
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
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