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 anPlease 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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!