GITTA-Logo
PDF Version of this document Search Help

Lesson Navigation IconAnfragesprache SQL

Unit Navigation IconSQL Overview

Unit Navigation IconBasic database queries

Unit Navigation IconSQL Insert, Delete and Update

Unit Navigation IconSummary

Unit Navigation IconRecommended Reading

Unit Navigation IconBibliography

Unit Navigation IconMetadata


GITTA/CartouCHe news:


Go to previous page Go to next page

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.
Top Go to previous page Go to next page