Database Design I
5 credits
Syllabus, Bachelor's level, 1DL300
This course has been discontinued.
- Code
- 1DL300
- Education cycle
- First cycle
- Main field(s) of study and in-depth level
- Computer Science G1F, Sociotechnical Systems 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, 15 June 2012
- Responsible department
- Department of Information Technology
Entry requirements
Mathematics 15 credits and Computer Science 15 credits including basic programming.
Learning outcomes
For a pass mark, the student must be able to
- design and use relational databases in both theory and practical application.
- explain basic differences between database design and conventional programming.
- present and discuss the course content orally and in writing with proficiency appropriate to the course level.
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).