BIS 245 Database Essentials for Business Discussions and Final Exam

Week 1 DQ 1 – Databases and Gathering Requirements

Week 1 DQ 2 – Choosing a Database

Week 2 DQ 1 – Entity Relationship (ER) Modeling

Week 2 DQ 2 – Database Table Design

Week 3 DQ 1 – Conceptual Database Design

Week 3 DQ 2 – Requirements Analysis

Week 4 DQ 1 – Creating Queries from Woodcraft Database

Week 4 DQ 2 – Creating Queries from Northwind Database

Week 5 DQ 1 – Data Normalization

Week 5 DQ 2 – Data Validation

Week 6 DQ 1 – Data Reporting

Week 6 DQ 2 – Presenting Data Effectively

Week 7 DQ 1 – Database Navigation

Week 7 DQ 2 – Database Security 

Final Exam

Page 1

1. (TCO 1) To delete the filter shown below  (Points : 5)
2. (TCO 1) Which object would you use to retrieve customers who live in Germany and the United States? (Points : 5)
3. (TCO 1) To design a report you should do all of the following EXCEPT (Points : 5)
4. (TCO 1) All of the following filters work EXCEPT (Points : 5)
5. (TCO 1) A Detail line is used to (Points : 5)
6. (TCO 2) Which of the following is not a database system? (Points : 5)
7. (TCO 2) A symbol used in ER diagrams for an entity is a (Points : 5)
8. (TCO 3) A property that provides a “user friendly” name to a column in Datasheet View is a (Points : 5)
9. (TCO 3) Summarized data in an easy-to-read view is known as a (Points : 5)
10. (TCO 3) Which of the following is NOT true of indexed property? (Points : 5)
11. (TCO 4) When building a calculated field, formulas can be created using the (Points : 5)

Page 2

1. (TCO 5) To edit a form, use (Points : 5)
2. (TCO 5) The following are form creation tools EXCEPT (Points : 5)
3. (TCO 6) Which of the following statements is NOT correct about a query? (Points : 5)
4. (TCO 6) After running a query, which view will be shown? (Points : 5)
5. (TCO 7) To display data as percentages of a whole, use the following chart. (Points : 5)
6. (TCO 7) Continuous data (Points : 5)
7. (TCO 8) The Switchboard Manager is an Access utility that is used (Points : 5)
8. (TCO 9) A good password should have (Points : 5)
9. (TCO 9) All of the following describe a certification authority EXCEPT (Points : 5)
10. (TCO 10) To examine the efficiency and performance of an Access database, you should (Points : 5)
11. (TCO 4) Which statement below is NOT true of the one-to-many relationships? (Points : 5)
12. (TCO 1) Describe three-tier architecture.  Explain the functions performed by each tier. (Points : 40)
13. (TCO 2) Explain the terms entity, relationship, and attributes.  Describe how they are used in a database. (Points : 40)
14. (TCO 4) Describe the update problem caused by a de-normalized design. (Points : 40)
15. (TCO 4) Explain 1NF, 2NF, and 3NF as related to database design. (Points : 40)