Winter Semester 2010/11
Winter Semester 2011/12
Winter Semester 2012/13
Databases METS03023A
Course content:
Lecture
An introduction to database theory and relational database management systems.
Database analysis and entity relationship (ER) modelling.
Mapping ER models into relations. Normalisation techniques for relations. SQL.Transactions. Metadata. Security of the database.
Project
MS Access 2007 database creating. Database objects: tables, forms, raports, macros, queries (select queries, aggrigate query, make table queries, append queries, update queries, delete queries, parameter queries, cross queries).
Table relationships.
Building SQL queries.
MS Access 2007 integration with SQL Server .
Learning outcomes:
Knowledge about relational database design.
Practical skills in operating MS Access 2010 database application, using language SQL for data manipulating and creating simple MS SQL Server databases.
(in Polish) Rodzaj przedmiotu
Course coordinators
Bibliography
a) basic references:
1. Ullman J.D., Widom. J.W.(2008) A first course in database systems, Pearson Prentice Hall,
2) Elmasri Ramez A., Shamkant B. Navathe (2003) Fundamentals of Database Systems, Pearson Addison Wesley
3) Beighley, Lynn. Head first SQL (2007), O'Reilly Media
4) Michael R. Groch (2010) Access 2010 Bible.