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 answer

1. 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.


Learn more about this topic:

Loading...
What is Database Management? - How Databases Help Organizations

from

Chapter 9 / Lesson 1
18K

Organizations 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

Explore our homework questions and answers library