Case Study 3 - The Orchid Seller

In this case, I have designed a relational database for an orchid seller,
Bob. Then I have created database tables and populated them with data.

DELIVERABLES

     1.Word-processed design of tables
     2.Tables created in Access
     3.Query 1: Greenhouse Requirements
     4.Query 2: Orchids That Died
     5.Query 3: Orchids Not in Bloom
     6.Query 4: Best Sellers
     7.Query 5: Most Profitable Orchid Groups
     8.Report: Profit by Supplier

1.Word-processed design of tables

2.Tables created in Access


Orchid Information Table



Sales Table



Wholesaler Information Table





3.Query 1: Greenhouse Requirements

Parameters


Query Result





4.Query 2: Orchids That Died





5.Query 3: Orchids Not in Bloom





6.Query 4: Best Sellers





7.Query 5: Most Profitable Orchid Groups





8.Report: Profit by Supplier