Question: Task: Extend the PetsWeB database to include the UI A retail Pet Store has asked you to design a database to capture the important aspects

Task: Extend the "PetsWeB" database to include the UI A retail Pet Store has asked you to design a database to capture the important aspects of their business data. In this assignment, you will build on the basic design to add toolsto assist the user to interact with the database. Tables The store manager has asked if you can add two new tables to the data base to help capture Invoice and Payment data. Each Sales record should have at least one Invoice associated with it, and each of these Invoices will have at least one Payment record. Invoices need to capture the SalelD that the invoice is for, the Date that the Invoice was created, and the Shipping Address data {which may or may not be the same as the Customer address}. Payments need to capture the InvoicelD, the Date of the payment, the Amount of the payment, and the Type of payment [Cash, Cheque or Credit Card - you do NOT need to record any details of credit cards at this time.) The manager has also asked you to modify the Pets table to include a Final Price for each pet, by calculating the sales tax amount and adding it to the Price {assume a 12% tax rate for this eld}. The basic design of the database also needs to be extended to include user tools, like Forms and Reports. Forms There should be a basic form for editing or adding records to each of the Locations, Pets, Employees and Customers tables. There needs to be a form for recording basic Sales records, which should contain Loolmp elds to select the required eld values from the Locations, Pets, Employees and Customers tables. There should be a form for editing Sales and Invoices together. 111is form should show all of the Sale record data. and contain a 511 b-form [in datasheet format] that allows the user to create Invoice records. The main Sales form should contain a calculation that COUNTS all the Invoioes for that Sale [there may be more than one]
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
