Databases (5 cr)
Code: 5051271-3004
General information
Enrollment
01.12.2020 - 22.01.2021
Timing
11.01.2021 - 30.04.2021
Number of ECTS credits allocated
5 op
Mode of delivery
Contact teaching
Unit
Engineering and Business
Campus
Kupittaa Campus
Teaching languages
- English
Degree programmes
- Degree Programme in Information and Communication Technology
- Degree Programme in Information and Communications Technology
Teachers
- Kimmo Tarkkanen
- Balsam Abdulghani
Teacher in charge
Kimmo Tarkkanen
Groups
-
PTIVIS19PGame and Interactive Technologies
Objective
After completing the course the student can:
- understand different types of databases and evaluate their feasibility for different purposes.
- plan and implement a database based on requirements and search and modify data in the database
- use at least one well-known database management system
- describe database management tasks
Content
- Different types of databases
- Definition, planning and implementation of databases
- SQL basics
- Database administration with DBMS
- Management principles for databases
Materials
Lecture slides
Supporting material:
Connolly, Thomas M.; Begg, Carolyn E. - Database Systems: A Practical Approach to Design, Implementation and Management - 4. edition or later
Vaish, Gaurav: Getting Started with NoSQL. Packt Publishing Ltd 2013. Check Ebrary for online version
Teaching methods
The course consists of exercises, which are mainly SQL queries. Exercises are divided into weekly topics. These are practiced both individually and with the teacher help in the teaching session. Each session begins with an introduction to the topic of the week, which includes practical examples with lecture slides.
In addition, students design a small database in a group of two students.
Exam schedules
The exam is performed in Ville system.
1st exam is organized in the class room (during the regular meeting time) where Internet use is allowed for information retrieval. 2nd and 3rd exams as e-exams in the aquarium premises where Internet use is not allowed. E-exams are open the rest of the year.
International connections
Learning by doing, trial-error, listening and collaborating with peers.
Completion alternatives
Participation in the teaching session is not compulsory, but highly recommended, especially if you are new to databases.
Student workload
Participating weekly in teaching sessions: a' 3 hours * 12 = 36h
Individual work for exercises 80h
Exam 20h OR practical work 20h
Content scheduling
In this course, students learn to use and design relational and document databases.
Weekly meetings as online teaching sessions between weeks 2-16. Sessions are organized in Teams or in Zoom.
Topics in general:
- DBMS and DB use 2h
- Basics of SQL 12h
- Database design with ER 4h
- Database design with normalization 2h
- Introduction to document database MongoDB 4h
Further information
We will use a DBMS environment for practical training (probably MySQL / MariaDB), which needs installation on the personal computer. You can install the software (e.g. Uwamp) also on a USB memory stick (to allow the mobility between the school and home), and/or on the personal profile in TUAS domain (usable in computer class rooms).
Highly likely, the environment for using DBMS is some LAMP stack with graphical UI like UwAmp, but you can use similar like XAMPP.
In addition to DBMS environment, we will use MongoDB or similar online tool for practicing document databases.
Evaluation scale
H-5
Assessment methods and criteria
KURSSIN ARVIOINTIPERUSTEET TARKENTUVAT MYÖHEMMIN
Kurssi arvioidaan 0-5 ja se perustuu pisteisiin. Jokainen hyväksytysti palautettu tehtävä on yhden pisteen arvoinen.
luokkatehtävät XX pistettä
kotitehtävät XX p (tehtävät auki kurssin loppuun asti)
käytännön työ XX p
tentti XX p (tehdään e-tenttinä Villessä ja on auki vuoden loppuun asti)
yhteensä XXX pistettä (maksimipistemäärä tarkentuu ja ilmoitetaan kurssin alussa).
Grading by points:
0-49% of maximum = FAIL
50-59% = 1
60-69% = 2
70-79% = 3
80-89% = 4
90-100% = 5