Reference no: EM132254313

1 If you can place your relations into ___________ you will avoid most problems. This is the form we strive for in most database designs.

Boyce-Codd

1NF

3NF

2NF

2 This normal form requires that your data be places into two-dimensional tables and that there be no repeating groups.

3NF

4NF

1NF

2NF

3 This normal form requires that all non-key attributes are functionally dependent on the entire primary key.

3NF

Boyce-Codd

1NF

2NF

4 This normal form requires that there are no transitive dependencies.

1NF

5NF

2NF

3N

5 When creating a new entity (table) to adhere to the functional/transitive dependency rules of 3NF, if your dataset does not contain an attribute that can act as the primary key you, the DBA, can create a ______________.

skeleton key

composite key

chained key

surrogate key

6 Which column in every table automatically has a index created for it by the DMBS

primary key

foreign key

unique column

master key

7 This method of data organization in a database is when you split your tables into multiple smaller tables so that queries don't have so many rows through which to iterate.

splitting

clustering

discriminating

partitioning

8 Which of Codd's rules state that in order to access data one only needs to know the table, column, and primary key?

8

2

1

4

9 Codd's Rule #4 requires that DMBSs store structural data in the database so that DBAs can read information on how the tables were constructed. In MySQL, one such command that allows you to read said data is _______________.

delete

describe

project

select

10 If your dataset has a field with a value, such as "Joe,John,Larry", this is an example of a ___________ that needs to be corrected.

broken group

repeating group

comma group

super group