80.2K

Verified Solution

Link Copied!

please help with 3 and 4

need help with number 3 and 4. i attached number 1 and 2

ternet, 2 e pass ry Assignment 3 - Akizuki Expenditure Cycle -Narrative [Compatibility Mode) rences MailingsReview View Assignment 3- Akizuki's Fall Moon Wine Distributors- Expenditure Cycle Due 5/29/2019 at the beginning of class Background Akizuki's Fall Moon Wine purchases and sells wines to malls, local stores, and other customers in the Pacific Rim. They only sell Wines and have different kinds of Wines, such as Reds, Whites, Blush, Late Harvest and Ice wines. They have requested you to help them develop a computer system for their expenditure cycle System Information for the Expenditure Cyele Akizuki orders and receives Wine as well as supplies and other items. The order process begins after the buyer is informed that more stock or supplies are needed and they issue a purchase order. Each order is assigned a sequential unique number (purchase order ). We want to include which buyer was responsible for the order. The order can be for more than one item o finished goods and is input into the system at the time of the order. Akizuki uses the actual negotiated price for purchases and standard costs to calculate purchase variances. The receiving employee receives the items for each order in the receiving department. For orders, partial deliveries are accepted, but only one order will be delivered at a time. Each delivery is assigned a sequential unique number, which will be used as the receiving number. We also want to include which receiving clerk was responsible for the receipt. The receiving clerk enters the information into the system when the goods are received. Most orders are required to be paid within 30 days of receipt of the order. However, for some special orders partial payments are allowed (50% within 30 days and the remainder in 60 days). Additionally, we are allowed to pay for more than one delivery on a payment. The cashier prepares a check and a remittance advice showing which invoices are being paid (the RA includes our check # and each invoice number and amount). Cash disbursements are processed by a cashier, and are written with checks from the company's main bank account. Employees and suppliers are added to the database before any transaction with them takes place. Akizuki wants to use this system to produce financial information as well as management information about purchases. Some of this information will be prepared by product type Requirements for Assignment3 1) Prepare the REA model (HINTS: includes 1 type, on a resource, and 1 commitment to purchase. There are 10 entities and 3 many-to-many relationships). 2) Determine the appropriate cardinalities 3) Assign the attributes to tables. (13 tables-10 entities, 3 junction tables for the many-to-many 4) For Supplier, Cash Disbursements, and Purchasing tables list their primary keys, other attributes and foreign keys Required Attributes Receiving (sequential) number Purchase order number Actual purchase price It emtype# Assignment 3 -Akizuki Expenditure Cycle -Narrative (Compatibility Mode) erences Mailings Review View ost orders are required to be paid within 30 days of receipt of the order. However, for some special orders partial payments are allowed (50% within 30 days and the remainder in 60 days). Additionally, we are allowed to pay for more than one delivery on a payment. The cashier prepares a check and a remittance advice showing which invoices are being paid (the RA includes our check # and each invoice number and amount). Cash disbursements are processed by a cashier, and are written with checks from the company's main bank account. Employees and suppliers are added to the database before any transaction with them takes place. Akizuki wants to use this system to produce financial information as well as management information about purchases. Some of this information will be prepared by product type. Requirements for Assignment 3 1) Prepare the REA model (HINTS: includes 1 type, on a resource, and 1 commitment to purchase. There are 10 entities and 3 many-to-many relationships). 2) Determine the appropriate cardinalities. 3) Assign the attributes to tables. (13 tables-10 entities, 3 junction tables for the many-to-many) 4) For Supplier, Cash Disbursements, and Purchasing tables list their primary keys, other attributes and foreign keys. Required Attributes Receiving (sequential) number Purchase order number Actual purchase price Item type # Check number Bank Supplier Name Cash Account Name Beginning inventory on hand Item number Unit budgeted sales price Supplier Number Supplier Telephone Number Unit budgeted cost Item description Expected delivery date Amount paid for each invoice Buyer's Telephone # Item type description Cahier employee # Cashier Name (Note 1) Receiving person's name Supplier address Note 1) Quantity Ordered Receipt Date (Receiving Date) Quantity received Order Date Check date Supplier contact name Cash Account # Buyer's Employee# Buyer's Name (Note 1) Receiving person's employee # Supplier Invoice # Note 1: Usually we would separate first and last name for people and street, city, state and zip for addresses. You can use one attribute for names and addresses. (Note 1) ternet, 2 e pass ry Assignment 3 - Akizuki Expenditure Cycle -Narrative [Compatibility Mode) rences MailingsReview View Assignment 3- Akizuki's Fall Moon Wine Distributors- Expenditure Cycle Due 5/29/2019 at the beginning of class Background Akizuki's Fall Moon Wine purchases and sells wines to malls, local stores, and other customers in the Pacific Rim. They only sell Wines and have different kinds of Wines, such as Reds, Whites, Blush, Late Harvest and Ice wines. They have requested you to help them develop a computer system for their expenditure cycle System Information for the Expenditure Cyele Akizuki orders and receives Wine as well as supplies and other items. The order process begins after the buyer is informed that more stock or supplies are needed and they issue a purchase order. Each order is assigned a sequential unique number (purchase order ). We want to include which buyer was responsible for the order. The order can be for more than one item o finished goods and is input into the system at the time of the order. Akizuki uses the actual negotiated price for purchases and standard costs to calculate purchase variances. The receiving employee receives the items for each order in the receiving department. For orders, partial deliveries are accepted, but only one order will be delivered at a time. Each delivery is assigned a sequential unique number, which will be used as the receiving number. We also want to include which receiving clerk was responsible for the receipt. The receiving clerk enters the information into the system when the goods are received. Most orders are required to be paid within 30 days of receipt of the order. However, for some special orders partial payments are allowed (50% within 30 days and the remainder in 60 days). Additionally, we are allowed to pay for more than one delivery on a payment. The cashier prepares a check and a remittance advice showing which invoices are being paid (the RA includes our check # and each invoice number and amount). Cash disbursements are processed by a cashier, and are written with checks from the company's main bank account. Employees and suppliers are added to the database before any transaction with them takes place. Akizuki wants to use this system to produce financial information as well as management information about purchases. Some of this information will be prepared by product type Requirements for Assignment3 1) Prepare the REA model (HINTS: includes 1 type, on a resource, and 1 commitment to purchase. There are 10 entities and 3 many-to-many relationships). 2) Determine the appropriate cardinalities 3) Assign the attributes to tables. (13 tables-10 entities, 3 junction tables for the many-to-many 4) For Supplier, Cash Disbursements, and Purchasing tables list their primary keys, other attributes and foreign keys Required Attributes Receiving (sequential) number Purchase order number Actual purchase price It emtype# Assignment 3 -Akizuki Expenditure Cycle -Narrative (Compatibility Mode) erences Mailings Review View ost orders are required to be paid within 30 days of receipt of the order. However, for some special orders partial payments are allowed (50% within 30 days and the remainder in 60 days). Additionally, we are allowed to pay for more than one delivery on a payment. The cashier prepares a check and a remittance advice showing which invoices are being paid (the RA includes our check # and each invoice number and amount). Cash disbursements are processed by a cashier, and are written with checks from the company's main bank account. Employees and suppliers are added to the database before any transaction with them takes place. Akizuki wants to use this system to produce financial information as well as management information about purchases. Some of this information will be prepared by product type. Requirements for Assignment 3 1) Prepare the REA model (HINTS: includes 1 type, on a resource, and 1 commitment to purchase. There are 10 entities and 3 many-to-many relationships). 2) Determine the appropriate cardinalities. 3) Assign the attributes to tables. (13 tables-10 entities, 3 junction tables for the many-to-many) 4) For Supplier, Cash Disbursements, and Purchasing tables list their primary keys, other attributes and foreign keys. Required Attributes Receiving (sequential) number Purchase order number Actual purchase price Item type # Check number Bank Supplier Name Cash Account Name Beginning inventory on hand Item number Unit budgeted sales price Supplier Number Supplier Telephone Number Unit budgeted cost Item description Expected delivery date Amount paid for each invoice Buyer's Telephone # Item type description Cahier employee # Cashier Name (Note 1) Receiving person's name Supplier address Note 1) Quantity Ordered Receipt Date (Receiving Date) Quantity received Order Date Check date Supplier contact name Cash Account # Buyer's Employee# Buyer's Name (Note 1) Receiving person's employee # Supplier Invoice # Note 1: Usually we would separate first and last name for people and street, city, state and zip for addresses. You can use one attribute for names and addresses. (Note 1)

Answer & Explanation Solved by verified expert

See Answer