Discussion
Home ‣ Database ‣ Database Design Using Normalization Comments
- Question
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
- Correct Answer
- True
- 1. 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 Discuss
- 2. Proper normalization eliminates duplicated data.
Options- A. True
- B. False Discuss
- 3. Multivalued dependencies create harmless anomalies that should be noted, but do not always need to be eliminated.
Options- A. True
- B. False Discuss
- 4. When building a database from an existing set of tables, we still need to consider normalization principles.
Options- A. True
- B. False Discuss
- 5. We have normalized a table into BCNF if all candidate keys are determinants.
Options- A. True
- B. False Discuss
- 6. The design guidelines and priorities for read-only databases are different because read-only databases are never updated.
Options- A. True
- B. False Discuss
- 7. The phrase "SALE.CNumber must exist in CUSTOMER.CNumber" is a referential integrity constraint.
Options- A. True
- B. False Discuss
- 8. The DBMS allows surrogate keys to be changed.
Options- A. True
- B. False Discuss
- 9. For every relationship, there are six possible referential integrity actions.
Options- A. True
- B. False Discuss
- 10. In 1:N relationships, which entity becomes the parent entity is arbitrary.
Options- A. True
- B. False Discuss
Database Design Using Normalization problems
Search Results
Correct Answer: False
Correct Answer: False
Correct Answer: False
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: True
Correct Answer: False
Correct Answer: True
Correct Answer: False
Comments
There are no comments.More in Database:
Programming
Copyright ©CuriousTab. All rights reserved.