Ricardo Ferré

Databases

Personnel

Lectures: Ricardo Ferreé

Fundamentals of Database Systems,

Elmasri/Navathe, Benjamin Cummings 1994

Several

Mentioned chapters and exercises refer to the course text

Program

Week 	      Chapter	          Exercises 

Fundamentals, Database models, SQL

1

Introduction to databases, chapters 1 - 2 2.1-2.9

Relation database model chapter 6, 1.4,1.5 6.1-6.9

SQL chapter 7.1 - 7.3 ex. 7.7, 7.13, 7.17

Embedded SQL ch. 7.4, ex. 2.1, 2.10a ex. 7.18

Database Design

Functional dependencies, normal forms ch. 12.1-12.5 ex. 12.1-12.3, 12.6, 12.10, 12.17-12.21, 12.23, 12.27-12.28

System implementation

4

Transaction handling ch. 17 ex. 17.1-17.3, 17.8-17.9, 17.12-17.17

Physical storing and hashing ch. 4

Repetition

Repetition exercises

Old exams





Results





Send E-Mail to me