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 Product ID ProductAudioOptions.code Product ID ProductTag.code Product ID ProductTag.tags Product genres, e.g. action, horror, etc. Movie.code Product ID 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 Cast member role, e.g. Harry Potter, Ginny Weasley, James Bond, etc. CastMember.id Cast member ID CastMember.nationality Cast member nationality, e.g. Australian, etc.
