An advertising company owns several large display screens in many different locations wants to keep track...
Fantastic news! We've Found the answer you've been seeking!
Question:
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.
Expert Answer:
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
Related Book For
Modern Database Management
ISBN: 978-0133544619
12th edition
Authors: Jeff Hoffer, Ramesh Venkataraman, Heikki Topi
Posted Date:
Students also viewed these programming questions
-
Describe at least three ways that culture can influence group dynamics. Analyze how a group leader might intervene with sensitivity to issues of diversity in a group setting, and Identify a diverse...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Hi there , I need help. for my work i need a relevant and well written introduction as well as conclusion to the following below. My work is complete i just need a introduction and conclusion please...
-
Visit www.guidestar.org and obtain the Form 990 for a local not-for-profit organization. a. Examine Part VIII of the 990 to determine gross receipts of the organization. b. Examine Part IX of the...
-
Complete the following descriptions by filling in the blanks. 1. Debt securities reflect a __________ relationship such as investments in notes, bonds, and certificates of deposit. 2. Equity...
-
Consider the data set of the times taken for programming changes given in DS 12.2.5. (a) What is the standard error of 1? (b) Construct a two-sided 95% confidence interval for the slope parameter 1....
-
Hulus Hybrids has the following information for the years ending January 31 2010 and 2009: Requirements 1. Compute the rate of inventory turnover for Hulus Hybrids for the years ended January 31,...
-
Bettner, Inc., is a calendar year corporation whose financial statements for 2012 and 2013 included errors as follows: Assume that purchases were recorded correctly and that no correcting entries...
-
Harms Inc. reported in its 2006 annual report the following information: Plan Status: December 31, 2006 Accumulated Benefit Obligation (ABO) $ 90 Million Projected Benefit Obligation (PBO) $ 95...
-
Inasmuch as our tax and regulatory policies hamper a return of manufacturing to the United States, they should be reformed. Your Task. Revise the above sentence to eliminate wordy phrases.
-
Problem 7: Two friends are travelling downstream on a raft drifting along with the same speed as the river. At t = 0, Friend-1 jumps off the raft and start swimming downstream. At t = 30 min,...
-
First, identify a service industry of mine is, General Motors. Then, in a short paper, do the following: Why does General Motors start production on the Camaro and, after a few years, decide to stop...
-
Assume that A limited paid a dividend of26.9 cents per share just recently. The shares currently sell for $10.3. You also estimate that the dividend will grow steadily at 2.1 % per year into the...
-
In a company presentation, you are informed about the following: Cash burn is $ 7 8 5 , 0 0 0 Cash build is $ 6 5 0 , 0 0 0 Cash balance on the balance sheet is $ 4 0 0 , 0 0 0 . How many months is...
-
emoti gniwallat Listed below are year-end account balances ($ in millions) taken from the records of Symphony Stores. Accounts receivable Building and equipment Debit Credit $ 710 920 Cash Interest...
-
Industry: Education Indusry I need below mentioned question for the Education indusry. 1)Risk Assessment: This section should describe the process of risk assessment, including how risks are...
-
Prove that function f(x) = (x - 1) e x + 1 is increasing for all non - negative real numbers.
-
Halley's comet travels in an ellipti- cal orbit with a = 17.95 and b = 4.44 and passes by Earth roughly every 76 years. Note that each unit represents one astronomical unit, or 93 million miles. The...
-
List the customers who live in California or Washington. Order them by zip code, from high to low.
-
Which tutor needs to be reminded to turn in reports? Write the SQL command. Show how you constructed this query using a Venn or other type of diagram.
-
Figure 4-32 shows a class list for Millennium College. Convert this user view to a set of 3NF relations using an enterprise key. Assume the following: ¢ An instructor has a unique location....
-
If the correlation coefficient is equal to 0, the slope of the least-squares regression line will be equal to _____________________ . In Exercises 57, fill in each blank with the appropriate word or...
-
In Exercises 1316, compute the least-squares regression line for the given data set. xy 1 2 3 5 5 6 9 7
-
In Exercises 1316, compute the least-squares regression line for the given data set. x 42 36 14 18 23 36 17 y 72 68 25 31 42 42 65 32
Study smarter with the SolutionInn App