DATABASE SYSTEMs, SQL

Consider the following relational model:

Employee(employeeID, firstname, lastname, country)

Project(projectID, name, country)

Worked(employeeID, projectID, date)

For the following exercises, use your docker container.

Discussion: 20.01.2021

a) (0points)Createanewdatabasenamedprojectsandchoosethisdatabaseforthefollowing exercises.

b)Create all tables by formulating all necessary DDL statements. Assume corre- sponding data types, define all primary and foreign keys properly and use automatically com- puted values for the IDs.

c) Fill the tables Employee and Project with meaningful test data using DML state- ments. Insert at least 3 tuples per table, whereby one employee should have the name Donald Duck, and one project should have the name DB exercises.