An educational series demonstrating how to create an Entity Relationship Diagram starting from a non-normalized database table.
This video shows the creation of the Entity Relationship Diagram.
The video series will show the following in order:
1) Identify Candidate Keys
2) Select Primary Keys
3) Normalize to 3NF
4) Create the ERD Entities
5) Show the relationships between ERD Entities
6) Show the cardinality of the relationships
Why don't you draw reference lines between tables?
Foaman 1 month ago
soooo helpful cheers! :) (altho i'm wondering about your 1:M etc link from Discount to Client? i'm thinking it should be 0:M? because the PK is member level and many clients can be at the same level, or no clients could be in a particular level - and i'm seeing that the discount amount would be linked directly to that level acquired by the client?)
kkof007s 5 months ago
thank you SO much - will really help for my exam prep! :)
kkof007s 5 months ago