Sheeri/mysql-marinate — pull request #140 by pmeth (2013-05-16 04:43:37+00:00)
Title: ER Diagram in mwb format for Chapter 4

I know it's different from what the book has, but MySQL Workbench seems to be a better tool for creating ER diagrams so I made the recommendation to my group to start using it. I figured I should have a version of diagram 4.11 in mwb format for them to work with.

I am a bit concerned that it is a different diagram format than what is in the book. I am also not sure if my diagram meaning is the same as the book's. With weak relationships should I be including all the keys from the parent tables in a cascading fashion? Doing so seems rather silly:
Eg:
Artist:
artist_id (PK)
artist_name

Album:
artist_id (PK) (FK to Artist.artist_id)
album_id (PK)
album_name

Track:
artist_id (PK) (FK to Album.artist_id)
album_id (PK) (FK to Album.album_id)
track_id (PK)
track_name
time

Played:
artist_id (PK) (FK to Track.artist_id)
album_id (PK) (FK to Track.album_id)
track_id (PK) (FK to Track.track_id)
played (PK)