Dental Supply Inventory:

Your organization is a medium sized single$-$site community dental clinic, and you will model the operations of the Supply Department $($SD$).$ The SD orders, stocks, and distributes consumable supplies to other operating departments $($OD$)$of the clinic. Supplies are ordered from vendors, some of which are manufacturers. While each vendor tends to specialize in certain categories of supplies there are no hard and fast rules and some supplies are provided by more than one vendor.

Most orders to vendors are for multiple items and always for case$-$lot sized units of each item and items are priced by the case. Prices change from order to order.Receipt of supplies is recorded, and a delivery may include some or all of the items on a vendor order and may even include items from more than one order to the same vendor. If any items are received the entire quantity of that item ordered will have been shipped. The SD receives requests for supplies from OD and satisfies them with daily 'retail' distributions of items. All items in stock will be delivered and back ordered items will be distributed when available. OD order some items as individual items $($e$.$g$.,$dental surgical loupes$)$while some are ordered as box or bag lots

$($e$.$g$.,$latex gloves$).$ The Supply Department maintains a current charge back price for items according to the unit of issue and adjusts these prices as vendor prices change. The SD maintains a storeroom with aisles, racks, and shelves

$($aisles have racks and racks have shelves$)$ and each supply item has a storage location. Some oversized items have numbered floor storage locations that do not belong to an aisle, rack, or shelf.

Your deliverable is to be a single Visio document uploaded to the assignment. The document will have two tabs in this order:

The drawing page: A single page $($which may be oversized if necessary$),$ containing your Entity Relationship Diagram $($ERD$).$

Table description page: The page containing your table descriptions.

Assignment Deliverables: Add all required non$-$key attributes to each entity.

Fix any multivalued attributes and any normalization violations through the third normal form $(3$NF$).$

Illustrate any supertype or subtype relationships you discover $($Week $6$ Module$).$

Always lay out ST$/$ST relationships in an organization chart format with the supertype on the top and the subtypes laid out below them.

Be sure to include the disjoint$/$overlap identifier in the descender from the supertype.

Be sure to include the subtype identifier attribute$($s$)$ in the supertype.

You will show all foreign keys needed in your model

You will show cardinalities and relationship names on all relationship lines $($except those between super$-$ and subtype entities$).$ Do not allow any M:M relationships to remain in your model.