Discussion
Home ‣ Database ‣ Database Design Using Normalization Comments
- Question
When you are given a set of tables and asked to create a database to store their data, the first step is to create the new database.
Options- A. True
- B. False
- Correct Answer
- False
- 1. Proper normalization eliminates duplicated data.
Options- A. True
- B. False Discuss
- 2. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
Options- A. True
- B. False Discuss
- 3. When building a database from an existing set of tables, we still need to consider normalization principles.
Options- A. True
- B. False Discuss
- 4. We have normalized a table into BCNF if all candidate keys are determinants.
Options- A. True
- B. False Discuss
- 5. When building a database from an existing set of tables, we may safely assume that there are no multivalued dependencies in the data we are given.
Options- A. True
- B. False Discuss
- 6. One common design problem when designing a database from existing data is the presence of inconsistent values in the received data.
Options- A. True
- B. False Discuss
- 7. The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
Options- A. True
- B. False Discuss
- 8. The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
Options- A. True
- B. False Discuss
- 9. The DBMS allows surrogate keys to be changed.
Options- A. True
- B. False Discuss
- 10. For every relationship, there are six possible referential integrity actions.
Options- A. True
- B. False Discuss
Database Design Using Normalization problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.