Overview of Database Design Assignment!

Here you can find screenshots of the development of this project and the various pages. This assignment was to develop a database for a car rental company, to pass through all planning and development stages and then build it in MySQL with a couple database queries.




Step 1: Requirements Analysis

Brainstorming Image

Step 2: The Entity-Relationship Model

Entity Relationship Model Image

Step 3: The Unified Modeling Language (UML)

In this case, also refined to the Third Normal Form (3NF)

Unified Modeling Language Image

Step 4: Actual schema built in MySQL

Actual Schema Image

A Couple Examples of Simple Queries

Actual Schema Image Actual Schema Image