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 101 $10.00 Cattleya 103 $15.00 Cattleya 104 $15.00 Cymbidium 102 Dedrobium. Dobile 102 $15.00 $ $15.00 Dendrobium 102 $10.00 Orchid Name (group) Light Humidity Heat Special Care Vanda- High High- Warm moist, water daily Keep same conditions every day "Wholesale Supplier" table: Primary key = Supplier, No foreign keys Supplier # Supplier Name Address State/Country 101 Daniela's Blooms 2340 Hwy South Taiwane 102 Plants and Such 45 Main Street Hawaii 103 Gaylord's Floralse po West Chester Pike Columbia 1104 Dan's Wholesalers 1200 W. 104 Ste Florida + "Items table: Primary key = Items Foreign key = Supplier tem #1 Orchid Name Pied? In Bloom? Supplier #Final Selling Price Sold? 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 Dendrobium nobile. No Yes 102 $30.00 Yes 7 Dendrobium dabile No Yes 102 $30.00 Yes 8 Dendrobium dabile No Yes 102 $30.00 Yes 9 Vanda No Yes 104 $45.00 Yes 10 Vanda Yes Yes 104 $45.00 No 11 Vanda No Yes 104 $45.00 Yes 12 Phraspinedium No Yes 103 $45.00 Yes 13 Phalaenopsis Yes No 103 $25.00 No 14 Mitooja No Yes 103 $32.00 Yes 15 Qosiding No Yes 1032 $33.00 Yes 16 Cattleya No Yes 103 $25.00 Yes 17 Cattleya No Yes 104 $25.00 Yes 18 Cobius No Yes 102 $31.00 Yes Died? In Bloom? Supplier #Final Selling Price Sold? Yes 103 $25.00 Yes $25.00 Yes Item # Orchid Name 19 Paphiopedilum 20 Paphiopedilum 21 Brassia 22 Brassia 23 Brassia 24 Brassia Yes 103 Yes 101 $25.00 Yes 999 999 $25.00 Yes Yes 101 Yes 101 $25.00 Yes Yes 101 $25.00 Yes 25 Brassia No Yes 101 $25.00 Yes Yes Yes 101 $25.00 Yes 26 Brassia 27 Brassia 28 Dendrobium nobile No $25.00 Yes No Yes 101 Yes 102 Yes 102 $30.00 Yes 29 Dendrobium nobile No $30.00 Yes 30 Dendrobium nobile No Yes 102 $30.00 Yes 31 Vanda No Yes 104 $45.00 Yes 32 Vanda Yes $45.00 No No Yes 104 Yes 104 Yes 103 $45.00 Yes No $45.00 Yes Yes No 103 $25.00 No No Yes 103 $32.00 Yes No Yes 103 $33.00 Yes 33 Manda 34 Abraamipediu 35 Phalaenopsis 36 Miltonia 37 Qosidios 38 Cattleya 39 Cattleya 40 xmbios 41 Paphiopedilume 42 Paphiopedilum 43 Brassia No Yes 103 $25.00 Yes Yes Yes 104 Yes 102 $25.00 $31.00 Yes 2 2 2 2 Yes 103 $25.00 Yes Yes 103 $25.00 Yes No Yes 101 $25.00 Yes 44 Brassia No Yes 101 $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 412 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