Case 3 - Orchid Seller

Designing Relational Database


















Creating Tables Using MS Access
1. Orchid

2. OrchidItem

3. Wholesaler

Query 1: Greenhouse Requirements

Result:

Query 2: Orchids That Died

Query 3: Orchids Not in Bloom

Query 4: Best Sellers

Query 5 : Most Profitable Orchids Groups

Report: Profit by Supplier