Given the following narrative description for Primarily Pineapples:
a. Create a business process level REA model in either grammar or diagram format, for the following Primarily Pineapples business process. Be sure to include all relevant entities, relationships, attributes, and cardinalities (minimum and maximum).
b. Convert your business process level model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the relational tables.
Primarily Pineapples is a closely held, debt-financed, wholesale distributor that, as the name implies, specializes in pineapple products. Primarily Pineapples buys bulk quantities of pineapples and pineapple products such as candy and syrup from pineapple growers and producers of pineapple products, and sells the products to grocery stores.
Several buyers handle procurement for Primarily Pineapples. Each buyer is assigned to specific pineapple growers or producers of the specialty products. Each supplier is assigned to one and only one buyer. Each order is the responsibility of at most one buyer. If multiple item types are needed and are available from a single supplier, those items are all included on a single order. Each item Primarily Pineapples purchases may be available from multiple vendors. Primarily Pineapples has one or two preferred vendors for some types of pineapple products, and wants to track those preferences. Primary Pineapples does purchase products from vendors who are not preferred for any specific product.
One of several Primarily Pineapples receiving clerks counts the products received from vendors and enters the quantities on a receiving report for entry into the system. Each shipment received contains products ordered on a single purchase order, and each purchase order results in a single receipt of products.
One of several Primarily Pineapples accounts payable clerks prepares a check drawn on one of the enterprise's checking accounts to pay vendors for purchases. One check is prepared for all purchases made from a vendor during the previous week. Partial payments are never made. Primarily Pineapples has checking accounts at several different banks.
Employees, vendors, products, cash accounts, and banks can be added to the database before any transactions involving them occur.
Primarily Pineapples' owner (Penelope) has provided you with the following list of attributes that must be included in the database. Do not add or subtract any attributes. You may abbreviate the attributes as illustrated in boldface.
At the end of your solution, write any ambiguities you found in the narrative (if any) and assumptions you made to resolve those ambiguities for the Primarily Pineapples problem.

Question

Given the following narrative description for Primarily Pineapples:
a. Create a business process level REA model in either grammar or diagram format, for the following Primarily Pineapples business process. Be sure to include all relevant entities, relationships, attributes, and cardinalities (minimum and maximum).
b. Convert your business process level model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the relational tables.
Primarily Pineapples is a closely held, debt-financed, wholesale distributor that, as the name implies, specializes in pineapple products. Primarily Pineapples buys bulk quantities of pineapples and pineapple products such as candy and syrup from pineapple growers and producers of pineapple products, and sells the products to grocery stores.
Several buyers handle procurement for Primarily Pineapples. Each buyer is assigned to specific pineapple growers or producers of the specialty products. Each supplier is assigned to one and only one buyer. Each order is the responsibility of at most one buyer. If multiple item types are needed and are available from a single supplier, those items are all included on a single order. Each item Primarily Pineapples purchases may be available from multiple vendors. Primarily Pineapples has one or two preferred vendors for some types of pineapple products, and wants to track those preferences. Primary Pineapples does purchase products from vendors who are not preferred for any specific product.
One of several Primarily Pineapples receiving clerks counts the products received from vendors and enters the quantities on a receiving report for entry into the system. Each shipment received contains products ordered on a single purchase order, and each purchase order results in a single receipt of products.
One of several Primarily Pineapples accounts payable clerks prepares a check drawn on one of the enterprise's checking accounts to pay vendors for purchases. One check is prepared for all purchases made from a vendor during the previous week. Partial payments are never made. Primarily Pineapples has checking accounts at several different banks.
Employees, vendors, products, cash accounts, and banks can be added to the database before any transactions involving them occur.
Primarily Pineapples' owner (Penelope) has provided you with the following list of attributes that must be included in the database. Do not add or subtract any attributes. You may abbreviate the attributes as illustrated in boldface.
  At the end of your solution, write any ambiguities you found in the narrative (if any) and assumptions you made to resolve those ambiguities for the Primarily Pineapples problem.

Quizplus · Accepted Answer

The Answer of Given the following narrative description for Primarily Pineapples:
a. Create a business process level REA model in either grammar or diagram format, for the following Primarily Pineapples business process. Be sure to include all relevant entities, relationships, attributes, and cardinalities (minimum and maximum).
b. Convert your business process level model into a set of minimal relational database tables. Be sure to identify primary and foreign keys in the relational tables.
Primarily Pineapples is a closely held, debt-financed, wholesale distributor that, as the name implies, specializes in pineapple products. Primarily Pineapples buys bulk quantities of pineapples and pineapple products such as candy and syrup from pineapple growers and producers of pineapple products, and sells the products to grocery stores.
Several buyers handle procurement for Primarily Pineapples. Each buyer is assigned to specific pineapple growers or producers of the specialty products. Each supplier is assigned to one and only one buyer. Each order is the responsibility of at most one buyer. If multiple item types are needed and are available from a single supplier, those items are all included on a single order. Each item Primarily Pineapples purchases may be available from multiple vendors. Primarily Pineapples has one or two preferred vendors for some types of pineapple products, and wants to track those preferences. Primary Pineapples does purchase products from vendors who are not preferred for any specific product.
One of several Primarily Pineapples receiving clerks counts the products received from vendors and enters the quantities on a receiving report for entry into the system. Each shipment received contains products ordered on a single purchase order, and each purchase order results in a single receipt of products.
One of several Primarily Pineapples accounts payable clerks prepares a check drawn on one of the enterprise's checking accounts to pay vendors for purchases. One check is prepared for all purchases made from a vendor during the previous week. Partial payments are never made. Primarily Pineapples has checking accounts at several different banks.
Employees, vendors, products, cash accounts, and banks can be added to the database before any transactions involving them occur.
Primarily Pineapples' owner (Penelope) has provided you with the following list of attributes that must be included in the database. Do not add or subtract any attributes. You may abbreviate the attributes as illustrated in boldface.
  At the end of your solution, write any ambiguities you found in the narrative (if any) and assumptions you made to resolve those ambiguities for the Primarily Pineapples problem.

Given the Following Narrative Description for Primarily Pineapples