FALL 2017 TESTO1A 4.(20 points) Referential Integrity Express the given constrai
ID: 3887915 • Letter: F
Question
FALL 2017 TESTO1A 4.(20 points) Referential Integrity Express the given constrains about the following relations: Songs (SongID, ArtistID, SongTitle, ReleaseDate) Artists (ArtistID, ArtistName, Description) Album (AlbumID, MediaType, ArtistID, Genre, Release Year, price) i. (10 points) The database always has information about the artist of the albums that are stored in the database. (ArtistIDs stored in Album should also appear in Artist.) ii. (10 points) Any album produced after 2009 must be $10.00 or more.Explanation / Answer
Referential Intigrity is nothing but giving foreign key relationship to the relations for which the data will be consistent across the database.
i.
Because of this two alter table statements referential intigrity constraints will be formed on these relations and the data will be stored consistently across the database.
Before applying these referential intigrity constraints first make sure that the ArtistID in the Artists relation must be defined as Primary Key.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.