BIS 245 Database Essentials for Business DQs & Final Exam

  * Marked fields are required.
Qty*
Price $40.00

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)
Reviews (0) Write a Review
No Reviews. Write a Review