DATABASE system, SQL

Consider the following relational model:

Employee(employeeID, firstname, lastname, country)

Project(projectID, name, country)

Worked(employeeID, projectID, date)

Create a new database named projects and choose this database for the following exercises.

a) Find a way to insert an entry into the table Working anzulegen, which connects the employee Donald Duck with the project DB exercises and the date 24.12.2020. Important: do not use fixed IDs that you inserted (e.g., using 2 as the ID of Donald Duck because you know that you inserted it like that), but rather compute those values inside the statement.

b) At first change the country of all employees with the lastname Duck to be USA. Then delete the project DB exercises from the Project table.