First page Back Continue Last page Graphics

Preparation for labsession 1


Notes:

Before each labsession in this course you need to study part of the database book. During the labsession you will be given exercises that you cannot answer if you have not studied the corresponding part of the book.
For the Database Design track of this course you need to study the beginning of chapter 7, up to section 7.3.1.
Section 7.1 explains “first normal form”, or the need for using only atomic values. Structured entities like a postal address need to be decomposed into atomic parts like street, number, postal code and city in order to use them in a relational database.
Section 7.2 introduces constraints, redundancy and decomposition, and the role these concepts play in databases.
Section 7.3.1 introduces the most important type of constraint for this course: the functional dependencies.