Requirements to ER Diagrams to Database Schema
For Complete YouTube Video: Click Here
In this class, we will understand the Requirements to ER Diagrams to Database Schema.
We have already discussed how to convert the requirements to the database schema.
Table of Contents
Requirements to ER Diagrams to Database Schema
The image below shows how the requirements get converted into ER-Diagram and the ER-Diagram into a database schema.
From the above image, we have covered in 15 classes the conversion of requirements to ER-Diagram.
From this class, we will understand the conversion of ER-Diagram to Database Schema.
Analogy
For better understanding, we will go back to our previous analogy of constructing a house.
The conversion of requirements to ER-Diagram is the conversion of the requirements provided by the user to the blueprint.
After getting the blueprint from the civil engineer, we will provide the blueprint to the constructor.
Now, will the constructor start constructing the house?
No, first, he will start with marking the plan.
After marking, the construction will start.
In the same way, first, we will convert the ER-Diagram to Database Schema, as shown in the image above.
After constructing the database schema based on the database schema, we will implement the database.