Information I have: Background Information for the Database Development Pipefitters Supply Company accepts orders over different media.

Information I have:

Background Information for the Database Development

Pipefitters Supply Company accepts orders over different media. When an order arrives, one of the salespersons enters it as a sales order. The sales order includes the customer's name and a list of the inventory items that the customer wishes to purchase. This inventory list includes the quantity of each inventory item and the price at which Pipefitters is currently selling the item. When the order is ready to ship, Pipefitters completes an invoice and records the sale. Sometimes, some of the inventory items a customer has ordered are not in stock. In those cases, Pipefitters will ship partial orders. Customers are expected to pay their invoices within 30 days. Most customers do pay on time; however, some customers make partial payments over two or more months. Each customer may have many sales orders, many sales, and many cash receipts. Sales orders and sales can each have many inventory items, and each inventory item can appear on many sales orders and many sales.

Tables of the database:

·        Customer Table

·        Order Table

·        Invoice table

·        Salesperson Table

·        Item Table

·        Payment Table

Explanation:

ER Diagram:

Relationship:

·        Many to many relationship between the table customer and the order.

·        Many to many relationship between the table order and the item.

·        Many to many relationship between the table salesperson and the item.

·        Many to many relationship between the table invoice and the customer.

·        Many to many relationship between the table invoice and the order.

·        Many to many relationship between the table invoice and the salesperson

·        Many to many relationship between the table invoice and the payment.

·        Many to many relationship between the table customer and the payment.

Content of the table:

Table: Customer:

Table: Order:

Table:Salesperson:

Table: Invoice:

Table: Payment:

Table: Item:

Description:

·        C_ID used as a primary key in the table Customer. It is used to show the unique ID of each party.

·        O_ID used as a primary key in the table Order. It is used to show the unique ID of each order.

·        I_ID used as a primary key in the table invoice. It is used to show the unique ID of each invoice.

·        P_ID used as a primary key in the table Payment. It is used to show the unique ID of each payment.

·        Item_ID used as a primary key in the table Item. It is used to show the unique ID of each item.

·        S_ID used as a primary key in the table Salesperson. It is used to show the unique ID of each sales man.

·        The C_ID is a foreign key in the table Order. It is used to fetch the details of the customer.

·        The Item_ID is a foreign key in the table Order. It is used to fetch the details of the item.

·        The C_ID is a foreign key in the table Invoice. It is used to fetch the details of the customer.

·        The O_ID is a foreign key in the table Invoice. It is used to fetch the details of the order.

·        The S_ID is a foreign key in the table Invoice. It is used to fetch the details of the salesperson.

·        The C_ID is a foreign key in the table payment. It is used to fetch the details of the customer.

·        The I_ID is a foreign key in the table payment. It is used to fetch the details of the invoice.

·        The S_ID is a foreign key in the table item. It is used to fetch the details of the salesperson.

What I need to do (And I need the file):

1)     Use Microsoft Access to create associated tables

2)     Link all tables by Microsoft Access's relationship tool

3)     Copy the relationship of your databased shown in Microsoft Access to a word document

4)     Write a report in about 300 words to address

a.      What are frustrations for you to create a small database?

b.     Can you image the usage of database design in your career development?

c.      Do you consider using a small database to organize the data you collected for your course project? Why or why not?

d.     What are your suggestions for improving this Assignment? 

• Attachment 1
• Attachment 2
• Attachment 3
• Attachment 4
• Attachment 5
• Attachment 6
• Attachment 7