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 = Supplier, Foreign key = Orchid Name- Orchid Name Supplier # Wholesale Price Brassia 1012 $10.00 Cattleya 103 $15.00 Cattleya 104 $15.00 Cymbidiume 102e $15.00 Dedrobium nobile 102 $15.00 Dendrobium 1022 $10.00 Miltonia- 103 $17.00 Oncidium 1032 $18.00 Paphiopedilum 1032 $19.00 Phalaenopsis 1032 $10.00 Phragmipedium 1032 $22.00 Vanda 1042 $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 Coole Need 6 weeks of cool temps in fall to bude Dedrobium High Intermediate/high Warm No water, no nobile fertilizer, cool night temp for 1 pune Orchid Name Light Humidity Heat Special Care (group) Dendrobium Highe Intermediate/high Warm Miltonia- Intermediate Intermediate Intermediate Keep moist, do not subject to >80 degrees Oncidium High/Intermediate Intermediate Intermediate/warm No night temps