Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/4

Click to flip

4 Cards in this Set

  • Front
  • Back

Which of the following properties must be observed when using normalization to perform a decomposition of a relation into a set of smaller relations?




a. There must be no duplicated columns in any of the smaller relations (i.e., given any pair of relations from the set of smaller relations, there is no shared column)


b. A constraint in the original relation can be enforced by one or more constraints on each of the smaller relations


c. Any column that contains a multi-valued attribute in the original relation must be included as a column containing a multi-valued attribute in at least one of the smaller relations.


d. Any tuple in the original relation can be re-constructed from corresponding tuples in the smaller relations

b. A constraint in the original relation can be enforced by one or more constraints on each of the smaller relations


d. Any tuple in the original relation can be re-constructed from corresponding tuples in the smaller relations

Suppose we have the following two functional dependencies


A,B --> C A --> C




The 1st dependency is called

A partial functional dependency

Which of the following statements accurately characterizes normalization




a. It is a high-level design technique that use a diagrammatic notation to model entities, relationships, and attributes.


b. Third normal form involves transferring attributes with transitive dependencies to their own relations


c. A relation is in second normal form when it is in first normal form and every non-primary-key attribute is fully functionally dependent on the primary key


d. A relation that contains a multi-valued attribute is in 1st normal form


e. It attempts to decompose relations into groupings of logically related attributes based on functional dependencies between attributes


f. Normalization attempts to preserve functional dependencies by placing functionally dependent attributes in the same relation


g. Normalization and ER diagrams are mutually exclusive methods for designing a database

b. Third normal form involves transferring attributes with transitive dependencies to their own relations


c. A relation is in second normal form when it is in first normal form and every non-primary-key attribute is fully functionally dependent on the primary key


e. It attempts to decompose relations into groupings of logically related attributes based on functional dependencies between attributes.


f. Normalization attempts to preserve functional dependencies by placing functionally dependent attributes in the same relation

The left side of a functional dependency is called

The determinant