Catalogued and entered into the video database
Course:- Operation Management
Reference No.:- EM131039710

Assignment Help
Expertsmind Rated 4.9 / 5 based on 47215 reviews.
Review Site
Assignment Help >> Operation Management

A video store (AVS) runs a series of fairly standard video stores. Before a video can be put on the shelf , it must be catalogued and entered into the video database. Every customer must have a valid AVS customer card in order to rent a video. Customers rent videos for 3 days at a time. Everytime a customer rents a video the system must ensure that the customer doesn’t have any overdue videos. If so the overdue videos must be returned and overdue fee paid before the customer can rent any more videos. Likewise if the customer has returned overdue videos, but has not paid the overdue fee, the fee must be paid before any new videos can be rented. Every morning the store manager prints a report that lists overdue videos, if a video is 2 or more days overdue then the manager calls the customer to remind them to return the video. If a video is returned in damaged condition the manager removes it from the video database and may sometimes charge the customer. Make an ERD with relationship sentences.

Put your comment

Ask Question & Get Answers from Experts
Browse some more (Operation Management) Materials
a. What is the factory capacity? (Calculate cycle time of each operation) ___________________ uniforms/day b. What is the throughput time for the first uniform made on a typic
Tiny Software Company creates software security applications intended to protect point-of-sale terminals in retail stores from being hacked. While Tiny Software hires talented
How might retention of even talented employees stifle the succession process and hold back other talented employees who have not been in the organization for a long time? Plea
The NHS QOF effort is obviously full of very specific point systems for evaluation. What are the strengths and weaknesses of such quantification of decision rules in a healthc
From the scenario, evaluate the capacity of the most common distribution channels available for the new product launch to provide consumers with easier access to the product.
Judith Thompson is the manager of the student center cafeteria. She is introducing pizza as a menu item. The pizza is ordered frozen from a local pizza establishment and bak
Illustrate what amount of safety stock is appropriate. When should this item be reordered. Illustrate what risk of stock out would result from a decision not to have any safet
Mary wants to sell her products in Europe since they're doing well in the United States. She doesn't have a lot of capital and is risk-averse, so she is most likely would shoo