Description of an Exercise
Work with the following database example.
The goal of this self assessment is that you are able to form SQL
queries that answer the questions below. Write a report where you explain your
queries and comment on the solutions and put this document on the discussion
board.
If you have any questions please post them also on the discussion board.
Of course you are welcome to check the other students solutions, comment on them
or answer questions from other students.
Exercises
- You have been hired by a company (represented in
the sample
database)
and have to add yourself in the table employee. Add at least
someone of your family in the according table. Also you should
add some hours of work to one of the projects.
Remark:
You don't have to add your birth date since the date format may
be a bit complicated!
- Select the columns you added in the different tables.
- Project 20 has been finished. Please delete all entries related
to project 20.
- Beate Tell leaves the company. Her position is taken over by
Sonja Maradona. Please make sure that these changes are made
correctly in your company database.
- All employees who's boss is Boris Frisch get a wage raise
of 10'000 Fr.
- Present some other typical database changes (and their solutions)
that might have to be done in this company.