Create a CDM (Conceptual Data Model) / EA Model - Method & Example - Databases
98,081 views
About :
With an example, we will see how to build, from a text, a Conceptual Data Model (CDM) also called an Entity-Association model (EA Model). To do this, we will analyze the text to identify the attribute entities. We will thus build the structure of the model, and we will focus on important points: why have a unique identifier and the preference for elementary attributes. We will understand with Excel, for an entity, how we must imagine it in our head. Then, we will complete our model by adding the cardinalities. We will understand how to assign them, and when to prefer 0,N rather than 1,N. Indeed, putting a 0 means that there can be elements in a table associated with no elements in another table, and putting a 1 means that all the elements of a table are necessarily found at least once in the other table (we will come back to this in the next video if it is not clear hihi). Then, we will add the cardinalities of the associations, then we will have finished our model! There you go, this video is quite long, but everything is detailed ^^ In this video: 0:00 Intro & Presentation 0:42 Identifying entities and attributes 5:12 Trains entity 5:44 Elementary attributes 6:20 Entity Type 6:44 Data type 6:51 Unique identifier 7:12 Concrete example (Excel) 8:32 Entity Type 8:48 Adding the unique identifier 10:19 Association 11:00 Other entities & associations 16:29 Note 16:42 Cardinalities 22:10 Cardinality of the association 24:10 Note 24:25 Summary & End I try to explain well :) … in 4K 😝 Databases - Computer science Prep/Bachelor's/BTS/IUT level 1st or 2nd year (Bac Sup) or for personal culture 😉 ----------------- Link to the files: https://fabinou.fr/fiches
210,738 views 1 day ago
210,738 views 1 day ago
369,490 views 1 day ago
306,196 views 2 days ago
269,025 views 2 days ago
436,541 views 3 days ago
Google AdSense
336 x 280
336 x 280
Up Next
Minuni Trăite
3,527 views
2 days ago
2 days ago
Resurse și Predici Creștine
14,412 views
3 weeks ago
3 weeks ago
Grup Betania Arad
32,718 views
1 month ago
1 month ago
Mesagerul Cinzecimii
18,226 views
3 months ago
3 months ago
Minuni Trăite
6,581 views
3 days ago
3 days ago
Biserica Sfânta Treime - Londra
8,121 views
23 hours ago
23 hours ago
Predici Creştine
124,584 views
2 months ago
2 months ago
Minuni Trăite
10 views
40 minutes ago
40 minutes ago
Biserica Maranata Pitesti
79,795 views
7 months ago
7 months ago
Cornel Pop NOU
223,801 views
1 year ago
1 year ago
Harul Nemeritat | Maranata Domnul Nostru Vine |
5,260 views
4 weeks ago
4 weeks ago
Minuni Trăite
1,787 views
3 days ago
3 days ago
EBaru
125,008 views
5 years ago
5 years ago
Ходорковский LIVE
52,251 views
3 hours ago
3 hours ago
Живой Гвоздь
169,613 views
Streamed 20 hours ago
Streamed 20 hours ago
Google AdSense
336 x 280
336 x 280