Question
Create a database for a company that provides streaming content and delivers videos (physical DVDs) via mail to customers (a company such as Netflix). While
Create a database for a company that provides streaming content and delivers videos (physical DVDs) via mail to customers (a company such as Netflix). While the customer delivery database for Netflix would be quite complex, we are going to design just one small part of it the customer streaming list and DVD want/have list. This database should keep track of the data required in the columns shown in the Excel Workbook VideoListHW2.xlsx. The worksheet in this workbook contains the data stored for customers DVD and streaming content. The video list contains DVDs that customers want to receive, have received, or have already received and returned. In addition, the list also keeps track of that content that has been streamed by a customer. A customer of any type is able to stream video content, while only some customers are also able receive physical DVDs. Sample data is provided in the worksheet to help you understand what needs to be stored for this application. The number of columns in the sample data is small to limit the complexity of the design. Here is some additional information about the application: A Video Title can be delivered either as a physical DVD or as streaming content. Not all video titles are available for streaming, but all video titles are available as a physical DVD. Assume that Netflix has multiple physical copies of a given DVD for a given Video Title, and that each physical copy (called a physical DVD in this narrative) has an identifier that must be tracked. This identifier is called a DiskID on the worksheet. Only physical DVDs that have been sent or returned to a customer have DiskIDs on the worksheet. Each Video Title has its own VideoID. Each unique episode of a Video Title has its own VideoID. A VideoID and a DiskID are not the same thing. A given VideoID may have multiple DiskIDs. A customer can be of only one customer type. A customer is categorized by type. Customers who receive physical DVDs in the mail create a list to keep track of what videos they want to receive in the mail. Most DVD customers have 15-20 videos in their list at any point in time. Customers who stream content also keep Video Titles in their list. Those titles may be watched, or they may be stored as Favorite for a customer to watch in the future. Each row on the VideoList worksheet represents one Video Title in the list for one customer. The data values for the status of a Video Title in the list for a given customer can be as follows: o OnOrder: A video is prioritized and waiting in the customer list until it moves up the list and is ready to be physically sent by the company. Each video that has a status of OnOrder must have a number attached. For example, a video for a customer that has a status of OnOrder-1 means that it is the first video in the list waiting to be sent to the customer. Videos in the list will eventually be assigned diskID's when they are physically sent to the customer. o Returned: A physical DVD was sent to the customer and was returned by the customer. o Home: A physical DVD that is currently in the possession of a customer. A customer may keep a video as long as he/she wants. o Favorite: A Video Title that a customer intends to stream in the future. o Watched: A video that has been streamed and watched is noted with this status. If a video has been streamed and watched, then the date that it was watched is stored in the "date video returned" column. The database stores only the last time that a Video Title is watched. If a Video Title is in the process of being watched, but hasn't been finished, then the company keeps track of the position that was last watched. This is shown in the data as "Watched-xx" where xx is the position number where the person stopped watching. Again, only the most recent watch date and position are maintained. Data in the sample worksheet labeled as null means that the data was not available at that time due to the status of the video. Null data is non-existent. For example, the status of the video Dune for Customer Name Fred Martin indicates that the video is third in the list waiting to be sent to the customer (OnOrder-3). Thus, the physical DVD has not yet been sent or returned, so the date that the movie was sent does not exist and the date that it was returned does not exist. They are both null values. Assume each video has only one video category.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started