A Video Store

A Video Store (AVS) runs a series of fairly standard video stores. Before a video can be put on the shelf, it must be cataloged 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 three days at a time. Every time a customer rents a video, the system must ensure that they do not have any overdue videos. If so, the overdue videos must be returned and an overdue fee paid before 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 two or more days overdue, the manager calls the customer to remind them to return the video. If a video is returned in damaged condition, manager removes it from the video database and may sometimes charge the customer.

Exercises:

• Recall the AVS scenario above. Create an ER Diagram to represent the database design for this system. Include the entities, attributes, relationships, and cardinalities. Name a minimum of three attributes for each entity that you have identified.
• Examine the database entities shown in the figure below and then complete the following problem. See image.
• For each table pictured above, identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the assigned space provided. Use the following format to show your answers.
• Quality assurance and testing occur throughout the software development lifecycle. Provide an example of a quality assurance or testing activity that occurs during each phase of the lifecycle. (For each phase, identify at least one QA or testing activity that occurs during that phase).
  • Requirements Analysis Phase.
  • Design Phase.
  • Implementation Phase.
  • Testing Phase.
  • Maintenance Phase.
• Draw Use Case Diagram, Use Case Description, and Sequence diagram for the AVS scenario. And write a test case to test the rent video functionality in the system. I have provided a sample test case template that you may use.