Databases
Daniel Rodríguez
This unit introduces the principles of databases. The student will learn how:
to write SQL statements
design DBMS schemas using the E/R model
and write Java code that make use of SQL
Bibliography
Silberschatz, A., Korth H. F., and SudarshanDatabase, S.,
System Concepts, Sixth Edition
, McGraw-Hill, 2010, ISBN 0-07-352332-1
Elmasri, Ramez, Navathe, Sham, Fundamentals of database systems, Sixth Edition, Pearson/Addison-Wesley, 2011, ISBN13: 9780136086208
Date, C.J., An Introduction to Database Systems (8th Edition), Addison-Wesley, 2003, ISBN13: 978-0321197849
Conolly, T.M., Begg, C., Database Systems: A Practical Approach to Design, Implementation, and Management (5th Edt), Pearson, 2005, ISBN-13: 9780321523068
Outline
Introduction to Databases
E/R Model
SQL
Algebra and Relational Calculus
Integrity and Functional Dependencies
Normalisation
Triggers, assertions, security
Lecture Notes
We will use both the
slides
from the main book (Silberschatz et al.) and the
lab material
. As DBMS we will use
PostgreSQL
.