[SOLVED] INFS1200 Sem 2 2019 Assignment Schema For Implementation

INFS1200 Sem 2 2019 Assignment Schema For Implementation
Account [ username, firstName, middleName, lastName, email, dateOfBirth, registrationDate, subscriptionTier] Standard [ username ]
Premium [ username ]
PremiumFriend [ username, friendUsername ]
Playlist [ username, playlistName ]
PlaylistProduct [ username, playlistName, code ]
Watches [ username, code, timestampStopped ]
Product [ code, synopsis, title ]
ProductSubtitleOptions [ code, subtitleLanguage ]
ProductAudioOptions [ code, audioLanguage ]
ProductTags [ code, tag ]
Movie [ code, dateOfRelease, runtime, sequelCode]
TVShow [ code ]
Episode [ code, seasonNumber, episodeNumber, dateOfRelease, runtime ] Acts [ code, id ]
ActsRoles [ code, id, roleName ]
CastMember [ id, nationality, firstName, middleName, lastName ]
Standard.username references Account.username
Premium.username references Account.username
PremiumFriend.username references Premium.username PremiumFriend.friendUsername references Premium.username
Playlist.username references Premium.username
PlaylistProduct.{username, playlistName} references Playlist.{username, playlistName} PlaylistProduct.code references Product.code
Watches.username references Account.username Watches.code references Product.code ProductSubtitleOptions.code references Product.code ProductAudioOptions.code references Product.code ProductTags.code references Product.code Movie.code references Product.code Movie.sequelCode references Movie.code TVShow.code references Product.code
Episode.code references TVShow.code Acts.code references Product.code
Acts.id references CastMember.id ActsRoles.{code, id} references Acts.{code, id}
Reminder Part 2 is to be done INDIVIDUALLY by each student Due date: 18 October 2019 @ 5pm

Additional descriptions for selected attributes have been provided below:
ATTRIBUTE NAME DESCRIPTION
Account.subscriptionTier Account subscription tier can be: standard or premium
PlaylistProduct.code Product ID
Watches.code Product ID
Product.code Product ID
ProductSubtitleOptions.code
Movie.code Product ID
Product ID
ProductAudioOptions.code Product ID
ProductTag.code Product ID
ProductTag.tags Product genres, e.g. action, horror, etc.
Movie.runtime Movie runtime refers to duration it is screened for
Movie.sequelCode Product ID
TVShow.code Product ID
Episode.code Product ID
Episode.runtime Episode runtime refers to duration it is aired for
Acts.code Product ID
Acts.id Cast member ID
ActsRoles.code Product ID
ActsRoles.id Cast member ID
ActsRoles.role
CastMember.id Cast member ID
Cast member role, e.g. Harry Potter, Ginny Weasley, James Bond, etc.
CastMember.nationality Cast member nationality, e.g. Australian, etc.