Relational Databases - Entity/Association Schema (3/3) - Corrected Exercise
Conceptual Model - Entity/Relationship Model (Merise MCD)
Hello and welcome to the first part of the "Relational Databases" course, which will cover the Entity-Relationship Schema (also called "Entity-Relationship Schema" or "Conceptual Model").
The Entity-Relationship Schema corresponds to the conceptual model we covered in the first part of the DBMS course. This schema allows us to move from the real world (and the needs expressed) to the computer world, and it is the schema used to create a relational database. Properly creating and designing this schema ensures that the final relational database will be well-designed and well-created.
In this video, we will solve an exercise on designing an Entity-Relationship Schema, in which we will apply all the concepts we learned in the two previous videos: The concept of an Entity, the concept of an Association, the attribute of an entity, the attribute of an association, and the cardinalities of associations.
Below are the links to previous videos dedicated to the Entity-Relationship Schema:
Relational Database - Entity/Relationship Schema (1/3) - The Concept of an Entity: • Bases de Données Relationnelles - Schéma E...
Relational Database - Entity/Relationship Schema (2/3) - The Concept of an Association: • Bases de Données Relationnelles - Schéma E...
#Merise#MCD#Entity#Association#SQL#Exercise#Answer Key