1 / 7

Normalization Quiz

Normalization Quiz . Tao Li Grant Horntvedt.

lexiss
Download Presentation

Normalization Quiz

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Normalization Quiz Tao Li Grant Horntvedt

  2. 1. Which of the following statements is true: a. Normal forms can be derived by inspecting the data in various tables b. Normal forms speed up all queries c. Normal forms reduce the risk of inconsistent update of replicated data- items d. Normal forms completely eliminate all redundant storage of data-items Answer: C Normal forms of relational database theory give criteria for determining a table’s degree of immunity against logical inconsistencies and anomalies http://en.wikipedia.org/wiki/Database_normalization#Normal_forms

  3. 2. First normal form prohibits the occurrence of a. Null values in a columnb. Repeating group in a tablec. Multiple candidate keys in a tabled. Multiple foreign keys in a table Answer : B Null values, multiple candidate keys, and multiple foreign keys are all allowed in first normal form. 1NF does prohibit repeating groups in a table.

  4. 3. If all non-keys in a table depend on the key, the whole key and nothing but the key, then the table is in a. 1NF, but not in 2NFb. 2NF, but not in 3NFc. 3NFd. BCNF Answer : C Requiring existence of “the key” ensures 1NF; requiring that non-key attributes be dependent on “the whole key” ensures 2NF; further requiring that non-key attributes be dependent on “nothing but the key” ensures 3NF.

  5. 4. When a part of a key determines a non-key, it is a violation of a. First Normal Formb. Second Normal Formc. BCNFd. All of the above Answer : B Requiring that non-key attributes be dependent on “the whole key” ensures 2NF.

  6. 5. Normal forms can be used with a. Relational data modelb. Entity Relationship Modelc. UMLd. All of the above Answer : D Relational data models, Entity Relationship Models, and UML’s can all benefit from the use of normalization.

  7. 6. Can a software design tool identify functional dependencies? No. Functional dependencies are made during the process of developing the database. Design tools can only identify FD’s that do not exist.

More Related