Think of an opportunity in your personal, academic, or professional life in which you could use a...
Question:
Think of an opportunity in your personal, academic, or professional life in which you could use a database (ordering supplies, tracking inventory, maintaining a customer mailing list, organizing a library, etc.).
1. What guidelines would you use for designing your database and tables?
2. Who would your end users be and how would you accommodate their needs through your design?
3. Explain how you would use filters or queries. What's the difference between a filter and a query?
4. What kinds of reports would you run? Why?
Design and Guidelines for Databases
A guideline to creating a perfect database is to find the relationship between the elements in our database. For that we have to look at the type of data we will store in the database. Relationships should be framed in such a way to reduce anomalies and repetition of data.
Answer and Explanation:
Become a Study.com member to unlock this answer! Create your account
View this answer1. When designing a database, we should first look into the type of data that we store and the relationship between them. This analysis is vital for...
See full answer below.
Ask a question
Our experts can answer your tough homework and study questions.
Ask a question Ask a questionSearch Answers
Learn more about this topic:

from
Chapter 9 / Lesson 1Organizations use large amounts of data. Database management makes it possible to organize and analyze these data. Learn why database management is important to support business operations.
Related to this Question



















