A database is used by a record label to store information about their releases. Below is the structure of two tables in the database:
tbl_Artist
ArtistID (Primary Key)ArtistNameGenretbl_Album
AlbumID (Primary Key)AlbumTitleReleaseYearArtistIDState the foreign key in tbl_Album.