Syllabus for Database Design II
A revised version of the syllabus is available.
- 5 credits
- Course code: 1DL400
- Education cycle: Second cycle
Main field(s) of study and in-depth level:
Computer Science A1N,
Explanation of codes
The code indicates the education cycle and in-depth level of the course in relation to other courses within the same main field of study according to the requirements for general degrees:
- G1N: has only upper-secondary level entry requirements
- G1F: has less than 60 credits in first-cycle course/s as entry requirements
- G1E: contains specially designed degree project for Higher Education Diploma
- G2F: has at least 60 credits in first-cycle course/s as entry requirements
- G2E: has at least 60 credits in first-cycle course/s as entry requirements, contains degree project for Bachelor of Arts/Bachelor of Science
- GXX: in-depth level of the course cannot be classified
- A1N: has only first-cycle course/s as entry requirements
- A1F: has second-cycle course/s as entry requirements
- A1E: contains degree project for Master of Arts/Master of Science (60 credits)
- A2E: contains degree project for Master of Arts/Master of Science (120 credits)
- AXX: in-depth level of the course cannot be classified
- Grading system: Fail (U), Pass (3), Pass with credit (4), Pass with distinction (5)
- Established: 2007-03-15
- Established by: The Faculty Board of Science and Technology
- Revised: 2010-10-27
- Revised by: The Faculty Board of Science and Technology
- Applies from: Autumn 2011
120 credits of which 15 credits in mathematics and 40 in computer science or systems science, including a second course in Computer Programming, Algorithms and data structures and a first course in Databases.
- Responsible department: Department of Information Technology
To pass the student must 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 XML-based data,
- 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).
When the course is given in a course block with Database Design I both courses are examined together.
Courses can occur where Database Design I and Database Design II are given integrated in a course block.
- 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: Spring 2011
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
Reading list revisions
- Latest reading list (applies from Spring 2011, version 2)
- Previous reading list (applies from Spring 2011, version 1)