You have been asked to take over an existing relational database

You have been asked to take over an existing relational database

You have been asked to take over an existing relational database, so you examine one of the tables. You notice that one of the fields contains the same value for all records. Which of the following might you note in terms of the database design

Question 7 options:

Repetition and redundancy of   information within a table is a poor design choice because it is an   inefficient use of space

Repetition and redundancy of   information within a table is a good design choice because it prevents   information loss

As long as SQL code can be written   against the database, the table structures don’t matter.

All of these

None of these

Question 8 (2 points)

You are asked to expand the design of an existing relational database system by incorporating a new table of additional information. You notice that in this new table, none of the existing fields contain unique values and so none of the fields can be used as a primary key. A good design decision would be to

Question 8 options:

All of these

Leave the table alone and do not   relate it to any other tables

Break up this and all other tables   so that primary keys can “emerge” and redo the relationships among   tables

None of these

Add a new field to this table to   serve as the primary key for the table