Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Database Driven Web Sites

Authors: Joline Morrison, Mike Morrison

2nd Edition

? 061906448X, 978-0619064488

More Books

Students also viewed these Databases questions

Question

=+5.14. Let f (x) be n2x or 2n -n2x or 0 according as 0 5x

Answered: 1 week ago