Databases 1 Field of study: Computer Science
Programme code: W4-N1IN19.2024

Module name: Databases 1
Module code: W4-IN-N1-24-2-BD1
Programme code: W4-N1IN19.2024
Semester: summer semester 2024/2025
Language of instruction: Polish
Form of verification: exam
ECTS credits: 3
Purpose and description of the content of education:
Databases 1 introduces students to the fundamental principles of designing, creating, and managing relational databases. Students will acquire the knowledge and skills necessary for effectively storing, retrieving, and manipulating data using SQL, and will learn to design data structures in accordance with normalization principles.
List of modules that must be completed before starting this module (if necessary): not applicable
Learning outcome of the module Codes of the learning outcomes of the programme to which the learning outcome of the module is related [level of competence: scale 1-5]
The student understands the need for continuously enhancing their knowledge and developing their skills in working with modeling tools and database management systems. [K01]
 IN_K04 [3/5]
The student is aware of the role of database systems in social and economic transformations. [K02]
 IN_K02 [3/5] IN_K04 [2/5]
The student is able to identify the potential applications of database systems in areas of computer science related to software development. [K03]
 IN_K02 [2/5] IN_K03 [3/5]
The student has the ability to analyze a problem in terms of designing a database structure. [U01]
 IN_U02 [2/5] IN_U03 [3/5] IN_U05 [3/5]
The student is able to design and implement a data model for a given problem. They can identify alternative solutions and determine the characteristics of each solution. [U02]
 IN_U01 [2/5] IN_U02 [3/5] IN_U03 [3/5] IN_U06 [1/5]
The student is able to express database queries using SQL syntax. [U03]
 IN_U02 [3/5] IN_U04 [2/5] IN_U06 [2/5]
The student can transform a conceptual database model into an implementation model. [U04]
 IN_U01 [2/5] IN_U02 [2/5] IN_U06 [2/5]
The student knows and understands the basic concepts of relational databases, data dependencies, and the normalization process. [W01]
 IN_W01 [2/5] IN_W03 [1/5] IN_W04 [2/5]
The student knows the principles of creating a database model and implementing data structures for a given problem. [W02]
 IN_W04 [2/5] IN_W05 [3/5] IN_W06 [1/5]
The student knows the basics of SQL and understands the discrepancies in SQL query implementations. [W03]
 IN_W03 [3/5] IN_W04 [2/5]
The student knows the mechanism of a database management system and the properties of transactions. [W04]
 IN_W01 [1/5] IN_W05 [3/5] IN_W06 [3/5]
Form of teaching Number of hours Methods of conducting classes Assessment of the learning outcomes Learning outcomes
lecture [01] 10 Formal lecture/ course-related lecture [a01] 
Description [a03] 
Problem-based lecture [b01] 
Lecture-discussion [b02] 
Activating methods: a case study [b07] 
Demonstration-imitation [c06] 
Screen presentation [c07] 
Self-education [f01] 
Individual work with a text [f02]  		exam K01 K02 K03 W01 W02 W03 W04
laboratory classes [02] 20 Activating methods: a case study [b07] 
Activating method – peer learning [b08] 
Demonstration-imitation [c06] 
Screen presentation [c07] 
Working with a computer [d01] 
Laboratory exercise / experiment [e01] 
Project scheduling [e04] 
Self-education [f01] 
Conceptual work [f03]  		course work U01 U02 U03 U04 W01 W02
The student's work, apart from participation in classes, includes in particular:
Name Category Description
Search for materials and review activities necessary for class participation [a01] Preparation for classes
reviewing literature, documentation, tools and materials as well as the specifics of the syllabus and the range of activities indicated in it as required for full participation in classes
Literature reading / analysis of source materials [a02] Preparation for classes
reading the literature indicated in the syllabus; reviewing, organizing, analyzing and selecting source materials to be used in class
Developing practical skills [a03] Preparation for classes
activities involving the repetition, refinement and consolidation of practical skills, including those developed during previous classes or new skills necessary for the implementation of subsequent elements of the curriculum (as preparation for class participation)
Production/preparation of tools, materials or documentation necessary for class participation [a05] Preparation for classes
developing, preparing and assessing the usefulness of tools and materials (e.g. aids, scenarios, research tools, equipment, etc.) to be employed in class or as an aid when preparing for classes
Getting acquainted with the syllabus content [b01] Consulting the curriculum and the organization of classes
reading through the syllabus and getting acquainted with its content
Determining the stages of task implementation contributing to the verification of learning outcomes [c01] Preparation for verification of learning outcomes
devising a task implementation strategy embracing the division of content, the range of activities, implementation time and/or the method(s) of obtaining the necessary materials and tools, etc.
Studying the literature used in and the materials produced in class [c02] Preparation for verification of learning outcomes
exploring the studied content, inquiring, considering, assimilating, interpreting it, or organizing knowledge obtained from the literature, documentation, instructions, scenarios, etc., used in class as well as from the notes or other materials/artifacts made in class
Implementation of an individual or group assignment necessary for course/phase/examination completion [c03] Preparation for verification of learning outcomes
a set of activities aimed at performing an assigned task, to be executed out of class, as an obligatory phase/element of the verification of the learning outcomes assigned to the course
Attachments
Module description (PDF)
Information concerning module syllabuses might be changed during studies.
Syllabuses (USOSweb)
Semester Module Language of instruction
(no information given)