Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help In these ERD problems in Data Base Design, you can do them by hand writing or using computer. 2. Create a complete

I need help In these ERD problems in Data Base Design, you can do them by hand writing or using computer.

image text in transcribed

2. Create a complete ERD in Crow's Foot notation that can be implemented in the relational model using t following description of operations. Hot Water (HW) is a small start-up company that sells spas. HW does n carry any stock. A lew spas are set up in a simple warehouse so customers can see some of the models availabl but any products sold must be ordered at the time of the sale. HW can get spas from several different manufacturers. Each manufacturer produces one or more different brands of spas. Each and every brand is produced by only one manufacturer. Every brand has one or more models Every model is produced as part ol a brand. For example, guana Bay Spas is a manufacturer t produces Big Blue iguana spas, a premium-level brand, and Lazy Lizard spas, an entry-level brand. Big Blue Iguana brand ollers several models, including the BB-6, an 81-jet spa with two 6-hp mot and the BBI-10, a 102-jet spa with three 6-hp motors. Every manufacturer is identified by a manufacturer code. The company name, address, area code, ph number, and account number are kept in the system for every manufacturer. For each brand, the brand name and brand level (premium, mid-level, or entrylevel) are kept in the syst For each model, the model number, number of jets, number of motors, number ol horsepower per m suggested retail price, HW retail price, dry weight, water capacity, and seating capacily must be ke the system

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

JDBC Database Programming With J2ee

Authors: Art Taylor

1st Edition

0130453234, 978-0130453235

More Books

Students also viewed these Databases questions

Question

3. Provide advice on how to help a plateaued employee.

Answered: 1 week ago