Develop entity-relationship diagram

Assignment Help Operation Management

Reference no: EM133181539

Part A: Develop an entity-relationship diagram (ERD) and its corresponding database (Microsoft Access) to be used by a product manufacturer to manage the orders it receives from its customers.

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 orders.

Each product has a unique id, unique name, unit price, and a quantity on hand. At any time, a customer may place an order which will involve possibly many products.

For each product ordered the database must know the quantity ordered 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 order from the company side.

Some orders are placed via the Internet. For each order, an order number is generated. For each order, the database must keep track of the order number, the date the order 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.Create appropriate forms to list:

A customer and the customer's orders

Order and its detail lines

A product and the order detail lines where the product is referenced

A category and the products belonging to the category.

Attachment:- Relational Databases and Microsoft Access.rar

Reference no: EM133181539

Questions Cloud

Employee acceptance of the programs : A recent report found that 80% of employers agree that more interest should be taken in the well-being of their employees in order to build a more resilient org

Effective communication in an organisation : Effective communication in an organisation involves individual skills and organizational actions. Explain in details barriers in communications and ways to over

Develop a job evaluation for companies : You are required to develop a job evaluation for 2 companies below and answer 1 question.

Determine the big five personality traits : What behaviours are usually associated with high and low levels of each of the big five personality traits? How would Mohan score (low or high) on each?

Develop entity-relationship diagram : Develop entity-relationship diagram (ERD) and its corresponding database (Microsoft Access) to be used by a product manufacturer

How does strategy affects human resource management : Part 1. What are the biggest challenges the HR Manager can face when planning for retention and growth in the organization? Explain your answer.

Propose a socialization program for green box : You have been hired as an external consultant, and your client, Green Box Financial, is a large financial services employer with a performance-driven organizati

Elements of inclusivity : Explain 4 ways that the plan lacked elements of inclusivity for Team Member Five, which support diversity within the community?

Retaining talent and treating staff well : Read about a Company Known for Retaining Talent and Treating Their Staff well.

User Account

All Pages