Paper, Order, or Assignment Requirements

DO part A (a, b, c, d)
a, b, c need draw diagrams
d need 400 words speech + 3 references

PART A: SUCCESS VIDEO STORE (SVS)

Success Video Store (SVS) 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 SVS customer card to rent a video. Customers rent videos for 3 days at a time. Every time a customer rents a video, the system must ensure that he or she does not have any overdue videos. If so, the overdue videos must be returned and an overdue fee must be paid before the customer can rent more videos. Likewise, if the customer has returned overdue videos but has not paid the overdue fee, the fee must be paid before 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, the manager calls the customer to remind him or her to return the video.

1. Draw a context diagram for the scenario mentioned above. (10 marks)
2. Draw a level 0 Data Flow Diagram (DFD) for the scenario mentioned above. (20 marks)
3. Draw an Entity Relationship Diagram (ERD) for the video rental store mentioned above. Each relationship must be clearly defined. (30 marks)

For example:

1 M

Order

Each customer may make more than one order. However, each order can only be made by a specific customer (please note that this example is not linked with the scenario given above).

1. 10 minutes (maximum) of team presentation on the proposed diagram (part a, b and c) to be given in the tutorial in the week beginning 5th October (nominate 2 members to present). (40 marks)