Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Use the following information about a Video Rental business to guide your design: - The store rents DVD videos to customers. - Each rental has

Use the following information about a Video Rental business to guide your design:

- The store rents DVD videos to customers.

- Each rental has a due date and time.

- The store may have multiple copies of some videos.

- Videos have a title, category, studio name, director, producer, writers, year produced, version and actors.

- Customers can rent more than one video at a time, up to a limit of 10.

- Videos are purchased from suppliers, and may be available from more than one supplier.

- Customer service representatives serve customers, but we dont keep track of which customer is served by which customer service representatives.

- A program will be written to manage the events of new customers, updates of customer information, video queries, rentals, holds and returns, and management reports.

- A program will be written to allow customers to search the inventory to look for videos based on category, actors, year, directors, writers, or title. (So you could look for all comedies with Gene Wilder acting, produced before 1980.). Customers are also allowed to recommend DVDs that are not on stock.

- A program will be written to manage purchasing of new DVDs. The purchasing decisions are based on suppliers advertisements, customers recommendations, and the budget available.

This looks like a lot, but you wont be analyzing and designing everything.

1. (10 marks) Draw context diagram and level-0 DFD for the video rental store for the events of video queries, rentals, holds and returns, DVD purchase, customer management and management reports.

2. (10 marks) Draw UML use-case diagrams for the video rental store for the events of video queries, rentals, holds and returns, DVD purchase, customer management and management reports.

3. (10 marks) Draw UML activity diagrams for two of the individual use cases.

4. (10 marks) Draw UML sequence diagrams for two of the use cases. You might want to use the events you created activity diagrams for.

5. (10 marks) Draw E-R diagram for the video rental store for the events of video queries, rentals, holds and returns, DVD purchase, customer management and management reports.

6. (10 marks) Draw class diagram for the video rental store for the events of video queries, rentals, holds and returns, DVD purchase, customer management and management reports.

7. (20 marks) Design Forms, Reports, Interface, and Dialogue for the video rental store for the events of video queries, rentals, holds and returns, DVD purchase, customer management and management reports.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

L A -r- P[N]

Answered: 1 week ago