Given the following narrative description for Do-We, Cheat-Um & Howe (DCH):
a. Create a business process level REA model in either grammar or diagram format, for the following DCH 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.
DCH has a few procurement employees that are responsible for making sure that there are enough office supplies (e.g., copy machine paper, toner cartridges, legal pads, ink pads, computer disks, etc.) on hand. When a procurement employee notices that there is a need for more supplies, he or she purchases the needed items from a supplier. Purchases of office supplies cannot occur without a procurement employee and a supplier. Purchases can never involve more than one procurement employee and one supplier. Most purchases involve many different types of supplies. Most suppliers provide DCH with many different types of supplies. Some types of supplies, for example copy machine paper, are available from many suppliers. The different suppliers offer different list prices (i.e., costs to DCH) for the same type of supply, so DCH wants to track specific list prices for each supplier. The list prices must be entered into the database before a supply purchase can occur.
Purchases are usually made on account. Purchases are always paid in full at the end of the following month (at that time, one check per vendor is written to cover all purchases in the prior month). Checks can only be written by one of DCH's three accountants. A check can never be issued to more than one supplier at a time. There are cash disbursements made (always by one of the accountants) for other transactions such as payroll, court fees, legal association dues, etc. These cash disbursements must be included in the database. Each cash disbursement draws on one specific bank account; each account used for cash disbursements typically has 10 checks written from it per week. Only a very small proportion (around 10%) of cash disbursements are related to supply purchases. Finally, all supplies must be assigned to a specific department (although the same type of supply is usually assigned to more than one department) and tracked in the database. Departments can exist, and be in the database, without having any related supplies. A department can have many assigned supplies.
DCH wants to be able to immediately enter all agents into the database before they are involved in any transactions. However, when a supplier is entered into the database there is always at least one supply that they are known to sell. Additionally, each type of supply must be associated with at least one specific supplier.
Attributes (do not add any, do not delete any, and use each only one time)
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 Do-We, Cheatum, and Howe problem.

Question

Given the following narrative description for Do-We, Cheat-Um & Howe (DCH):
a. Create a business process level REA model in either grammar or diagram format, for the following DCH 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.
DCH has a few procurement employees that are responsible for making sure that there are enough office supplies (e.g., copy machine paper, toner cartridges, legal pads, ink pads, computer disks, etc.) on hand. When a procurement employee notices that there is a need for more supplies, he or she purchases the needed items from a supplier. Purchases of office supplies cannot occur without a procurement employee and a supplier. Purchases can never involve more than one procurement employee and one supplier. Most purchases involve many different types of supplies. Most suppliers provide DCH with many different types of supplies. Some types of supplies, for example copy machine paper, are available from many suppliers. The different suppliers offer different list prices (i.e., costs to DCH) for the same type of supply, so DCH wants to track specific list prices for each supplier. The list prices must be entered into the database before a supply purchase can occur.
Purchases are usually made on account. Purchases are always paid in full at the end of the following month (at that time, one check per vendor is written to cover all purchases in the prior month). Checks can only be written by one of DCH's three accountants. A check can never be issued to more than one supplier at a time. There are cash disbursements made (always by one of the accountants) for other transactions such as payroll, court fees, legal association dues, etc. These cash disbursements must be included in the database. Each cash disbursement draws on one specific bank account; each account used for cash disbursements typically has 10 checks written from it per week. Only a very small proportion (around 10%) of cash disbursements are related to supply purchases. Finally, all supplies must be assigned to a specific department (although the same type of supply is usually assigned to more than one department) and tracked in the database. Departments can exist, and be in the database, without having any related supplies. A department can have many assigned supplies.
DCH wants to be able to immediately enter all agents into the database before they are involved in any transactions. However, when a supplier is entered into the database there is always at least one supply that they are known to sell. Additionally, each type of supply must be associated with at least one specific supplier.
Attributes (do not add any, do not delete any, and use each only one time)
  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 Do-We, Cheatum, and Howe problem.

Quizplus · Accepted Answer

The Answer of Given the following narrative description for Do-We, Cheat-Um & Howe (DCH):
a. Create a business process level REA model in either grammar or diagram format, for the following DCH 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.
DCH has a few procurement employees that are responsible for making sure that there are enough office supplies (e.g., copy machine paper, toner cartridges, legal pads, ink pads, computer disks, etc.) on hand. When a procurement employee notices that there is a need for more supplies, he or she purchases the needed items from a supplier. Purchases of office supplies cannot occur without a procurement employee and a supplier. Purchases can never involve more than one procurement employee and one supplier. Most purchases involve many different types of supplies. Most suppliers provide DCH with many different types of supplies. Some types of supplies, for example copy machine paper, are available from many suppliers. The different suppliers offer different list prices (i.e., costs to DCH) for the same type of supply, so DCH wants to track specific list prices for each supplier. The list prices must be entered into the database before a supply purchase can occur.
Purchases are usually made on account. Purchases are always paid in full at the end of the following month (at that time, one check per vendor is written to cover all purchases in the prior month). Checks can only be written by one of DCH's three accountants. A check can never be issued to more than one supplier at a time. There are cash disbursements made (always by one of the accountants) for other transactions such as payroll, court fees, legal association dues, etc. These cash disbursements must be included in the database. Each cash disbursement draws on one specific bank account; each account used for cash disbursements typically has 10 checks written from it per week. Only a very small proportion (around 10%) of cash disbursements are related to supply purchases. Finally, all supplies must be assigned to a specific department (although the same type of supply is usually assigned to more than one department) and tracked in the database. Departments can exist, and be in the database, without having any related supplies. A department can have many assigned supplies.
DCH wants to be able to immediately enter all agents into the database before they are involved in any transactions. However, when a supplier is entered into the database there is always at least one supply that they are known to sell. Additionally, each type of supply must be associated with at least one specific supplier.
Attributes (do not add any, do not delete any, and use each only one time)
  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 Do-We, Cheatum, and Howe problem.

Given the Following Narrative Description for Do-We, Cheat-Um & Howe