Summer Semester 2009/10
Summer Semester 2010/11
Summer Semester 2011/12
Databases MARN02009A
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.
Language SQL.
Transaction.
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 2007 database application, using language SQL for data manipulating and creating simple MS SQL Server 2005 databases.
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) Lambert Steve, Lambert Dow, Preppernau Joan,
Microsoft Office Access 2007 Step by step
b) supplementary references: