Create an ERD in Crow's Foot or UML notation that can be implemented in the relational model using the following description of operations. Hot Water (HW) is a small start-up company that sells spas. HW does not carry any stock. A few spas are set up in a simple warehouse so customers can see some of the models available, 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 of a brand. Every manufacturer is identified by a manufacturer code. The company name, address, area code, phone 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 entry- level) are kept in the system. • For each model, the 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 must be kept in the system.

We would like to develop a database that captures the following requirements.   A University student can enrol in a course and at least in one major. In fact, a student can enrol in many majors within that course. During the semesters, a student can enrol in units. We want to capture in which year and in which semester a student enrolled in each unit. We have two semesters: Semester 1 and Semester 2. A unit has a code, a title and the number of credit points. We would like also to record the student’s GPA. A course has a code and a name. A major has a code and a name. Also, a major belongs to a course. A unit can be part of either a course or a major. A unit can also be shared across different courses and different majors. Important to note: Provide your design in a textual form, i.e. Entity(Attribute1, Attribute2, Attribute3, …).  Make sure that the primary keys of each entity are underlined (Attribute1 in the example above) and foreign keys are indictated in bold (Attribute3 in…

I'm having trouble with this question with my data modeling class. " Scenario: Jonny is appointed as an intern position, which might lead to a junior database architect role in TechTrend Corporation (TTC). Jonny is assigned to redesign two legacy tables related to "Suppliers," to be normalization compliant. The following business rules are provided. Business Rules: 1. Suppliers can be local or national, thus can have multiple locations. 2. Any location can supply items to TechTrend. 3. Any location manager can have a separate pricing deal with TechTrend, based on production process specific to that location and localization efficiency. 4. Each location has a contact person assigned to TechTrend. 5. Traditionally, TechTrend dealt with a singular location, at the most two. With rapid growth in business, the TTC officials are finding better leverage possibilities to negotiate beneficial terms with suppliers in multiple locations. 6. The DB administrator has specifically requested Johnny…