Relational Databases - Entity/Association Schema (2/3) - Concept of Association
Conceptual Model - Entity/Association Schema
Hello and welcome to the first part of the "Relational Databases" course, which will cover the Entity-Association Schema (also called "Entity-Relationship Schema" or "Conceptual Model").
The Entity-Association 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 we use 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 continue the previous video and examine the concept of an Association, the attribute of an association, and the cardinality of an association.
Detailed video content:
00:00 - Concept of Association
02:00 - Attribute of an Association
06:20 - Cardinality of an Association
07:05 - Example 1
10:45 - Example 2