GITTA-Logo
PDF Version of this document Search Help Glossary

Lesson Navigation IconRelationales Datenmodell

Unit Navigation IconKonzepte

Unit Navigation IconAbbildung ER-Schema

Unit Navigation IconData integrity

Unit Navigation IconNormalisierung

LO Navigation IconDependencies

LO Navigation IconFirst normal form (1NF)

LO Navigation IconSecond normal form (2NF)

LO Navigation IconThird normal form (3NF)

LO Navigation IconExercise Normalisation

LO Navigation IconUnit-Zusammenfassung

Unit Navigation IconSummary

Unit Navigation IconRecommended Reading

Unit Navigation IconGlossary

Unit Navigation IconBibliography

Unit Navigation IconMetadata


GITTA/CartouCHe news:


Go to previous page Go to next page

Exercise Normalisation

The following table is already in first normal form (1NF). There is only one entry per field. Please convert this table to the third normal form (3NF) using the techniques you learned in this Unit. Write a short report about your solution and post it in the discussion board. Check the other solutions and comment them, if necessary. If you have questions, you can also post them in the discussion board. A tutor will look at the questions regularly and give feedback and answers.

A table with the students and their grades in different topics.

UnitID StudentID Date TutorID Topic Room Grade Book TutEmail
U1 St1 23.02.03 Tut1 GMT 629 4.7 Deumlich tut1@fhbb.ch
U2 St1 18.11.02 Tut3 GIn 631 5.1 Zehnder tut3@fhbb.ch
U1 St4 23.02.03 Tut1 GMT 629 4.3 Deumlich tut1@fhbb.ch
U5 St2 05.05.03 Tut3 PhF 632 4.9 Dümmlers tut3@fhbb.ch
U4 St2 04.07.03 Tut5 AVQ 621 5.0 SwissTopo tut5@fhbb.ch
Top Go to previous page Go to next page