BIS 245 quiz

1. (TCO 1) The department manager has asked you to create a report in Access. What are some of the questions that you would ask to determine what should be on the report? For one of your questions, give an example of two different answers the manager might give and tell how each answer would affect the report design.

2. 2. (TCO 2) What does it mean to store data in its smallest parts, and why is this important?

3. 3. (TCO 4) From first normal form, second normal form, or third normal form, select one of these forms and explain (1) how that normal form is often violated by inexperienced database designers and (2) how to correct such a violation of that normal form.

4. 4. (TCO 4) When constructing a database, two rules are followed by the database designer to ensure the integrity of keys. Describe each rule and discuss common violations.