First page Back Continue Last page Graphics
Preparation for labsession 1
Study chapter 7 of the database book, up to and including section 7.3.1.
- 7.1 talks about “first normal form”: having atomic values
- 7.2 explains pitfalls in database design: it describes constraints and redundancy
- 7.3.1 defines functional dependencies, the most important constraints in Databases 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.