Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

WeGoGaming ( WGG ) is an Internet video content creator company. The company runs several channelssynchronized across various online streaming services. They need a database

WeGoGaming (WGG) is an Internet video content creator company. The company runs several channelssynchronized across various online streaming services. They need a database to help track the content that theycreate. Videos range from game review videos to instructional videos, with different channels devoted todifferent audiences. The various streaming platforms provide metrics for analytics, so we do not need toduplicate that effort. Draw the data model to support the following business requirements.For each channel, the name of the channel, the branding image name, and description must be kept. The usersalso want to track the date that the channel was created. Channels contain videos of a certain type. Forexample, WGG has a channel named DevTopStax devoted to video game development news, and anotherchannel named SeriouslyCasual devoted to casual and mobile gaming tutorials. They are considering thecreation of another channel named LowCodeGaming that teaches programming basics using games. Newlycreated channels dont have any videos at first, but eventually a channel will have hundreds of videos. For eachvideo, the video title and description must be kept.Videos go through a production process so just because something is called a video doesnt mean that it hasbeen recorded yet. The current status of each video must be kept (e.g., concept, scripting, recording,editing, released, etc.). Videos begin as a concept that has a title and description. The date that the video isentered into the system as a concept must also be stored.The video must always be associated with one and only one channel because that helps to guide the content ofthe script that will eventually go into the video. There are dozens of videos in the concept stage at most times.Videos involve a script, which is a long, very detailed description of what should be done and said during thevideo, that is created during the scripting stage. The videos script is kept in the system. Next, the video getsrecorded. Recording can take multiple days. The date that recording finishes is kept in the system. Afterrecording completes, the video is edited, and eventually it is released. When a video is released, that is when itis actually posted to the channel. The date that the video is released should also be kept by the system.Clearly, a lot of work must go into each video. The work is done by employees. For each employee, theiremployee number, name, and hire date should be recorded. Employees are either regular company employeesor gig employees. While we do not need to keep the payroll in this system, we still want to track which type ofemployee each person is (regular or gig). An employee can work on hundreds of videos over time. A newemployee may not have worked on any video yet. A video can be created entirely by a single person, but mostvideos include many people working together. For each person working on a video, we need to track whichtask(s) they were responsible for on that particular video. Common tasks are concept, writing, presenting,editing, site management, and directing, but different videos have different needs, and the system shouldnot be limited to only those possibilities when tracking the tasks done by a person.For example, WGG employee Jamal Aziz recorded an idea for a video titled Clan of Empires Early FortressBuilding, for the SeriouslyCasual channel. It should be recorded that Jamal worked on the video with the taskconcept. A few weeks later, Jamal and Ann Sutherland worked together for a few days writing a script for thatvideo. The next week, Synthia Shane and Jamal were picked to present the video (presenting is being the personwho appears in the video) with Derek Stone directing it. Both Jamal and Ann should be recorded in the systemas working on the video for the task of scripting. Jamal and Synthia both are recorded in the system as workingon the video for the task of presenting. Derek is recorded in the system as working on the video for the task ofdirecting.Most videos are shot in the WGG studio, but not all of them. Every location where a WGG video is shot isrecorded. For each location, the system needs a location name, type (public or private), and address. Privatelocations also need a contact phone number. While most videos are shot in one location (most often the WGGstudio), some videos are recorded at other locations. For example, in a video titled Are 3D Object Arrays Deadfor the DevTopStax channel, parts of the video included interviews with developers at MadCap Studios andPureMechanix in addition to the presenter intro and outro shot in the WGG studio. So that one video had threelocations. If the location is a private location other than WGG studio, then the date the video was approved torecord at that location should be stored in the system. So, for the earlier example video, the video was shot atWGG Studios (no approval needed), at MadCap Studio (approved 5/23), and PureMechanix (approved 5/27).The shooting location usually isnt known at the time the video is first conceptualized and stored in the system.Every location in this system must be associated with some video.During a video, it is possible for the video to make a reference to other WGG videos. In fact, script writers aregenerally encouraged to include at least one callback to another video in most videos that WGG creates. Thecallbacks are usually in the form of the presenter saying something like For more information on that, check outthis other video that we posted earlier, sometimes while pointing to a link that will pop up somewhere on thescreen. Each of those callbacks needs to be tracked in the system. The video that contains the callback isreferred to as the host video. The video being called back is referred to as the link video. A host video canmake callbacks to multiple link videos, and a link video can be linked in many host videos. Some host videosdont include callbacks to another video, and some videos are never called back by a host.To try to maximize the time that a viewer will spend moving between WGG videos, playlists are often createdand released. The playlist is used to organize a bunch of videos in a channel that are related in some way into agroup that can easily be played one after the other. Every playlist includes a title and at least one video. Thedate the playlist is created should be stored. As a general rule, WGG doesnt want to put more than 30 videos ina single playlist. Some videos are included in multiple playlists. Some videos have never been included in anyplaylist. WGG can modify a playlist by adding or removing videos from a playlist over time. The date that eachvideo in the playlist was added to the playlist must be recorded. Further, the last date that a playlist wasmodified in any way should also be tracked in the system.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database And Expert Systems Applications 15th International Conference Dexa 2004 Zaragoza Spain August 30 September 3 2004 Proceedings Lncs 3180

Authors: Fernando Galindo ,Makoto Takizawa ,Roland Traunmuller

2004th Edition

3540229361, 978-3540229360

More Books

Students also viewed these Databases questions