Milltown Medical Milltown Medical is a pop-up medical supplies company formed recently to source scarce medical...

Transcribed Image Text:

Milltown Medical Milltown Medical is a pop-up medical supplies company formed recently to source scarce medical supplies such as face masks, gloves, gowns, etc. and re-sell them to hospitals, clinics, doctors offices, and other professional medical organizations. Having no other purpose than to acquire (and re-sell) medical supplies, the business does not utilize a requisitions process. Its business begins with purchase orders placed by one of the three purchasing clerks for as large a quantity as possible of one or more of the medical supplies available from each supplier with whom Milltown Medical does business (e.g. Parsippany Paper Products). Medical supplies are received by one of two receiving clerks. Many suppliers currently do not allow Milltown Medical to place new orders until earlier orders have been shipped, and each order is placed for the largest quantity permitted at the time, so it would be unusual for a receipt to include medical supplies from more than one order; nevertheless, it is possible in rare cases because items unavailable for a given order (e.g. different sizes) may become available for a second order before the first is shipped out. Similarly, orders are normally received in full, given that they were already limited by available quantities; nevertheless, occasionally part shipments do happen because of production delays. In the circumstances, given the crisis caused by the Covid-19 pandemic, the nature of the products, and widespread demand for limited availability, Milltown Medical does not return items nor anticipate receiving allowances. Payment is made in full for each receipt within seven days by the accounts payable clerk. However, because orders are limited to available supplies at the time of ordering. Milltown Medical may place multiple orders and receive multiple shipments within just a few days, and so may pay for more than one receipt with a single payment. 1. Construct a BPMN Diagram 2 Create a class diagram - identify the classes and specify the associations and multiplicities 3. Identify the tables and link tables. Specify the primary keys for each. 4. Specify the foreign keys and other non-key attributes for each table 5. Implement in MSACCESS with business rules and constraints Milltown Medical Milltown Medical is a pop-up medical supplies company formed recently to source scarce medical supplies such as face masks, gloves, gowns, etc. and re-sell them to hospitals, clinics, doctors offices, and other professional medical organizations. Having no other purpose than to acquire (and re-sell) medical supplies, the business does not utilize a requisitions process. Its business begins with purchase orders placed by one of the three purchasing clerks for as large a quantity as possible of one or more of the medical supplies available from each supplier with whom Milltown Medical does business (e.g. Parsippany Paper Products). Medical supplies are received by one of two receiving clerks. Many suppliers currently do not allow Milltown Medical to place new orders until earlier orders have been shipped, and each order is placed for the largest quantity permitted at the time, so it would be unusual for a receipt to include medical supplies from more than one order; nevertheless, it is possible in rare cases because items unavailable for a given order (e.g. different sizes) may become available for a second order before the first is shipped out. Similarly, orders are normally received in full, given that they were already limited by available quantities; nevertheless, occasionally part shipments do happen because of production delays. In the circumstances, given the crisis caused by the Covid-19 pandemic, the nature of the products, and widespread demand for limited availability, Milltown Medical does not return items nor anticipate receiving allowances. Payment is made in full for each receipt within seven days by the accounts payable clerk. However, because orders are limited to available supplies at the time of ordering. Milltown Medical may place multiple orders and receive multiple shipments within just a few days, and so may pay for more than one receipt with a single payment. 1. Construct a BPMN Diagram 2 Create a class diagram - identify the classes and specify the associations and multiplicities 3. Identify the tables and link tables. Specify the primary keys for each. 4. Specify the foreign keys and other non-key attributes for each table 5. Implement in MSACCESS with business rules and constraints