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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started