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. 101 "Prices table: Primary key = Orchid Name + Supplier#, Foreign key = Supplier, Foreign key = Orchid Name Orchid Name Supplier #Wholesale Price Brassia $10.00 Cattleya 103 $15.00 Cattleya 104 $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.00 Vanda 104 $28.00 Orchid Master" table: Primary key = Orchid Name(group), No foreign key Orchid Name Light Humidity (group) Heat Special Care ssia 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 High Intermediate/high Warm No water, no nobile 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