Now that Ned can keep track of the salespeople and the variouscalls they go on, he would like to begin
tracking his customers sales. Ned has indicated that a customer mayplace an order for the various
services his company provides and can order many different serviceson a single order. The orders will
need to keep track of the date the order was place, for whatservices and the price for those services.
Ned has indicated that the price of the service may changedepending on his costs so will need to keep
track of this for each service ordered at the time of order. Nedhas also indicated that his salespeople
receive commissions, so he will need to keep track of whichcustomer orders are attributed to the
salesperson responsible for the account at the time of the sale. Asalesperson may be moved to a
different account which could potentially cause commissioncalculation issues, so this must be
accounted for in your design.
Design the necessary Entities in order to keep track of Ned’scustomers orders. Update your design
documents and make the additions to the database.

Assignment
1) Update the ERD to include the design of the new Entities. UseVisio to create the ERD. Indicate
the Required attributes on the diagram as well as primary/foreignkeys. Display optional vs
mandatory relationships as well as relationship strength using theappropriate symbols.
2) State the business rule relationships of the new entities.
3) Change Ned’s Access Database to include the new entities. Ensurethat any necessary referential
integrity rules are enforced between the new entities to ensureintegrity of the database.