Question
1. Which of the following statements about relational design is false? a) Entities in an ER Diagram typically become relational tables in a relational design
1. Which of the following statements about relational design is false?
a) Entities in an ER Diagram typically become relational tables in a relational design
b) Composite attributes in an ER Diagram become columns of a relational table along with columns for all the component attributes in a relational design
c) Attributes in an ER Diagram become fields or columns of a relational table in a relational design
2. (TRUE/FALSE) If an entity in an ER Diagram has multiple unique non-composite attributes, then one of the columns created for those attributes should be chosen as the primary key in the resulting relational design.
3. If a foreign key refers to the primary key of another relational table and it contains a value that does not exist in that table, then:
a) It is a violation of referential integrity
b) It is not a violation of anything, it is perfectly legal
c) It is a violation of entity integrity
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