QUESTION 4 ONLY

question 1

A&H Boating can get boats from several different manufacturers. Each manufacturer produces one or more different types of boats. Each and every type is produced by only one manufacturer. Every manufacturer is identified by a manufacturer code. The company name, street, city, state, postcode, phone number, and account number are kept in the system for every manufacturer. For each type, the type name (i.e. Paddle, Inflatable, Jet Ski, etc.) and purpose (i.e. fishing, day boating, etc.) are kept in the system. Create an ERD that represents the entities, attributes, the relationships between entities, and the cardinality and optionality of each relationship that are described by this business rule.

Question 2

Every type has one or more models. Every model is produced as part of a type. For each model, the model number, engine, length, beam, suggested retail price, retail price and dry weight must be kept in the system. Add the entities, attributes, relationships between entities, cardinality and optionality of each relationship that are described by this business rule to the ERD that you created for business rule 1.

Question 3

Each types models are stored in a specific warehouse. Each warehouse stores the models of only one type. Each warehouse is identified by a warehouse ID. For each warehouse address, postcode, phone number are kept in the system.

Add the entities, attributes, relationships between entities, cardinality and optionality of each relationship that are described by this business rule to the ERD that you created for business rule 1 and business rule 2.

Question 4

Each warehouse can be visited by prospective customers with prior booking. Customers can book a visit to a specific warehouse by calling A&H Boating hotline. Customers need to provide full name, date of birth, address, email address and contact number during booking a visit to a warehouse. Add the entities, attributes, relationships between entities, cardinality and optionality of each relationship that are described by this business rule to the ERD that you created for business rule 1, 2 and 3.