DEV Community


Posted on

Simple Flight Database: Database Design

Database Design is the process of defining how a database will be structured. This primarily includes tables, their relationships, and the columns each table contains.

Today we are going to design the database of a Car Rental Service.
To design a database first we need to make user stories.

1. User Stories

According to Wikipedia, In software development and product management, a user story is an informal, natural language description of one or more features of a software system. User stories are often written from the perspective of an end-user or user of a system.

For our Simple Flight Database, these are user stories.
a) An airplane is assigned to several flights. A flight is assigned to only one airplane.
b) A pilot can perform several flights. A flight is performed by several(normally at least two) pilots.

2. Entity Relationship Diagram

Simple Flight Database

3. Relational Model

Relational Model

Top comments (1)

dynobird_com profile image
Dynobird database designer