Logic Data Modeling 4 - Normalization Example
Loading...
Uploader Comments (gvimontslice)
All Comments (14)
-
this man is so good..i avnt completed the video yet ..bt hes kinda bringing out d joy in me
-
4:31 - the doctor has a skitzo episode, lol,,,,,,this is an awesome video. I am not in the states, but if you had a full detailed tutorial on data modelling, i woudl gladly pay for it.
-
@gvimontslice Thanks for the great explanation! Very clear and concise :)
-
Its difficult to see whats on the board. Should try to focus more on the board rather than on him all the time. Zoom in on where he writes.
Thank you for posting this vid. Aside from the above mentioned problem, its a wonderful lecture
-
according to your opinion, it seems the foreign key only introduced in 3rd N.
the compound primary key introduced in 1st N.
-
i wish i had a lecturer as good as you:)
-
Hey , i wanna thank you for the video series , i have an exam tomorrow and up to this point i haven't understood data normalization , this taught me allot.
3:54
Logic Data Modeling 5 - 1st Normal Formby gvimontslice30,360 views- 9:09
Logic Data Modeling 6 - 2nd Normal Formby gvimontslice22,921 views
- 6:05
Logic Data Modeling 1 - Introductionby gvimontslice48,675 views
- 8:58
Logic Data Modeling 8 - Entity Relationship Diagram, part 1by gvimontslice82,586 views
- 7:49
Normalisation Demonstrationby MrMcNicol62,985 views
- 5:56
Logic Data Modeling 2 - Candidate Keyby gvimontslice24,923 views
- 7:12
Normalization of databases Part 1by almasuod51,812 views
- 5:08
SQL Normalization - The Basics - 1st, 2nd, 3rd Normal Form Software Engineering Tutorialby bidwx8,848 views
- 8:29
database normalization 1 of 2by RajaBabuMan20,554 views
- 6:04
Logic Data Modeling 7 - 3rd Normal Formby gvimontslice19,918 views
- 4:15
Tools of Analysis (part 1 of 8) - Introduction (DFD / Data Flow Diagram)by gvimontslice11,670 views
- 9:34
The Process of Normailisation in a Relational Databaseby morrycj3,629 views
- 3:26
Tools of Analysis (part 2 of 8) - Process and Data (DFD / Data Flow Diagram)by gvimontslice7,078 views
- 9:22
Tools of Analysis (part 6 of 8) - Process & Data (DFD / Data Flow Diagram)by gvimontslice35,861 views
- 8:00
Tools of Analysis (part 5 of 8) - Decomposition (DFD / Data Flow Diagram)by gvimontslice4,646 views
- 1:53
Tools of Analysis (part 8 of 8) - Summary (DFD / Data Flow Diagram)by gvimontslice3,825 views
- 11 videosNormalization
- 9:57
Part1/6: Top 20 DB Design Tips Every Architect Needs to Knowby PrimeBase8,031 views
- 1:00:55
Lecture - 11 Data Modelling - ER Diagrams, Mappingby nptelhrd43,380 views
- 8:34
Data Modeling Practice Activity - Part 1by ProfMZellers4,157 views
- 7:48
An Introduction to Relational Databasesby EasyPHPWebsites82,532 views
Why are there so many names for the same thing? Entity=Relation=Table, Attribute=Column=Field, Instance=Row=Record. This really confused me at the beginning of learning about databases.
Riflemanm16a2 10 months ago
@Riflemanm16a2 -- Think of these terms as falling into one of these two model categories: Logical and Physical.
Logical models have: Entities composed of Attributes. Physical models have: Tables composed of Columns.
Only the physical model supports the storage of records in rows.
gvimontslice 10 months ago
A table in a database is Entity and column's name in a table is Attribute. Am i getting it right ?
alihammadshah 2 years ago
Correct! A table in the physical db is equivalent to an Entity in the LDM. A column within that table is equivalent to an Attribute in the LDM.
gvimontslice 2 years ago