Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 101 $10.00 1032 $15.00 Cattleya Cattleya Cymbidium 1042 $15.00 1024 $15.00 Dedrobium nobile 102 $15.00 Dendrobium 102 $10.00 Miltonia 1032 $17.00 Oncidium 103 $18.00 wwwwwwwww $19.00 Paphiopedilum 1034 Phalaenopsis 1034 $10.00 Phragmipedium 103 $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 bften Cattleya High Intermediate Intermediate/warm Dry out between watering Cymbidium High Intermediate Cool Need 6 weeks of cool temps in fall to bud High Intermediate/high Warm No water, no Dedrobium nobile fertilizer, cool hight temp for 1 po Dendrobium High Intermediate/high Warm Miltonia Intermediate Intermediate Intermediate Keep moist, do hot subject to >80 degrees Oncidium High/Intermediate Intermediate Intermediate/warm No night temps k64 degrees Paphiopedilum Low Intermediate/high Intermediate/cool Repot often, do not let dry out Phalaenopsis Low/intermediate Intermediate/high Warm Do not let soil dry but or become too wet Phragmipedium-Intermediate Intermediate/high Intermediate Keep soil always moist, water daily Vanda High High Warm Keep same conditions every day Wholesale Supplier table: Primary key = Supplier#, No foreign key Supplier # Supplier Name Address State/Country Daniela's Blooms 2340 Hwy South Taiwan 1014 102 Plants and Such 45 Main Street Hawaii 1034 Gaylord's Florals 90 West Chester Pike Columbia 104 Dan's Wholesalers 1200 W. 104 St Florida "Items table: Primary key = Items#, Foreign key = Supplier# Item # Orchid Name Died? In Bloom? Supplier # Final Selling Price Sold? 1 Brassia Yes 101 $25.00 Yes 2 Brassia No Yes 101 $25.00 Yes No 3 Brassia No Yes 1012 $25.00 Yes 4 Brassia Yes Yes 101 $25.00 Yes 5 Brassia Yes 101 $25.00 Yes 6 Dendrobium nobile ZZZ Yes 102 $30.00 Yes 7 Dendrobium nobile Yes 102 $30.00 Yes 8 Dendrobium nobile Yes 102 $30.00 Yes 9 Vanda Yes 104 $45.00 Yes 10 Vanda Yes 2 2 2 2 Yes 104 $45.00 No 11 Vanda Yes 104 $45.00 Yes Yes 1032 $45.00 Yes 12 Pbragwipedium 13 Phalaenopsis Yes No 1032 $25.00 No 14 Miltonia No Yes 1032 $32.00 Yes 15 Oncidium No Yes 1034 $33.00 Yes 16 Cattleya No Yes 1032 $25.00 Yes 17 Cattleya Yes 104 $25.00 Yes Yes 1024 $31.00 Yes 18 Cymbium 19 Paphiopedilum 20 Paphiopedilum | | | M No Yes 1034 $25.00 Yes Yes 1032 $25.00 Yes 21 Brassia No Yes 101 $25.00 Yes 22 Brassia No Yes 1012 $25.00 Yes 23 Brassia No Yes 1012 $25.00 Yes No Yes 101 $25.00 Yes 24 Brassia 25 Brassia No Yes 101 $25.00 Yes 26 Brassia Yes Yes 101 $25.00 Yes No Yes 101 $25.00 Yes 27 Brassia 28 Dendrobium nobile No Yes 102 $30.00 Yes 29 Dendrobium nobile No Yes 1024 $30.00 Yes 30 Dendrobium nobile No Yes 102 $30.00 Yes 31 Vanda No Yes 104 $45.00 Yes Item # Orchid Name Died? In Bloom? Supplier # Final Selling Price Sold? 32 Vanda Yes Yes 104 $45.00 No 33 Vanda No Yes 104 $45.00 Yes 34 Phragmipedium No Yes 1032 $45.00 Yes 35 Phalaenopsis Yes No 1034 $25.00 No 36 Miltonia No Yes 1032 $32.00 Yes 37 Oncidium No Yes 1032 $33.00 Yes wwwwwwwwwwwww 38 Cattleya No Yes 1032 $25.00 Yes 39 Cattleya No Yes 104 $25.00 Yes 40 Cymbium No Yes 102 $31.00 Yes wwwwwwww 41 Paphiopedilum 2 2 2 2 No Yes 103 $25.00 Yes 42 Paphiopedilum No Yes 1034 $25.00 Yes 43 Brassia No Yes 1012 $25.00 Yes 44 Brassia No Yes 1012 $25.00 Yes wwwwwwwwwwwww 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. A 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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Database Management

Authors: Donald A. Carpenter Fred R. McFadden

1st Edition

8178088045, 978-8178088044

More Books

Students also viewed these Databases questions

Question

Discuss communication challenges in a global environment.

Answered: 1 week ago