An advertising company owns several large display screens in many different locations wants to keep track...

Transcribed Image Text:

An advertising company owns several large display screens in many different locations wants to keep track of customers and screen data. The Requirements are summarized as follows: Each screen has its own size. • The Customer may upload a number of video materials but only one in each transaction, each video material has a duration (in minutes), code and type. The user may choose to display the same video material on different screens at different time slices. The Time Slice is described by date, start time and end time. • The difference between start time and end time is the video material duration. Each time slice belongs to certain time interval of day. The day is divided into many time intervals. Each Time interval is characterized by Interval Code, Rental Cost (High, Medium & Low), Interval Start Time and Interval End Time. • The Cost to display one minute depend on both the Time Interval and The Screen. Its required to design a database system (Entity Relationship Diagram & the Relational Database Schema) to track the schedule of user's video materials and capable to calculate the cost of each user transactions. An advertising company owns several large display screens in many different locations wants to keep track of customers and screen data. The Requirements are summarized as follows: Each screen has its own size. • The Customer may upload a number of video materials but only one in each transaction, each video material has a duration (in minutes), code and type. The user may choose to display the same video material on different screens at different time slices. The Time Slice is described by date, start time and end time. • The difference between start time and end time is the video material duration. Each time slice belongs to certain time interval of day. The day is divided into many time intervals. Each Time interval is characterized by Interval Code, Rental Cost (High, Medium & Low), Interval Start Time and Interval End Time. • The Cost to display one minute depend on both the Time Interval and The Screen. Its required to design a database system (Entity Relationship Diagram & the Relational Database Schema) to track the schedule of user's video materials and capable to calculate the cost of each user transactions.

Answer rating: 100% (QA)

The ERD for the case study given is as follows In the above ER diagram the entities are described with their primary and foreign keys Here along with ... View the full answer