Database Development Project: Designing a Relational Database System

This document presents a comprehensive database development project, focusing on designing and implementing a relational database system for a car rental company. The project begins with a comparison of different database models, followed by the design phase, which includes defining functional and non-functional requirements, creating an ER diagram, and normalizing the database schema. The core of the project involves developing a fully functional system using MySQL as the backend and Microsoft Access as the frontend, including user interface design, database table creation, and the implementation of various SQL queries. The system undergoes rigorous testing for functionality and performance, with detailed test plans and results provided. Furthermore, the project demonstrates tools for monitoring and optimizing system performance, and examines audit logs to ensure data integrity and security. The project concludes with a discussion of tools available for managing security and authorizations within the system, including security and encryption.