Question: Please solve question #4 and question 2 would give you an example for it thanks! Do it by using dioramas 2. (Connect) Paige ran a
Please solve question #4 and question 2 would give you an example for it thanks! Do it by using dioramas 2. (Connect) Paige ran a small frozen yogurt shop. She bought several favors of frozen yogurt mix from her yogurt supplier. She bought plastic cups in several sizes from another supplier. She bought cones from a third supplier. She counts yogurt and cones as inventory, but she treats the ups as operating expense and doesn't track any cup inventory. The simple diagram below describes Paige's purchases. Normally, a purchase must involve at least one inventory item, but she expenses the cups upon purchase, so a cup purchase involves O inventory items whereas a yogurt or cone purchase involves at least one inventory item. This model also assumes that suppliers are recorded before items are purchased from them. InventoryPurchases Suppliers 3. (Connect) A table structure to support problem 1 would look like: Patients[Patient ID (PK), Patient Name, Patient Address.,.. Sales/Visits [Patient Visit Number (PK), Date, Basic Fee, Other Charges, Total Amount Due, Patient ID (FK!, Tests/Services Test/Service ID (PK), Test/Service Description, Charge for this Test/Service, J (Connect) A table structure to support problem 2 would look like: SuppliersSupplier ID (PK), Supplier Name, Supplier Addres.,...) Purchases [Purchases Number (PK), Supplier ID (FK), Date, Amount, Inventory [Inventory ID (PK), Inventory Description, Quantity on Han Purchase-Items [Purchases Number+Inventory ID (PK), Quantity Purchased
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
