Answered step by step
Verified Expert Solution
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.
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 systemStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started