Question: 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.

I need help In these ERD problems in Data Base Design, you

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!