QUESTIONS:
1. Explain how you will go about developing this database.
2. Then, develop your conceptual model, logical model, and a few examples of what the physical model would look like. [Hint: You can use the ER-Assistant to depict the conceptual model and MS Access to depict the logical model.]
3. Using MS Access, develop the database.
a. Provide at least three forms showing a main form and a sub form.
b. Provide at least four queries that answer some of the questions asked by the end users.
4. Describe how you will deal with the following database issues:
a. Transaction management and concurrency control.
b. Performance tuning and query optimization.
c. Database administration and security.