Database Design and TestingTask: Complete Exercises 1-4.Exercises:1. Recall the AVS scenario from the previous tasks. Create an ER diagram to represent the database design for this system. Include entities, attributes, relationships, and cardinalities. Name a minimum of three attributes for each entity you have identified. (20 points)2. Examine the database entities shown in the following figure, and then complete the following problem. (10 points) For each table depicted above, identify the primary key and foreign key(s). If a table does not have a foreign key, write None in the assigned 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 control and testing are performed throughout the software development lifecycle. Provide an example of a quality assurance or testing activity that occurs during each phase of the life cycle. (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 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 problems that arise are also discussed. These meetings keep communication open and take a preventative approach to address problems before they occur. Analysis: One type of testing that occurs in the analysis phase is unit testing. This can be a Black-Box or White-Box test. This test... middle of paper... insert Expected Result A customer selects a video from the shelf and takes it to the checkout. The customer has selected a video and goes to the checkout. The store clerk will initiate the payment process. The shop assistant/manager will ask the customer for the AVS card. The customer will provide the shop assistant with an AVS card. The store clerk will enter the card into the system to check for expired books and/or fines. The system will alert the clerk of any holds if the customer has expired books or valuable unpaid fines. Test Results: Date Pass/Fail Remarks09/10/11 Fail The AVS card was rejected because the Customer had not paid his dues membership.10/11/12 Fail The credit card on file for the customer has expired. You need a new form of payment on file. Pass 12/11/13 Customer has no unpaid dues or expired books and is able to rent a video.