Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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.

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Strategy

Authors: Mike W. Peng

5th Edition

0357512367, 978-0357512364

More Books

Students also viewed these Accounting questions

Question

Discuss the funding mechanisms for NQDC plans. AppendixLO1

Answered: 1 week ago

Question

What is a sales volume variance?

Answered: 1 week ago