Required: (1) Create an E-R Diagram for Janie's business using a Diagram Editor or Microsoft Access' relationship manager. (2) Create tables using the following guidelines. (a) Enter records for at least ten customers. Use a hypothetical name, address, phone number, and e-mail address details to create customer records. Assume that the customers are located in Australian cities and states. (b) Enter at least four records for the services offered including: day stays, walking, overnight stays and pet taxi services. (c) Each customer should have at least one order; a few customers should place two orders. Each order should contain at least one service and some must include multiple services. (d) Appropriately limit the size of the text fields; for example, a telephone number does not need the default length of 255 characters. (3) Create forms using the following guidelines (a) Form 1: Create a form based on your Pets table. Save the form as "Form 1_Pet". Your form should resemble that in Figure 1 and include a photo of the pet.Janie's Pet Minding Pets Form ID Pet Code IOLEm Customer Code IBI Pet Name Lenny Date of Birth 10/03/2007 Gender Male Breed of Pet Australian Terrier Pet Photo Figure 1 (b) Form 2: Create a form and sub-form based on your Orders and Order Details tables. Save the form as "Form 1_Order". Your form should resemble that in Figure 2. Janie's Pet Minding Orders ID Order Date 15/01/2020 Customer Code 18 Pet Code IGLEm Total $90.00 Pickup Date 1/04/2020 Payment Cash Paid Order Details go here Figure 2in) Form 3: Create a form and save the form as "Form 3_Main Menu\". \"four form should include links to each of the forms in your database bsr embedding a macro when a Shape is clicked as shown in Figure 3 {Note: pictures are not required]. ".-I 'c'nnl J- Cunt-hill Janie-'5 Pet Minding it? 7, Customers Form Figure 3 {d} Form 4: Create a form and save the form as "Form 4_Main Menu\". \"four form should include links to each of the forms in your database bsr embedding a macro when a Shape is clicked as shown in Figure 4 {Note: pictures are not required but be consistent in your presentation of forms). Form 4 Main Menu Janie's Pet Minding Main Menu Open Order Form Open Pets Form Figure 4 (4) Create the following queries in your database (a) Query 1: Create a select query called "Query 1_Services Due" that displays a listof all services that are due to be performed within a selected date range. Your output should resemble that shown in Figure 5, although your data will be different. Query 1_Services Due ID Pickup Date 1 1/04/2020 42 Abbey St 1/04/2020 42 Abbey S 2/04/2020 90 Monmol 3/04/2020 77 Mayfield Figure 5 (b) Query 2: Create a parameter/update that prompts for the incremental amount of a price increase and then prompts for the service ID or service description. Save the query as "Query 2_Price Change". Test the query by adding $0.25 to the cost of a service. View the changed price in your datasheet view of the updated table. (c) Query 3: Create a query called "Query 3_Best Selling Services". List the service descriptions and determine how many orders and the quantities that have been received for each service. Report the amounts in columns labelled "Hours Ordered" and "Number of Orders" (Note: these column labels will require changes from the default setting provided by the query generator). Sort the output. Your outputshould resemble the format shown in Figure 6, but the data will be different. Query 3_ Best Selling Services Service Ordered . Hours Ordered Number of Orders DayStays 40 OvernightStays 36 PetTaxi Walking 14 Figure 6 (d) Query 4: Create a query called "Query 4_Best Customers" that lists the customers' names, phone numbers, hours ordered, number of orders and the total amounts of their orders (Note: these column labels will require changes from the default setting provided by the query generator). You will have to calculate the order amounts and sort the output. Your output should resemble the format shown in Figure 7, but the data will be different. Query & Best Cu First Name . Last Name . Mobile Phone Number . Hours Ordered . Number of Orders . Total amoun . Aaron Smith 041 662 9088 10 $180.00 Brittany Spears 041 777 5220 $90.00 Rupert Cato 041 333 7689 $40.00 Amber Wong 041 922 0343 $126.00 Rebecca Adams 041 734 0091 $44.00 Denise Garcia 041 9983 6466 23 $272.00 Christal Larson 041 977 0202 $97.00 Figure 7 (5) Create the following reports in your database (a) Report 1: Create a report named "Report 1_Customers by Location". The data for the report will originate from a query, in which all customers who order services between a pre-defined date range are included in the report (use the parameters and a criteria filter such ">=[StartDate] And