Syllabus for Database Design II
- 5 credits
- Course code: 1DL400
- Education cycle: Second cycle
Main field(s) of study and in-depth level:
Computer Science A1N,
- Grading system: Fail (U), Pass (3), Pass with credit (4), Pass with distinction (5)
- Established: 2007-03-15
- Established by:
- Revised: 2022-10-23
- Revised by: The Faculty Board of Science and Technology
- Applies from: Autumn 2023
120 credits of which 15 credits in mathematics and 30 credits in computer science or information systems, including a second course in computer programming. Participation in Database Design I or some other first course in databases. Participation in Algorithms and Data Structures I. Proficiency in English equivalent to the Swedish upper secondary course English 6.
- Responsible department: Department of Information Technology
On completion of the course, the student should be able to use design, techniques and representation methods that are used in modern database management systems for advanced applications.
The course contains a deeper treatment of the database area that comprises
- introduction to safety and access control,
- mechanisms for data integrity,
- an overview of advanced design of database systems with procedural SQL and application interfaces,
- functions of active databases with database rules or triggers,
- an overview of the functions of object-oriented and object relational databases,
- query processing of database queries including relational algebra, relational calculus and query optimisation
- the structure and the functions of a data warehouse
- handling of non-conventional data within multimedia and spatial databases,
- the structure and the functions of distributed database systems,
- handling of distributed databases,
- the tuning of database parameters, and
- an overview of requirements from, and design of, advanced database applications.
Lectures, problem solving sessions, laboratory work and assignments. Also seminars and guest lectures can occur.
Written examination (3 credits) and assignments (2 credits).
If there are special reasons for doing so, an examiner may make an exception from the method of assessment indicated and allow a student to be assessed by another method. An example of special reasons might be a certificate regarding special pedagogical support from the disability coordinator of the university.
- Latest syllabus (applies from Autumn 2023)
- Previous syllabus (applies from Spring 2019, version 2)
- Previous syllabus (applies from Spring 2019, version 1)
- Previous syllabus (applies from Autumn 2012)
- Previous syllabus (applies from Autumn 2011)
- Previous syllabus (applies from Autumn 2009)
- Previous syllabus (applies from Autumn 2007, version 2)
- Previous syllabus (applies from Autumn 2007, version 1)
Applies from: Autumn 2023
Some titles may be available electronically through the University library.
Lund: Studentlitteratur, 2005
Fundamentals of database systems
6. ed.: Upper Saddle River, N.J.: Pearson Education, 2010