[Solved]Karl Andersson Boat Rental Summer Seas Deal Every Year Would Much Convenient Everything Or Q37253718

Karl Andersson has a boat rental. As summer seas that he has to deal with every year. It would be so much more convenient to have everything organized digitally. His friend comes up with a first draft of an ER model shown in Figure 1. on approaches, he thinks of the mess of paper name iconcoplato street customor<make boat clude kind rental nr namo pcode status From_datetime city To_datetime Figure I. ER model Every boat has a license plate that identifies the boat, a name, and a type (sailing-, motor boat etc.). Furthermore, Karl stores the customer’s name and address (pcode is the postal code). Every rental has a number. A boat is rented from a certain date and time to a certain date and time. The status stores the information whether the boat has been returned or not. a) Mark the primary key in the ER model (adjust the model if necessary) and give a short explanation, why the primary keys are possible to use. b) Add cardinality ratios and briefly explain your decision. c) Translate the ER model to the relational model. For the relationship types: Do you need an extra table? Why or why not? Show transcribed image text Karl Andersson has a boat rental. As summer seas that he has to deal with every year. It would be so much more convenient to have everything organized digitally. His friend comes up with a first draft of an ER model shown in Figure 1. on approaches, he thinks of the mess of paper name iconcoplato street customor

Expert Answer

---

Answer to Karl Andersson has a boat rental. As summer seas that he has to deal with every year. It would be so much more convenien… . . .