Question: Discuss the importance of data models. Given below is a database that records data about a music track. Table name: ARTIST ArtistID ArtistName ArtstLabour YearsActive
- Discuss the importance of data models.
- Given below is a database that records data about a music track.
Table name: ARTIST
| ArtistID | ArtistName | ArtstLabour | YearsActive |
| 20010 | Ernie Zakrie | FMC Music | 2009 |
| 20011 | Siti Nurhaliza | Siti Nurhaliza Productions | 1995 |
| 20012 | Naim Daniel | World Peace Entertaiment | 2018 |
| 20013 | Iman Troye | XO House | 2018 |
Table name: SONG
| SongID | SongTitle | ArtistID |
| 601 | Teman | 20013 |
| 600 | Gundah | 20010 |
| 599 | Aku Bidadari Syurgamu | 20011 |
- For each table, identify the primary key and foreign key(s). If a table does not have a foreign key, write None.
| Table name | Primary key | Foreign key |
| ARTIST | ||
| SONG |
- Does the SONG table exhibit referential integrity? Justify your answer.
4.The following entity consists of one multivalued attribute. Identify the multivalued attribute and solve the problem caused by the multivalued attribute into a more proper database design.
| EMPLOYEE PK EmpID EmpName EmpAddress EmpSkill |
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
