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.
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.