Database Design I

5 credits

Syllabus, Bachelor's level, 1DL301

A revised version of the syllabus is available.
Code
1DL301
Education cycle
First cycle
Main field(s) of study and in-depth level
Computer Science G2F, Sociotechnical Systems G2F, Technology G2F
Grading system
Pass with distinction (5), Pass with credit (4), Pass (3), Fail (U)
Finalised by
The Faculty Board of Science and Technology, 12 March 2015
Responsible department
Department of Information Technology

Entry requirements

60 credits of which at least 15 credits in mathematics and 15 credits in computer science 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. Seminars and guest lectures may occur.

Assessment

Written examination (3 credits) and oral and written assignments (2 credits).

FOLLOW UPPSALA UNIVERSITY ON

facebook
instagram
twitter
youtube
linkedin