Relational Databases - Entity/Association Schema (1/3) - Concept of Entity
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 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 explain the concept of an Entity and related terms.
The concept of an Association will be covered in the next video.
Detailed Video Content:
00:10 - Introduction
02:20 - The Entity/Association Model
04:00 - The Notion of an Entity
07:05 - Attribute of an Entity
08:10 - Attribute Domain
09:30 - Entity Class
10:30 - Occurrence of an Entity
11:25 - Key/Identifier
13:35 - Representation of an Entity in an Entity/Association Schema
✅ Links to Other Courses:
✔ DBMSs - Concepts and Levels of Data Description: • Les SGBD (1/3) - Notions et Niveaux de Des...
✔ The Objectives of Database Management Systems (DBMSs): • Les SGBD (2/3)- Les Objectifs des Systèmes...
✔ DBMS Functions and Architecture Client-Server: • Les SGBD (3/3) - Les fonctions des SGBD et...
#Databases #ConceptualModel #EntityRelationshipSchema