Question B3 (5 marks): Below is a relational database (4 related tables) for a retail flower shop that sells different types of orchid flowers. Note that the raw data in each table below is INCOMPLETE "Prices" table: Primary key = Orchid Name + Supplier#, Foreign key = Suppliert, Foreign key - Orchid Name 104 "Prices" table: Primary key = Orchid Name + Supplier#, Foreign key = Supplier#, Foreign key-Orchid Name Orchid Name Supplier # Wholesale Price Brassia 101 $10.00 Cattleya 103 $15.00 Cattleya $15.00 Cymbidium 102 $15.00 Dedrobium nobile 102 $15.00 Dendrobium 102 $10.00 Miltonia 103 $17.00 Oncidium 103 $18.00 Paphiopedilum 103 $19.00 Phalaenopsis 103 $10.00 Phragmipedium 103 $22.001 Vanda 104 $28.00 "Orchid Master" table: Primary key - Orchid Name(group). No foreign key Orchid Name Light Humidity Heat Special Care (group) Brassia Intermediate Intermediate Intermediate/warm Do not repot often Cattleya High Intermediate Intermediate/warm Dry out between watering Cymbidium High Intermediate Cool Need 6 weeks of cool temps in fall to bud Dedrobium nobile High Intermediate/high Warm No water, no fertilizer, cool night temp for 1 mo Dendrobium High Intermediate/high Warm Miltonia Intermediate Intermediate Intermediate Keep moist, do not subject to >80 degrees Oncidium High/intermediate Intermediate Intermediate/warm No night temps