Database Design and TestingAssignment: Complete exercises 1 to 4.Exercises:1. Remember the AVS scenario from previous missions. Create an ER diagram to represent the database design for this system. Include entities, attributes, relationships, and cardinalities. Name at least three attributes for each entity you identified. (20 points)2. Examine the database entities shown in the figure below, and then solve the following problem. (10 points) For each table shown above, identify the primary key and foreign key(s). If a table does not have a foreign key, write None in the space provided. Use the following format to display your answers.TABLE PRIMARY KEY FOREIGN KEY(S)TRUCK TRUCK_NUM BASE_CODETRUCK TRUCK_NUM TYPE_CODEBASE BASE_CODE NONETYPE TYPE_CODE NONE3. Quality assurance and testing takes place throughout the software development lifecycle. Provide an example of a quality assurance or testing activity that occurs in each phase of the lifecycle. (For each phase, identify at least one QA or testing activity that occurs during that phase). (10 points) Planning: An example of a quality assurance activity during the planning phase is “Coordination of Activities”. The project manager holds a weekly meeting of the entire team of programmers and analysts working on a system to discuss any changes to the system that have occurred over the past week. Any issues raised are also discussed. These meetings keep communication open and take a preventative approach to solving problems before they arise. Analysis: One type of testing that takes place during the analysis phase is unit testing. This can be a Black-Box or White-Box test. This test ...... middle of paper ...... put Expected result A customer chooses a video from the shelf and brings it to the checkout. The customer has selected a video and goes to checkout. The store clerk will initiate the payment procedure. The store clerk/manager will ask the customer for their AVS card. The customer will provide the store clerk with an AVS card. The store clerk will run the card through the system to check for overdue books and/or fines. The system will notify the clerk of any deductions if the customer has overdue books or valuable unpaid fines. Test results: Date Pass/Fail Remarks09/10/11 Fail The AVS card was rejected because the client had not paid their membership dues.10/11/12 Fail The credit card stored in the client's file has expired . Need a new payment method on file.11/12/13 Pass Customer has no outstanding dues or overdue books and can rent a video.