Alert icon
We're changing our privacy policy. This stuff matters.  Learn more  Dismiss

Logic Data Modeling - Entity Relationship Diagrams - Part 5 of 5

Loading...

Sign in or sign up now!
Alert icon
Upgrade to the latest Flash Player for improved playback performance. Upgrade now or more info.
3,283
Loading...
Alert icon
Sign in or sign up now!
Alert icon

Uploaded by on Aug 28, 2011

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

  • likes, 0 dislikes

Link to this comment:

Share to:
see all

All Comments (3)

Sign In or Sign Up now to post a comment!
  • Why don't you draw reference lines between tables? 

  • 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?)

  • thank you SO much - will really help for my exam prep! :)

Loading...

Alert icon
0 / 00Unsaved Playlist Return to active list
    1. Your queue is empty. Add videos to your queue using this button:
      or sign in to load a different list.
    Loading...Loading...Saving...
    • Clear all videos from this list
    • Learn more