Part A:
Describe a scenario where you might use a database rather than a file system to store data. Explain why you would choose to use a database
Why should a person developing a relational database use keys in their relational database model?
Part B:
How would you use an Entity Relationship Diagram (ERD) as a part of the design of a database application? Do you think it is necessary to utilize the ERD in the process of designing all types of database applications?
Why is it so important to choose the correct Data Type for each field in the database? What kinds of problems could choosing an incorrect Data Type cause?
Part C:
Discuss some ways that data might be filtered using a query to aid in making decisions. Explain your answer.
Identify and describe two scenarios where you might use a form in a database application. Explain why you would use a form in these examples.
Part D:
Identify and discuss the steps you would take to test a database application.
Discuss the importance of planning the implementation of a database application. What are some of the pitfalls of not planning for the implementation of a database application?