Databases

obligatory courses

Classroom

During the course, students will be introduced to the construction, functioning and range of applications of databases. The issues of designing, building and using a database will be introduced. Students will also be introduced to the SQL database programming language and the XML structure description language. As a enchancement, issues related to data warehousing and the tools available for their use in management will be discussed.

1. Introduction to databases - scope and specificity of database applications

2. Types of databases and database models

3. Creating tables and defining relationships,

4. Data modeling - entity relationship model.

̶ Transformation from conceptual model to relational model.

̶ Normalization of the relational database schema

5. Basics of SQL language

̶ Introduction and syntax of the language - range of applications

̶ Selected SQL language functions (e.g. numeric, character, conditional)

̶ Queries directed to the database - SELECT statement

6. Relational database management systems on the example of MySQL

7. The use of XML as a tool for describing data structure

8. Selected aspects of database security

9. Data warehouse - definitions range of applications

̶ Basics of data warehouse design - conceptual, logical and physical model

̶ Data warehouse as an element of Business Intelligence Systems

̶ Basic OLAP analytical tools

̶ Multidimensional data model and data mining mechanisms (data minning)

10. Database systems as an element of Management Information Systems

11. Construction and use of a simple database on the example of the presentation of the capabilities of MS Acceess 2019 software

Basic literature :

1. Chodkowska-Gyurics A., Hurtownie danych. Teoria i praktyka, Helion 2022

2. Hernandez J., Projektowanie baz danych dla każdego. Przewodnik krok po kroku, Helion 2022

3. Elmasri R., Navathe S., Wprowadzenie do systemów baz danych, Helion, 2019

4. Rockoff L., Język SQL. Przyjazny podręcznik. Wydanie III (ebook), Helion, 2022

5. Ullman J.D., Windom J., Podstawowy kurs systemów baz danych, Helion, Warszawa wa, 2011

Additional literature :

6. Alexander M., Kusleika R., Access 2019 PL. Biblia. Helion, 2023

7. Banaszak Z., Kłos S., Mleczko J., Zintegrowane systemy zarządzania, PWE, 2016

8. Kisielnicki J., MIS systemy informatyczne zarządzania, Placet, Warszawa 2008

9. Surma J., Business Inteligence, PWN, 2021

Student/Student upon completion of the course:

In terms of knowledge:

• Knows and understands the specifics, principles, procedures and practices of e-business, its key functions (operational, marketing, financial, personnel management) and its relations with the environment (S3 _W02),

• Knows and understands technological, social, political, legal, economic and ecological processes and phenomena and their impact on the operation in e-business and digital economy (S3_W05).

In terms of skills :

• Is able to use the theory of the discipline of management and quality sciences and complementary sciences (economics and finance, legal sciences) to identify, diagnose and solve problems related to key functions in e-business and integrate them into a strategy, using an appropriate selection of sources and adapting existing methods (S3_U01)

• Is able to independently and collaboratively prepare analyses, diagnoses and reports on the functioning of e-business and the digital economy and present them communicatively, including in English-using information and communication tools (S3_U03)

• Has the ability to self-educate and improve acquired skills. (S3-U06)

In terms of social competence :

• He is ready to evaluate and critically approach situations and phenomena related to the functioning of e-business and digital economy (S3_K01).

Learning outcomes will be verified in the form of a test conducted during the last class in the lecture hall.

The test will be conducted stationary using the e-learning platform. In justified cases, a traditional paper version of the test will also be possible.

A total of 20 points will be available during the test, the number of which will determine the final grade:

0-10 points - grade 2

11-12 points - grade 3

13-14 points - grade 3.5

15-16 points - grade 4

17-18 points - grade 4.5

19-20 points - grade 5