Syllabus academic year 2010/2011
(Created 2010-07-25.)
Credits: 7,5.
Grading scale: UG.
Cycle: G2
(First Cycle).
Main field: Technology.
Language of instruction: The course will be given in Swedish.
EDA636 overlaps following cours/es: EDA215 and EDA216.
Compulsory for: IDA2.
Course coordinator: Flavius Gruian, Flavius.Gruian@cs.lth.se, Dept of Computer Science.
Prerequisites: A first course in programming.
Assessment: For a passing grade the laboratory exercises and the assigment must be completed.
Further information: Compulsory course items: laboratory exercises and an assignment.
Home page: http://cs.lth.se/eda636.
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 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.