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 cach table below is INCOMPLETE *Prices" table: Primary key = Orchid Name + Supplier#, Foreign key = Supplier#, Foreign key Orchid Name Supplier Wholesale Orchid Name Price Brassia 101 $10.00 Cattleya 103 $15.00 Cattleya 104 $15.00 Cymbidium 102 $15.00 Dedrobium 102 $15.00 nobile 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 $28.00 104 "Orchid Master" table: Primary key = Orchid Name(group), No foreign key Orchid Name Light (group) Heat Humidity Special Care Brassia Intermediate Intermediate Intermediatel Do not repot warm often Cattleya High Intermediate Intermediatel Dry out warm between watering Cymbidium High Intermediate Cool Need 6 weeks of cool temps in fall to bud Dedrobium High Intermediatel Warm No water, no nobile high fertilizer, cool night temp for 1 mo Dendrobium High Warm Intermediatel high Intermediate Miltonia Intermediate Intermediate Keep moist, do not subject to >80 degrees Humidity Heat Special Care Orchid Name (group) Light Oncidium High Intermediate Paphiopedilum Low Intermediate Intermediatel warm Intermediatel cool Intermediatel high Intermediate high Phalaenopsis Warm Low/ intermediate No night temps 54 degrees Repot often, do not let dry out Do not let sol dry out or become too wet Keep soll always moist water daily Keep same conditions every day Intermediate Phragmipediu m Intermediatel high Intermediate Vanda High High Warm "Wholesale Supplier" table: Primary key = Supplier#, No foreign key Supplier State/ Supplier Name Address Country 101 Daniela's Blooms 2340 Hwy South Taiwan 102 Plants and Such 45 Main Street Hawaii Gaylord's Florals 90 West Chester Columbia Pike 104 Dan's 1200 W. 104 St Florida Wholesalers 103 "Items" table: Primary key = Items#, Foreign key = Supplier# Item Died In Supplier Orchid Name Final Selling Sold ? Bloom? Price 1 Brassia No Yes 101 $25.00 Yes 2 Brassia No Yes 101 $25.00 Yes 3 Brassia No Yes 101 $25.00 Yes 4 Brassia Yes Yes 101 $25.00 Yes 5 Brassia No Yes 101 $25.00 Yes 6 Dendrobium No Yes 102 $30.00 Yes nobile 7 Dendrobium No Yes 102 $30.00 Yes nobile 8 Dendrobium No Yes 102 $30.00 Yes nobile 9 Vanda No Yes 104 $45.00 Yes 10 Vanda Yes 104 $45.00 No 11 Vanda No Yes 104 $45.00 Yes 12 Phragmipedium No Yes 103 $45.00 Yes Yes 10 From the above 4 tables of data, what type of relationships: one-to-one, one-to- many, many-to-many, or none between the following pairs of tables: Prices and Orchid Masters Prices and Wholesale Supplier Prices and Items Orchid Masters and Items Orchid Masters and Wholesale Supplier Items and Wholesale Supplier Alternatively, draw an entity relationship diagram (or schema) for the above 4 database tables. Note that for one-to-many relationship, you must state which table is on the 1-side, and which table is on the many-side