Introduction to Databases (3 cr)
Code: KTPT019-3009
General information
- Enrollment
-
01.01.2021 - 30.04.2021
Registration for the implementation has ended.
- Timing
-
22.03.2021 - 25.05.2021
Implementation has ended.
- Number of ECTS credits allocated
- 3 cr
- Local portion
- 3 cr
- Mode of delivery
- Contact learning
- Unit
- Teknologia
- Teaching languages
- Finnish
- Degree programmes
- Bachelor’s Degree in Business Information Technology
Evaluation scale
0 - 5
Content scheduling
Teoriatiedot luennoilla Moodlen mukaan, harjoitustöitä kurssin aikana.
Objective
Students will know the principles of relational databases, being able to plan and create a simple database, use relational database software and the ready database using query language.
Content
The basic concepts of databases
ER modelling
Normalisation
Basic Functions of SQL
Location and time
2020-2021 jakso 4, maanantaisin klo 12.30-16.00
Materials
Moodle-materiaali
Teaching methods
Opetustunnit, harjoitustyöt
Exam schedules
Hajoitustyön palautuksen takaraja 17.5.2021. Tentti 17.5.2021 klo 12.30 alkaen.
Completion alternatives
Itsenäinen suoritus
Student workload
Opiskelija käyttää aikaa opiskeluun noin 80 h.
Assessment criteria, satisfactory (1)
The students know how to define a relational database ans can name entities, attributes and concepts from an ER diagram. They are able to draw a simple ER model from a given target and to define tables from the diagram. The students know how to give examples of the keys of the tables and reference keys. The students know how to write simple sql statements and can form a simple a database under supervision using database management software.
Assessment criteria, good (3)
The students are able to explain the structure, keys and reference keys of a relational database and can draw an ER diagram of a given target and define the database's tables, their attributes and keys from the diagram. The students are able to explain the meaning of normalization and can initially normalize a database into a third normalized form. They are able to search for information from a given database using sql statements with different terms and to update the database using sql statements. They know how to form a simple database using database management software.
Assessment criteria, excellent (5)
The students are able to plan and build a third normalized relational database from a given target and can follow theoretical rules given during their work. They are able to carry out demanding searches within the database using sql statements. They are proficient in updating the database using sql statements.