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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!