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
3. Relational Model
Top comments (2)
Hi...
i was build web application online database design tool
i think you can use this tool for build Simple Flight Database
Regards
👍