Reference no: EM132249042
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