Series of fairly standard video stores

Assignment Help Operation Management

Reference no: EM131039712

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.

Reference no: EM131039712

Questions Cloud

Develop pay-for-performance plan for assembly-line workers : You are the Compensation Manager for a large company that manufactures bicycles. The Operations Department of the firm is responsible for manufacturing the bikes, which is done in an assembly-line fashion. You have been tasked to develop a pay-for-pe..

Concept of transforming conceptual schema : This assignment has been designed so that you understand the concept of Transforming Conceptual Schema into Logical Schema and Relational Schema. Also basic concepts of Normalization

Creating awareness of the product being advertised : 1. Arrington argues that advertising seldom controls behavior or creates wants that are not rational or truly those of the consumer. Is he correct? Why, or why not?

There appear to be at least four goals for advertising : There appear to be at least four goals for advertising: creating awareness of the product being advertised, establishing an identity for the product, providing information about the product, and convincing the consumer to buy the product. In meeti..

Series of fairly standard video stores : 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. If a vi..

Evaluation and outcome evaluation important : Why is process evaluation and outcome evaluation important to a human service agency? This question is from a human service class I'm taking so it must be in a human service point of view.

Catalogued and entered into the video database : 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. If a v..

Raising money on the international capital market : A firm based in Greece is finding its growth limited by the limited liquidity of the Greek capital market. List the firm’s options for raising money on the international capital market. Discuss the pros and cons of each option, and make a recommendat..

Company utilizing the various financial analysis : Use what the case gives you to describe/analyze the company utilizing the various financial analysis. We will utilize these analysis models to strengthen the "Porters Six Forces" analysis that you are working on for this company.

User Account

All Pages