DATABASE APPLICATION PROJECT GENERAL GUIDELINES PURPOSE There are three main purposes of the database application project: 1. To analyze, design and implement a simple database project that applies to a specific business or personal data management need. 2. To become familiar with the features and use of an actual database management systems product. 3. To evaluate the product in terms of how successfully it is able to satisfy the major objectives of the database approach. These include: independence, integrity, security, recovery, concurrency, limiting redundency, performance, ease of use, and power of expression of its DDL/DML. PROCEDURE Follow the steps given below: 1. Identify a reasonably simple but meaningful business or personal data management problem. 2. Analyze and design a database using E-R Diagrams, database normalization, and other techniques presented in the course that will help solve your problem. 3. Learn the basics of Microsoft Access and use Access to implement your database solution. 4. While using Access, evaluate how successfully it satisfies the major objectives that a database system is supposed to meet, such as independence, integrity, security, recovery, and concurrency control. Note: If for some reason you would prefer to implement your project using a different database system, such as Oracle or DB2, please contact me for approval. OUTCOMES Each student will be responsible for handing in the following: 1. A report describing the database management problem you have set out to solve, the approach you took to solve it, and your evaluation of Mircosoft Access's capabilities. 2. Your E-R Diagram, sample output or listing showing inputs, and the results of your use of the project you developed. DUE DATE The project report is due on the day of the final exam. It is to be submitted in hardcopy form.