1. Assume that you need to withdraw $100 from your checking account using your bank’s ATM machine. What set of steps does the DBMS need to perform to complete your transaction?
2. How well does your school’s DBMS fulfill the functions of a DBMS as described in this chapter? Which functions are fully supported? Which are partially supported? Which are not supported at all?
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?