Syllabus 2011/2012 EDAF20

Syllabus academic year 2011/2012
(Created 2011-09-01.)

DATABASE TECHNOLOGY

EDAF20

Credits: 7,5. Grading scale: TH. Cycle: G2 (First Cycle). Main field: Technology. Language of instruction: The course might be given in English. EDAF20 overlaps following cours/es: EDA215, EDA216 and EDA636. Compulsory for: IDA2, IEA2. Course coordinator: Computer Science. Prerequisites: EDAA10 Programming i Java. Assessment: Written examination. For a passing grade the laboratory exercises and the project must also be completed. The final grade of the course is based on the result of the written examination, which takes place after the first study period of the course. Parts: 2. Further information: Compulsory course items: laboratory exercises and a project. Home page: http://cs.lth.se/utbildning.

Aim
The course gives basic theoretical and practical knowledge about database systems and their organization. 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 normalize 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 organize 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 management systems. The basics of the relational model, the query language SQL. Methods for data modelling and database design, E/R and UML diagrams. Theory of relational databases: functional dependencies, normalization, relational algebra. Programmable SQL, 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. An orientation about implementation of database managers and of query languages.

Literature
Thomas Padron-McCarthy, Tore Risch: Databasteknik. Studentlitteratur 2005. ISBN: 9789144044491.
or
Ullman Jeffrey and Widom Jennifer: A First Course in Database Systems. 3rd Ed. Pearson 2008. ISBN: 978-0-13-600637-4.

Parts

Code: 0112. Name: Laboratory Work and Project.
Higher education credits: 3. Grading scale: UG. Assessment: For a passing grade the laboratory work and the assignment must have been completed. Contents: Compulsory laboratory work and a compulsory assignment.

Code: 0212. Name: Written Examination.
Higher education credits: 4,5. Grading scale: TH. Assessment: Written examination. The final grade of the course is based on the result of this exam. Further information: The first written examination takes place after the first study period of the course.