ER Diagram The Music Database
The Music Database
The music database stores details of a personal music library, and could be used to manage your MP3, CD
One artist can make many albums . Conversely, an album is by one artist.
Which has an artist_id attribute that uniquely identifies it.
One album can contain many tracks . Conversely, a track is on one album.
Each Album entity is uniquely identified by its album_id combined with the artist_id of the corresponding Artist entity
.
One track can be played many times . Conversely, each play is associated with one track
A Track entity is similarly uniquely identified by its track_id combined with the related album_id and artist_id attributes. The Played entity is uniquely identified by a combination of its played time, and the related track_id, album_id, and artist_idattributes.
What have you done/learned
- รู้การสร้าง ER digram
Problem/Solution
- วาดรูปลำบาก แก้ โดยวาดรูป ลง google slide
Decision
- ตัดสินใจเอาตัวย่าง the music database
Related Info/link/reference
- link ER diagram : ลิ้งค์
ไม่มีความคิดเห็น:
แสดงความคิดเห็น