Question

Generate a complete ERD in Crow's Foot notation that be able to be implemented in relational model using the following description of operations. Hot Water (HW) is a small start-up company that sells spas. HW does not hold any stock. A few spas are set up in a simple warehouse so customers can see some of models available, other than any products sold have to be ordered at the time of sale.

1. HW can get spas from numerous different manufacturers.

2. Each manufacturer produces one or more changed brands of spas.

3. Each and every brand is formed by only one manufacturer.

4. Every brand has one or more models.

5. Every model is produced as part of brand. For instance, Iguana Bay Spas is a manufacturer that produces Big Blue Iguana spas, a premium-level brand, and Lazy Lizard spas, an entry-level brand. The Big Blue Iguana brand offers several models, including the BBI-6, an 81-jet spa with two 6-hp motors, and BBI-10, a 102-jet spa with three 6-hp motors.

6. Every manufacturer is identified by a manufacturer code. Company name, address, area code, phone number, and account number are kept in the system for every manufacturer.

7. For each brand, brand name and brand level (premium, mid-level, or entry-level) are kept in a system.

8. For each model, model number, number of jets, number of motors, number of horsepower per motor, suggested retail price, HW retail price, dry weight, water capacity, and seating capacity have to be kept in a system.