Part A: Develop an entity-relationship diagram (ERD) and its corresponding database (Microsoft Access) to be used by a product manufacturer to manage the s it receives from its customers. Part A will be submitted as an MS WORD document. Make sure the ERD diagram shows the relation between entities clearly. Use the attached document to develop ERD for your database.
Each customer is identified uniquely by a customer id; include the first name, last name, and address for each customer.
The company has several products that it stocks and for which customers place s.
Each product has a unique id, unique name, unit price, and quantity on hand. At any time, a customer may place an which will involve possibly many products.
For each product ed the database must know the quantity ed and the unit price at that point in time. If the customer does this through a phone call then an employee is involved in the call and will be responsible for the from the company side.
Some s are placed via the Internet. For each , an number is generated. For each , the database must keep track of the number, the date the was placed, and the date by which the customer needs to receive the goods.
Part B: Consider the Orders database. This database has several one-to-many relationships. Part B will be submitted as an MS ACCESS file. Make sure one-to-many relationship runs between entities according to the ERD diagram in Part A Create appropriate forms to list:
A customer and the customer’s s
Order and its detail lines
A product and the detail lines where the product is referenced
A category and the products belonging to the category.
Also, watch the video at the following link https://www.youtube.com/watch?v=57jBdK3YVJo
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more