TV Viewing Database Project



right1038225TV Viewing Database ProjectGroup #1Team Members: Holly Chok, Matthew Calugay, George BasantesCreated Date – 1o/23/2019Last Updated Date – 12/11/2019Current version: 1.6035000TV Viewing Database ProjectGroup #1Team Members: Holly Chok, Matthew Calugay, George BasantesCreated Date – 1o/23/2019Last Updated Date – 12/11/2019Current version: 1.6Table of ContentsMission Statement2 Mission Objectives2Field List2Table List3Data Model4Viewings List6ERD8 Change Log10Mission StatementThe purpose of the ITI330 Expense Database is to track the TV viewing habits of participants in a manner that reports may be generated and analysis may be performed.Mission ObjectivesMaintain TV show information.Keeps track of TV programs viewed and information about that viewing occurrence.Maintain a list of TV show categories.Produce a name searchable TV show directory.Produce a viewing history report between dates.Produce TV show category report.Maintain viewer informationProduce a list of favorite shows watched by userProduce TV network reportField ListField NameNotesepisodeIDAuto-generatedshowIDAuto-generated FKseasonTinyintepisodeNumberTinyintshowTimeDatetimeshowViewerIntShowRuntimeIntcategoryIDAuto-generatedshowCategoryVarchar(50)showIDAuto-generatedCategoryIDAuto-generated FKshowNameVarchar(50)NetworkIDAuto-generated FKfavIDAuto-generatedviewerIDAuto-generated FKshowIDAuto-generated FKactivityIDAuto-generatedviewerIDAuto-generated FKepisodeIDAuto-generated FKviewerRevisitstinyintviewerTimeOnlineNumeric timestampViwerTimeOffNumeric timestampviewerIDAuto-generatedviewerFirstNameVarchar(100)viewerLastNameVarchar(100)networkIDAuto-generatednetworkNameVarchar(100)Table ListTable NameNotesEpisodesMaintains show informationCategoriesMaintains list of all genres watched by userShows_DirectoryMaintains list of all shows watched by userFavoritesMaintains list of how many times each show is watchedViewers_ActivityInformation about viewer habitsViewersViewers personal informationNetworksMaintains list of all networks watchedData ModelEpisodesepisodeID (PK)showID (FK)showTime → (timestamp, will show date/time started)?showViewers → (total amount of viewers)showRunTime → (length of show, minutes)Episodes - associative entity / non-identifying relationship entity?episodeID (key attribute)?showID (weak key attribute)?showTime (attribute)showViewers (attribute)showRunTime (attribute)FavoritesfavID (PK)viewerID (FK)showID (FK)viewerRevisits → (amount of time viewer turns show back on, minutes)Favorites - associative entity / non-identifying relationship entityfavID (key attribute)viewerID (weak key attribute)showID (weak key attribute)viewerRevisits (derived attribute)?Viewers_ActivityactivityID (PK)viewerID (FK)episodeID (FK)viewerTimeOnline → (amount of time viewer watches show, minutes)viewerTurnOff → (amount of time viewers shuts off show, minutes)viewerRevisits → (amount of time viewer turns show back on, minutes)Viewers_Activity - associate entity?activityID (key attribute)?viewerTimeOnline (attribute)viewerTurnOff (attribute)viewerRevisits (attribute)Validation TablesShows_DirectoryshowID (PK)catID (FK)showNamenetworkID (FK)Shows_Directory - associate entity / non-identifying relationshipshowID (key attribute)?catID (weak key attribute)?showName (attribute)networkID (weak key attribute)CategoriescatID (PK)showCatCategories - entity?catID (key attribute)showCat (attribute)ViewersviewerID (PK)viewerFirstNameviewerLastNameViewers - entity?viewerID (key attribute)viewerFirstName (attribute)viewerLastName (attribute)NetworksnetworkID (PK)networkNameNetworks - entity?networkID (key attribute)?networkName (attribute)ViewingsShow NameEpisodeGenreNetworkViewerShowOnShow OffLaw andOrderS1: 01DramaNBCJessica11/026 PM11/027 PMLaw andOrderS1: 02DramaNBCJessica11/027 PM11/028 PMNCISS3: 04ActionCBSLeonardo, Jessica11/038 PM11/039 PMCriminalMindsS2: 06ThrillerCBSLeonardo11/047 PM11/048 PMBig BangTheoryS1: 13SitcomCBSRaphael11/048 PM11/048:30 PMGothamS2: 01DramaNetflixAngie, Raphael, Leonardo11/058 PM11/059 PMBig BangTheoryS1: 14SitcomCBSRaphael11/059 PM11/059:30 PMParks and RecreationS1: 04SitcomNetflixJessica11/066:11 PM11/066:41 PMArrowS1: 06SuperheroThe CWAngie, Raphael, Leonardo11/069 PM11/0610 PMSupernaturalS1: 10DramaThe CWAngie11/078 PM11/079 PMFamily GuyS2: 04SitcomFoxRaphael, Leonardo11/079 PM11/079:30 PMNarcosS1: 01CrimeFictionNetflixJessica, Leonardo11/083:36 PM11/084:36 PMGrey’sAnatomyS2:02DramaABCLeonardo, Angie11/088 PM11/089 PMImpracticalJokersS1: 01RealityComedyCentralJessica, Angie, Raphael11/089 PM11/089:30 PMScrubsS1: 03ComedyNetflixAngie, Raphael11/0912:39 PM11/091:09 PMScrubsS1: 04ComedyNetflixAngie, Raphael11/095:18 PM11/095:48 PMScrubsS1: 05ComedyNetflixAngie, Raphael11/095:50 PM11/096:20 PMNCISS3: 05ActionCBSLeonardo, Jessica11/097 PM11/098 PMNCISS3: 06ActionCBSLeonardo, Jessica11/098 PM11/099 PMBig BangTheoryS1: 15SitcomCBSRaphael11/099 PM 11/099:30 PMThe OfficeS1: 01SitcomNBCAngie, Jessica, Leonardo11/105:45 PM11/106:15 PMThe OfficeS1: 02SitcomNBCAngie,Jessica, Raphael11/106:16pm11/106:50 PMNarcosS3:02CrimeFictionNetflixJessica, Leonardo11/106:57 PM11/107:58 PMNarcosS3: 03CrimeFictionNetflixJessica, Leonardo11/108:03 PM11/109:04 PMGrey’sAnatomyS2: 03DramaABCLeonardo, Angie11/117 PM11/118 PMGrey’sAnatomyS2: 04DramaABCLeonardo, Angie11/118 PM11/119 PMMy HeroAcademiaS1: 01AnimeHuluRaphael11/1111:03 PM11/1111:33 PMMy HeroAcademiaS1: 02AnimeHuluRaphael11/1211:34 PM11/1212:05 AMMy HeroAcademiaS1: 03AnimeHuluRaphael11/1212:06 AM11/1212:37 AMFamily GuyS2: 07SitcomFoxRaphael, Leonardo11/121 AM11/121:30 AMLaw andOrderS1: 03DramaNBCJessica11/136 PM11/137 PMLaw and OrderS1: 04DramaNBCJessica11/137 PM11/138 PMGothamS2: 02DramaNetflixAngie, Raphael, Leonardo11/139:12 AM11/1310:12 AMGothamS2: 03DramaNetflixAngie, Raphael, Leonardo11/1410:13 AM11/1411:14 AMLaw and OrderS1: 05DramaNBCJessica11/148 PM11/149 PMScrubsS1: 06ComedyNetflixAngie, Raphael11/149:02 PM11/149:32 PMParks and RecreationS1: 05SitcomNetflixJessica11/153:27 PM11/153:57 PMParks and RecreationS1: 06SitcomNetflixJessica11/154:01 PM11/154:31 PMCriminalMindsS2: 07ThrillerCBSLeonardo11/167 PM11/168 PMMy Hero AcademiaS1: 04AnimeHuluRaphael11/1611:49 AM11/1612:19 PMERDAppendix A: Change logDoc VersionChange DescriptionChange DateAuthor1.1Initial creation of document10/23/19George Basantes1.1Addition of Mission Statement and Objectives10/26/19Holly, Matthew, George1.2Adding TOC, grids for Fields and table sections2/14/19Matt Cushing1.3Addition of Field Names10/28/19Holly Chok1.3Addition of Data Types10/28/30Matthew Calugay1.3Addition of Table Names10/28/19George Basantes1.4Creation and addition Data Model11/17/19Holly Chok1.4Creation and addition of Viewings11/18/19George Basantes1.4Creation and addition of ERD11/18/19Matthew Calugay1.5Creation and addition of SQL File 1 12/6/19George Basantes1.5Creation and addition of SQL File 212/6/19George Basantes1.5Creation and addition of SQL File 312/7/19Holly Chok1.5Completion of SQL File 312/8/19Matthew Calugay1.5Alterations to ‘Favorites’ and ‘Episodes’ table12/8/19George Basantes1.5Initial Testing/Debugging12/9/19Matthew Calugay1.5Final Testing/Debugging Session12/9/19Holly, Matthew, George, Cushing1.5Final Submission12/11/19Holly, George ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download