CS-A1153 - Databases (summer course), 04.06.2020-03.09.2020

a) (8 p) Based on the description below, construct a UML diagram for an insurance company to model its
customers, insurance policies it has sold, damages, and compensation claims. Use the notation used in
the course text book and mark the key attributes like they are marked in the course text book (and in
the lecture slides, too). Your diagram does not include such parts of the database which have not been
described below.
Each customer has a unique ID, a name, an address and e-mail address. One customer may have several
insurance policies and the same insurance policy may have several owners (for example, a couple may own
together their home insurance). Each insurance policy has a unique ID, the type of the insurance (car or
home, for example) and a yearly payment.
In addition, the database includes information about damages and compensation claims connected to
them. Each damage is connected with exactly one insurance policy. In addition, the company wants to
store a unique ID, the date, the type of the damage, and the compensation claims connected to the
damage. Several compensation claims may be connected to the same damage (for example an illness may
cause different types of costs during several years). For each compensation claim, the information stored
includes also the date of the claim, the sum the customer asks to be paid, and the decision (the sum the
company will pay).

b) (2 p) Convert the UML diagram from part (a) into relations. Write the relation schemas and underline
the names of the key attributes.

Provide the answer to part (a) as a PDF file. You may submit the answer to (b) in the same file, or in the text area (but if you use the text area, don't forget to indicate the key attributes).