ITKA204 Databases and Basics of Data Control (5 cr)
Basically every information system uses at least one database. The course topics on databases, data management and database management systems are addressed through different data models, especially ER-model and relational model. During the course the students will learn practical skills: database requirements analysis, design through normalization theory and development through SQL. The course also addresses the business aspects related to databases through data warehousing and examines the software architecture behind a database management system. Modern database techniques such as database distribution and 2010s data models are also discussed.
In addition to the final exam, the course consists of weekly lectures and demonstrations.
The amount of work is 133 hours:
- Lectures 34h
- Demonstrations 54h
- Preparing for and taking the exam 45h
Exam.The student possesses sufficient (1), satisfactory (2), good (3), very good (4) or excellent (5) knowledge on subjects stated in the course learning outcomes and has demonstrated this knowledge in the exam. Otherwise the student has failed the course.
Description of prerequisites
- Elmasri R. & Navathe S. Fundamentals of Database Systems, Addison-Wesley.
- McCreary, D. & Kelly, A. Making Sense of NoSQL, Manning.