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 ho3e $15.00 Cattleya $15.00 h1042 Cymbidium h02 $15.00 $15.00 Pedrobium nobile 02 Dendrobium 02 $10.00 $17.00 $18.00 Miltonia 1032 pacidium 1032 Paphiopedilum 103 Phalaenopsis 103 $19.00 $10.00 $22.00 Pbragmiredium 103 Nanda 11042 $28.00 "Orchid Master table: Primary key = Orchid Name(group), No foreign key- Orchid Name Light Humidity Heat (group) Special Care Brassia, Intermediate Intermediate Intermediate/warm po not repot bften Cattleya High Intermediate Intermediate/warm Pry out between watering Cymbidium High Intermediate Coole Need 6 weeks of cool temps in fall to bude High Intermediate/high Warm No water, no Pedrobium bobile fertilizer, cool hight temp for 1 ma Orchid Name Light Humidity Heat Special Care (group) Dendrobium High Intermediate/high Warm Miltonia ntermediate Intermediate Intermediate Keep moist, do hot subject to $80 degrees pacidium High/Intermediate Intermediate ntermediate/warm No night temps k64 degrees Paphiopedilum Low Intermediate/high Intermediate/cool Repot often, do hot let dry out Phalaenopsis Low/intermediate Intermediate/high Warm Do not let soil dry but or become Joo wet Poragmiredium Intermediate Intermediate/high Intermediate Keep soil always moist, water daily Nandae High Highe Warm Keep same Conditions every Jaye "Wholesale Supplier" table: Primary key = Supplier#, No foreign key Supplier # Supplier Name Address State/Country hone Daniela's Blooms 2340 Hwy South Taiwane 1102 Plants and Suche 15 Main Street Hawaiie 103 Gaylord's Floralse po West Chester Pike Columbia 104 Dan's Wholesalers 1200 W. 104 St Florida "Items table: Primary key = Items#, Foreign key = Supplier# tem # Orchid Name Died? In Bloom? Supplier # Final Selling Price Sold? 1 Brassia No $25.00 Yes Yes 1012 Yes hone 2 Brassia No $25.00 Yes No Yes 1012 $25.00 Yes 3 Brassia 4 Brassia Yes Yes 101e $25.00 Yes No Yes 101 $25.00 Yes 5 Brassia 6 Dendrobium nobile No Yes 102 $30.00 Yes tem # Orchid Name Died? In Bloom? Supplier # Final Selling Price Sold? 7 Dendrobium nobile No Yes 1022 $30.00 Yes 8 Dendrobium nobile No Yes 102 $30.00 Yes 9 Vandaa No Yes 104 $45.00 Yes 10 Vanda Yes Yes 104 $45.00 No 11 Vandae No Yes 1042 $45.00 Yes No Yes 1032 $45.00 Yes 12 ebragmiredium 13 Phalaenopsis 14 Miltonia Yes No 103 $25.00 No No Yes 1032 $32.00 Yes No Yes 1032 $33.00 Yes 15 Oncidium 16 Cattleya No Yes 103 $25.00 Yes No Yes 04 $25.00 Yes No Yes 102 $31.00 Yes 17 Cattleya 18 Symbium 19 Paphiopedilum 20 Paphiopedilum 21 Brassia No Yes 1032 $25.00 Yes No Yes 103 $25.00 Yes No Yes hone $25.00 Yes 22 Brassia No Yes 101 $25.00 Yes No Yes 101e $25.00 Yes No Yes 1012 $25.00 Yes 23 Brassia 24 Brassia. 25 Brassia 26 Brassia No Yes 101e $25.00 Yes Yes Yes 1012 $25.00 Yes 27 Brassia No Yes 101 $25.00 Yes No Yes 102 $30.00 Yes 28 Dendrobium nobile 29 Dendrobium nobile No Yes 102 $30.00 Yes 30 Dendrobium nobile No Yes 102 $30.00 Yes 31 Vandae No Yes hoe $45.00 Yes 32 Vandae Yes Yes 1042 $45.00 No 33 Vanda No Yes 04 $45.00 Yes 34 Pragmiredium No Yes 103 $45.00 Yes Yes No 103 $25.00 No 35 Phalaenopsis 36 Miltonia No Yes 1032 $32.00 Yes No Yes 1032 $33.00 Yes 37 Oncidium 38 Cattleya No Yes 103 $25.00 Yes j tem # Orchid Name Died? In Bloom? Supplier # Final Selling Price Sold? Yes 1042 $25.00 Yes No Yes 102 $31.00 Yes No 39 Cattleya 40 Symbium 41 Paphiopedilum 42 Paphiopedilum No Yes 103 $25.00 Yes No $25.00 Yes No Yes 103 Yes 101 Yes hoe 43 Brassia 44 Brassia. $25.00 Yes No $25.00 Yes 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. (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 ho3e $15.00 Cattleya $15.00 h1042 Cymbidium h02 $15.00 $15.00 Pedrobium nobile 02 Dendrobium 02 $10.00 $17.00 $18.00 Miltonia 1032 pacidium 1032 Paphiopedilum 103 Phalaenopsis 103 $19.00 $10.00 $22.00 Pbragmiredium 103 Nanda 11042 $28.00 "Orchid Master table: Primary key = Orchid Name(group), No foreign key- Orchid Name Light Humidity Heat (group) Special Care Brassia, Intermediate Intermediate Intermediate/warm po not repot bften Cattleya High Intermediate Intermediate/warm Pry out between watering Cymbidium High Intermediate Coole Need 6 weeks of cool temps in fall to bude High Intermediate/high Warm No water, no Pedrobium bobile fertilizer, cool hight temp for 1 ma Orchid Name Light Humidity Heat Special Care (group) Dendrobium High Intermediate/high Warm Miltonia ntermediate Intermediate Intermediate Keep moist, do hot subject to $80 degrees pacidium High/Intermediate Intermediate ntermediate/warm No night temps k64 degrees Paphiopedilum Low Intermediate/high Intermediate/cool Repot often, do hot let dry out Phalaenopsis Low/intermediate Intermediate/high Warm Do not let soil dry but or become Joo wet Poragmiredium Intermediate Intermediate/high Intermediate Keep soil always moist, water daily Nandae High Highe Warm Keep same Conditions every Jaye "Wholesale Supplier" table: Primary key = Supplier#, No foreign key Supplier # Supplier Name Address State/Country hone Daniela's Blooms 2340 Hwy South Taiwane 1102 Plants and Suche 15 Main Street Hawaiie 103 Gaylord's Floralse po West Chester Pike Columbia 104 Dan's Wholesalers 1200 W. 104 St Florida "Items table: Primary key = Items#, Foreign key = Supplier# tem # Orchid Name Died? In Bloom? Supplier # Final Selling Price Sold? 1 Brassia No $25.00 Yes Yes 1012 Yes hone 2 Brassia No $25.00 Yes No Yes 1012 $25.00 Yes 3 Brassia 4 Brassia Yes Yes 101e $25.00 Yes No Yes 101 $25.00 Yes 5 Brassia 6 Dendrobium nobile No Yes 102 $30.00 Yes tem # Orchid Name Died? In Bloom? Supplier # Final Selling Price Sold? 7 Dendrobium nobile No Yes 1022 $30.00 Yes 8 Dendrobium nobile No Yes 102 $30.00 Yes 9 Vandaa No Yes 104 $45.00 Yes 10 Vanda Yes Yes 104 $45.00 No 11 Vandae No Yes 1042 $45.00 Yes No Yes 1032 $45.00 Yes 12 ebragmiredium 13 Phalaenopsis 14 Miltonia Yes No 103 $25.00 No No Yes 1032 $32.00 Yes No Yes 1032 $33.00 Yes 15 Oncidium 16 Cattleya No Yes 103 $25.00 Yes No Yes 04 $25.00 Yes No Yes 102 $31.00 Yes 17 Cattleya 18 Symbium 19 Paphiopedilum 20 Paphiopedilum 21 Brassia No Yes 1032 $25.00 Yes No Yes 103 $25.00 Yes No Yes hone $25.00 Yes 22 Brassia No Yes 101 $25.00 Yes No Yes 101e $25.00 Yes No Yes 1012 $25.00 Yes 23 Brassia 24 Brassia. 25 Brassia 26 Brassia No Yes 101e $25.00 Yes Yes Yes 1012 $25.00 Yes 27 Brassia No Yes 101 $25.00 Yes No Yes 102 $30.00 Yes 28 Dendrobium nobile 29 Dendrobium nobile No Yes 102 $30.00 Yes 30 Dendrobium nobile No Yes 102 $30.00 Yes 31 Vandae No Yes hoe $45.00 Yes 32 Vandae Yes Yes 1042 $45.00 No 33 Vanda No Yes 04 $45.00 Yes 34 Pragmiredium No Yes 103 $45.00 Yes Yes No 103 $25.00 No 35 Phalaenopsis 36 Miltonia No Yes 1032 $32.00 Yes No Yes 1032 $33.00 Yes 37 Oncidium 38 Cattleya No Yes 103 $25.00 Yes j tem # Orchid Name Died? In Bloom? Supplier # Final Selling Price Sold? Yes 1042 $25.00 Yes No Yes 102 $31.00 Yes No 39 Cattleya 40 Symbium 41 Paphiopedilum 42 Paphiopedilum No Yes 103 $25.00 Yes No $25.00 Yes No Yes 103 Yes 101 Yes hoe 43 Brassia 44 Brassia. $25.00 Yes No $25.00 Yes 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