Database Design I
5 credits
Syllabus, Bachelor's level, 1DL300
This course has been discontinued.
A revised version of the syllabus is available.
- Code
- 1DL300
- Education cycle
- First cycle
- Main field(s) of study and in-depth level
- Computer Science G1F, Computer Science G1F, Sociotechnical Systems G1F, Sociotechnical Systems G1F, Technology G1F, Technology G1F
- Grading system
- Fail (U), Pass (3), Pass with credit (4), Pass with distinction (5)
- Finalised by
- The Faculty Board of Science and Technology, 16 March 2009
- Responsible department
- Department of Information Technology
Entry requirements
Mathematics 15 credits and Computer Science 20 credits including basic programming, and algebra.
Learning outcomes
For a pass mark, the student must be able to
- design and use relational databases in both theory and practical application, and
- explain basic differences between database design and conventional programming.
Content
The course contains
- an introduction to the database area and database terminology,
- entitets-relations (ER) modelling and expanded entitets-relations (EER) modelling,
- an overview of the relational data model and relational algebra and transformation of the data representation from the ER data model to the relational data model,
- an introduction to physical database design with functional dependencies and normalisation,
- an introduction to queries, updates and data definition with help of the query language SQL,
- an introduction to transactions, basic techniques for transaction management and concurrency control and recovery,
- an introduction to physical database design with file organisation, single level index and tree index,
- an introduction to procedural SQL and the application interface, and
- an orientation in advanced database applications and -techniques.
Instruction
Lectures, problem solving sessions, laboratory work and assignments. Also seminars and guest lectures can occur.
Assessment
Written examination (3 credits) and assignments (2 credits).
When the course is given in a course block with Database Design II both courses are examined together.
Other directives
Courses can occur where Database Design I and Database Design II are given integrated in a course block.