Reference no: EM132253224
1 If you can place your relations into ___________ you will avoid most problems. This is the form we strive for in most database designs.
2 This normal form requires that your data be places into two-dimensional tables and that there be no repeating groups.
3 This normal form requires that all non-key attributes are functionally dependent on the entire primary key.
4 This normal form requires that there are no transitive dependencies.
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?
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