Database TechnologyLaajuus (3 cr)
Code: IT23YS02
Credits
3 op
Objective
The student:
- knows basic data storage techniques
- understands the relational model and can normalize simple databases.
- masters the use of database management systems both through graphical user interfaces and with a command language.
Content
Introduction to databases.
Concepts and properties.
Database Management Systems.
Relational Theory and Normalization
SQL.
Qualifications
No prerequisites
Assessment criteria, satisfactory (1)
The student knows the history and current state of data storage. The student knows about different types of data warehouses.
The student knows the basic concept of relational theory and how a simpler relational database is constructed.
The student understands why a database in higher normal form is better than a database in lower normal form.
The student can explain the different normal forms,
The student knows and can use simple database commands.
The student can use the graphical user interface of a database management system.
Assessment criteria, good (3)
The student can explain the benefits of relational databases and the structure of the database systems.
The student can use the basic concept of relational theory and describe the structure of a relational database.
The student can normalize a database to 3NF. The student can determine the normal form of a database.
The student knows and can use more advanced database commands.
The student can use a report generator to compose reports from databases.
Assessment criteria, excellent (5)
The student can compare different data storage techniques with each other.
The student understands the mathematical model on which the relational databases are based.
The student can normalize a more extensive database to 3NF.
The student can independently acquire knowledge of database commands and practically apply this knowledge.
The student can, with graphic tools, create user interfaces for reading and writing databases.
Materials
Material on Moodle.
Additional reading: Ritchie: Database Principles and design.
Enrollment
15.06.2024 - 22.09.2024
Timing
02.09.2024 - 27.10.2024
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Unit
Faculty of Technology and Seafaring
Campus
Vasa, Wolffskavägen 33
Teaching languages
- English
Degree programmes
- Degree Programme in Information Technology
- Degree Programme in Information Technology
Teachers
- Susanne Österholm
Teacher in charge
Kaj Wikman
Groups
-
ITE24D-VInformation Technology, day time studies 2024, Vasa
Objective
The student:
- knows basic data storage techniques
- understands the relational model and can normalize simple databases.
- masters the use of database management systems both through graphical user interfaces and with a command language.
Content
Introduction to databases.
Concepts and properties.
Database Management Systems.
Relational Theory and Normalization
SQL.
Location and time
autumn 2024, Vaasa
Materials
material on Moodle
Teaching methods
lectures, computer exercises
Exam schedules
examination and handed in exercises: october 2024
retake1: november/december 2024
retake 2: sprint 2025
Completion alternatives
examination
Student workload
classroom studies ca 35 h
own work ca 45 h
Evaluation scale
H-5
Assessment criteria, satisfactory (1)
The student knows the history and current state of data storage. The student knows about different types of data warehouses.
The student knows the basic concept of relational theory and how a simpler relational database is constructed.
The student understands why a database in higher normal form is better than a database in lower normal form.
The student can explain the different normal forms,
The student knows and can use simple database commands.
The student can use the graphical user interface of a database management system.
Assessment criteria, good (3)
The student can explain the benefits of relational databases and the structure of the database systems.
The student can use the basic concept of relational theory and describe the structure of a relational database.
The student can normalize a database to 3NF. The student can determine the normal form of a database.
The student knows and can use more advanced database commands.
The student can use a report generator to compose reports from databases.
Assessment criteria, excellent (5)
The student can compare different data storage techniques with each other.
The student understands the mathematical model on which the relational databases are based.
The student can normalize a more extensive database to 3NF.
The student can independently acquire knowledge of database commands and practically apply this knowledge.
The student can, with graphic tools, create user interfaces for reading and writing databases.
Assessment methods and criteria
passed examination
approved exercises
Assessment criteria, fail (0)
Student's knowledge does not reach the level of a satisfactory white word.
Assessment criteria, satisfactory (1-2)
The student knows different types of data storage.
The student knows how a small relational database is structured.
The student understands why a database in higher normal form is better than a database in lower normal form.
The student can explain the different normal forms.
The student knows and can use elementary database commands.
The student can use a database management system's graphical user interface.
Assessment criteria, good (3-4)
The student can explain the advantages of relational databases and the structure of database systems.
The student can use the basic concepts of relational theory to describe a relational database.
The student can normalize a database to 3NF. The student can determine the normal form of a database.
The student knows and can use more advanced database commands.
The student can use a database management system's graphical user interface.
Assessment criteria, excellent (5)
The student can compare different techniques for data storage with each other.
The student can use the basic concepts of relational theory to describe a relational database.
The student can normalize a more extensive database to 3NF.
The student can independently acquire knowledge of database commands and practically apply this knowledge.
The student can make versatile use of a database management system's graphical user interface.
Qualifications
No prerequisites
Enrollment
15.06.2023 - 03.09.2023
Timing
28.08.2023 - 15.10.2023
Number of ECTS credits allocated
3 op
Mode of delivery
Contact teaching
Unit
Faculty of Technology and Seafaring
Campus
Vasa, Wolffskavägen 33
Teaching languages
- English
Degree programmes
- Degree Programme in Information Technology
- Degree Programme in Information Technology
Teachers
- Susanne Österholm
Teacher in charge
Kaj Wikman
Groups
-
ITE23D-VInformation Technology, full time studies 2023, Vasa
Objective
The student:
- knows basic data storage techniques
- understands the relational model and can normalize simple databases.
- masters the use of database management systems both through graphical user interfaces and with a command language.
Content
Introduction to databases.
Concepts and properties.
Database Management Systems.
Relational Theory and Normalization
SQL.
Location and time
autumn 2023, Vaasa
Materials
material on Moodle
Teaching methods
lectures, computer exercises
Exam schedules
examination and handed in exercises: october 2023
retake1: november/december 2023
retake 2: sprint 2024
Completion alternatives
examination
Student workload
classroom studies ca 35 h
own work ca 45 h
Evaluation scale
H-5
Assessment criteria, satisfactory (1)
The student knows the history and current state of data storage. The student knows about different types of data warehouses.
The student knows the basic concept of relational theory and how a simpler relational database is constructed.
The student understands why a database in higher normal form is better than a database in lower normal form.
The student can explain the different normal forms,
The student knows and can use simple database commands.
The student can use the graphical user interface of a database management system.
Assessment criteria, good (3)
The student can explain the benefits of relational databases and the structure of the database systems.
The student can use the basic concept of relational theory and describe the structure of a relational database.
The student can normalize a database to 3NF. The student can determine the normal form of a database.
The student knows and can use more advanced database commands.
The student can use a report generator to compose reports from databases.
Assessment criteria, excellent (5)
The student can compare different data storage techniques with each other.
The student understands the mathematical model on which the relational databases are based.
The student can normalize a more extensive database to 3NF.
The student can independently acquire knowledge of database commands and practically apply this knowledge.
The student can, with graphic tools, create user interfaces for reading and writing databases.
Assessment methods and criteria
passed examination
approved exercises
Assessment criteria, fail (0)
Student's knowledge does not reach the level of a satisfactory white word.
Assessment criteria, satisfactory (1-2)
The student knows different types of data storage.
The student knows how a small relational database is structured.
The student understands why a database in higher normal form is better than a database in lower normal form.
The student can explain the different normal forms.
The student knows and can use elementary database commands.
The student can use a database management system's graphical user interface.
Assessment criteria, good (3-4)
The student can explain the advantages of relational databases and the structure of database systems.
The student can use the basic concepts of relational theory to describe a relational database.
The student can normalize a database to 3NF. The student can determine the normal form of a database.
The student knows and can use more advanced database commands.
The student can use a database management system's graphical user interface.
Assessment criteria, excellent (5)
The student can compare different techniques for data storage with each other.
The student can use the basic concepts of relational theory to describe a relational database.
The student can normalize a more extensive database to 3NF.
The student can independently acquire knowledge of database commands and practically apply this knowledge.
The student can make versatile use of a database management system's graphical user interface.
Qualifications
No prerequisites