JJ Charters is a new business that charters (rents) sailboats and yachts. The business offers a range of boats and crew options for experienced and novice sailors. For example, crew options can include chartering a boat as bareboat (i.e. without a crew), or with a skipper or a full crew. When clients charter a boat, they are asked to provide their driver’s license, credit card details and contact details (e.g. address). Clients are then “checked out” with a boat, and details such as date and time out. When the boat is returned, it is “checked in” and the date and time is recorded. If the boat has been involved in an incident which leaves it severely damaged, the client may be charged on their credit card for the repairs to the boat. JJ Charters plan to use MS Access to set up a relational database for their new business. Many of JJ’s clients are repeat clients, but for clients to be included in the database they must have chartered a boat at least once. A charter agreement is then created each time a boat is chartered. In most cases, boats are not damaged at all when they are chartered. However, when there is an incident (such as grounding or hitting a dock too hard) one or more damages may occur; hence, a client could have several repair costs to deal with.

Required:

(a) Draw an ER-diagram for JJ Charters which includes the correct relationships between the entities and their cardinalities. Include at least three important attributes for each entity (including primary key).

 (b) Consider your ER-diagram above. Identify TWO questions that JJ Charters could ask that your data model could answer by combining the data (or information) from two or more entities. For each of the two questions you identify: (i) state the question, and (ii) clearly identify the entities and the data you would need to answer the questions.