Design and creation of databases Field of study: Information Architecture
Programme code: W1-S1AI19.2023

Module name: Design and creation of databases
Module code: W1-AI-S1-PTBD04
Programme code: W1-S1AI19.2023
Semester:
  • summer semester 2025/2026
  • summer semester 2024/2025
Language of instruction: Polish
Form of verification: course work
ECTS credits: 2
Purpose and description of the content of education:
In this course, students learn the principles of designing and creating databases using the MySQL system, as well as the basics of building dynamic websites using database access. They acquire skills related to the creation of tables and relations in a database, create queries in SQL language, import and export data. They manage files in their web account, use the PHP language to generate web page elements, and connect to and communicate with the database from the website.
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 knows the application of databases and terminology related to their creation, as well as has knowledge about the principles of designing relational databases. [PTBD04​_1]
 K_W02 [4/5]
The student can design and create databases using the MySQL system, as well as build dynamic websites that access the database. [PTBD04​_2]
 K_U05 [4/5]
The student is prepared to use the acquired skills to improve information activities in professional work by creating basic database systems with user-friendly interfaces that limit the possibility of making mistakes when entering data into the database. [PTBD04​_3]
 K_K02 [3/5]
Form of teaching Number of hours Methods of conducting classes Assessment of the learning outcomes Learning outcomes
laboratory classes [PTBD04_fs_1] 30 Demonstration-imitation [c06] 
Working with a computer [d01] 
Project scheduling [e04]  		course work PTBD04​_1 PTBD04​_2 PTBD04​_3
The student's work, apart from participation in classes, includes in particular:
Name Category Description
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)
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
Analysis of the corrective feedback provided by the academic teacher on the results of the verification of learning outcomes [d01] Consulting the results of the verification of learning outcomes
reading through the academic teacher’s comments, assessments and opinions on the implementation of the task aimed at checking the level of the achieved learning outcomes
Development of a corrective action plan as well as supplementary/corrective tasks [d02] Consulting the results of the verification of learning outcomes
reviewing and selecting tasks and activities enabling the elimination of errors indicated by the academic teacher, their verification or correction resulting in completing the task with at least the minimum passing grade
Attachments
Module description (PDF)
Information concerning module syllabuses might be changed during studies.
Syllabuses (USOSweb)
Semester Module Language of instruction
(no information given)