Syllabus 2010/2011 EDA216

Syllabus academic year 2010/2011
(Created 2010-07-25.)

DATABASE TECHNOLOGY

EDA216

Credits: 7,5. Grading scale: TH. Cycle: G2 (First Cycle). Main field: Technology. Language of instruction: The course will be given in Swedish. EDA216 overlaps following cours/es: EDA215, EDA636 and EXTN70. Compulsory for: C2. Optional for: D4, D4pv, E4, E4pv, F4, F4pv, I4, L4gi, Pi4, Pi4pv. Course coordinator: Per Holm, Per.Holm@cs.lth.se, Dept of Computer Science. Prerequisites: EDA027 Algorithms and Data Structures or EDAA01 Programming - Second Course. Assessment: Written examination. Compulsory course items: computer laboratory exercises, project. The final grade of the course is based on the result of the written examination. Parts: 2. Home page: http://cs.lth.se/eda216.

Aim
The course gives basic theoretical and practical knowledge about database systems and their organisation. The emphasis is on relational databases.

Knowledge and understanding
For a passing grade the student must

be able to describe information systems with E/R models and UML notation, and translate such models into relational form
be able to normalise database schemas
be able to use the query language SQL to create and update a database, and to retrieve information from the database
know about alternative ways to organise data in databases and about the design of database management systems

Skills and abilities
For a passing grade the student must

be able to use tools to implement a database
be able to develop program and web interfaces to databases

Contents

Introduction to database systems. Basics of the relational model, the query language SQL. Methods for data modelling and database design, E/R diagrams and UML diagrams. Theory for the relational model: functional dependencies, normalisation, relational algebra. Stored procedures, triggers. Program and web interfaces to databases.
Other data models: object-oriented databases, object-relational databases, semistructured data (XML).
Security and integrity in databases, concurrency, transactions. Implementation of database management systems and query languages.

Literature
Garcia-Molina, H & Ullman, J D & Widom, J: Database systems: The Complete Book, Second Ed. (International Edition), Prentice Hall 2009. ISBN: 0-13-135428-0. The first edition of this book can also be used.

Parts

Code: 0106. Name: Laboratory Work and Assignment.
Higher education credits: 3. Grading scale: UG. Assessment: To qualify for a passing grade the laboratory exercises and the assignment must be completed.

Code: 0206. Name: Written Examination.
Higher education credits: 4,5. Grading scale: TH. Assessment: Written examination. The final grade of the course is based on the examination.