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. (Points : 40) 2. (TCO 2) Explain the terms entity, relationship, and attributes. Describe how they are used in a database. (Points : 40) 3. (TCO 4) Conceptual design begins with a big-picture view, and details gradually added before the implementation process begins. With this in mind, what is the first step in the conceptual design process for ERD construction? In your own words, describe how you would accomplish this first step. (Points : 40) 4. (TCO 4) Describe what the term “data redundancy” means in database design. Explain if it is bad and if a normalized database design is always the best design. Discuss the pros and cons of a normalized database. (Points : 40)
Needs help with similar assignment?
We are available 24x7 to deliver the best services and assignment ready within 3-4 hours? Order a custom-written, plagiarism-free paper