Overview
In this tutorial, we will learn about database design process. The database design process includes the following basic steps:
- Database Requirements
- Conceptual Design
- Logical Design
- Physical Schema
Database Requirements Collection
This phase consists of collecting and evaluating database requirements from various stake holders of the proposed system.
Conceptual design
In Conceptual Design we will study the business process and identify the entities, attributes and relationships among the entities. We can use tools represent the design in ER Diagram. CHEN and Crow Foot are popular notations.
Logical Design
Transform the conceptual design to a logical structure in the Relational model. In Logical design we will validate the model using Normalization forms 1NF, 2NF, 3NF, etc.
Physical Design
In Physical design we will create SQL statements for creating database tables, views, insert data, create stored procedures, etc.
—
MySQL Tutorials
MySQL Tutorials on this website:
https://www.testingdocs.com/mysql-tutorials-for-beginners/
For more information on MySQL Database: