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:
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.
Become a member and unlock all Study Answers
Try it risk-free for 30 daysTry it risk-free
Ask a question
Our experts can answer your tough homework and study questions.Ask a question Ask a question
Learn more about this topic:
fromChapter 9 / Lesson 1
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.