In the weekly assignment there are 3 questions which must be solved following a given scenario.

Scenario Vaccinations are currently in question. It is important to keep track of which ones to be vaccinated and those who have already been vaccinated. Therefore, of course, we must create one database. What is to be stored in the database is the following: 1. Person. Each person has a unique social security number, a name, an address, an age and body weight. The person also has a priority, which is an integer greater than or equal to zero. 2. Vaccination-sites. The site has a unique number, a unique name, and one address. 3. Vaccinations. A vaccination takes place on a certain date, on a certain vaccination site, and a specific person is being vaccinated. We do not know how as long as the immunity from vaccination is sufficient, so one and the same person can need to be vaccinated several times. 4. Group-vaccinations. To save money, it has also been introduced group vaccinations, with an extra-long needle so you can vaccinate several people instantly. A group vaccination is just like a regular vaccination, except that several people are being vaccinated. Assignment 1 Draw an ER or EER diagram for the described database. Use the information in scenario above, but also keep in mind that it should be possible to answer the questions in the third assignment below. ER and EER diagrams can be drawn in several different ways. If you use another notation than the textbook, you must explain the notation you are using Assignment 2 Implement the described database in the relational model, ie translate the ER diagram into tables. The implementation should be good. A) Show a clear overview of your tables. Indicate which relationships exist and which attributes each relationship contains, with well-chosen sample data. Also enter all candidate keys, which of ese is the primary key, and which reference attributes existing and what they refer to. B) The sub-question above states that you must state which relationships exist. What is a relationship? C) Type the SQL commands needed to create the tables, with appropriate ones privacy conditions. Assignment 3 Formulate the following questions in SQL. Feel free to define views or CTEs about it facilitates but does not create new tables. A) The person Anna Alm has been vaccinated, with a regular vaccination (not one group vaccination). Where? Enter the address of the vaccination site. B) The person Bengt Berg has been vaccinated with a group vaccination. What are the names of the other people who were vaccinated at the same time? C) How many people have been vaccinated with group vaccinations? D) What is the name of the person who has the highest priority, of those who are not yet vaccinated (either with a regular vaccination or a group vaccination)