DATABASES - APPLICATIONS OF SQL 2400-ZEWW669
- Databases. Database management systems in an economic organization. Database - basic concepts. Evolution of database systems.
- Operational and analytical use of databases. The architecture of a database management system (DBMS) - diagrams. Organization of equipment and users.
- Information systems based on databases and their evolution. Models - definition and types, database properties.
-Issues related to database: indirection (mapping), data collection, data types, constants, variables, functions, conditions, selection, projection, combining, organizing, sharing.
- Logical database models: hierarchical, network, relational, object. Diagrams of entity relationship models (entities, attributes, relationships), the relationships' properties. Database development trends.
- Database design process. Defining relationship characteristics. Entity relationship model. Implementation models. Basic actions in relational algebra. Relational model. Normalization of relational data model.
- Defining a relational database schema, relationships and prospects.
- Updating operations.
- SQL queries: simple, with nested units, with connectors.
- Physical database organization.
- Addressing, searching, indexing. Management of transactions and queries. Data security. Database design process: modeling.
Type of course
Course coordinators
Learning outcomes
After the course the student is able to:
- present knowledge of database management,
- describe the analytical and operational models of databases,
- create, modify and manage databases using SQL language,
- analyze patterns of relational databases,
- create and modify the structure of queries to database,
- integrate queries into coherent analytical queries,
- assess the correctness of the queries in SQL (Structured Query Language),
- interpret the databases queries.
Assessment criteria
Assessment is based on two tests:
the first one - preliminary, for which one can get 20% points of the final evaluation grade, it will take place in the middle of the term,
the second one - final, for which one can get 80% points of the final evaluation grade, it will take place during lasr classes.
Tests will take place at the computers and will prove the knowledge of problems and issues discussed and addressed during the classes.
Bibliography
- P.Beynon_Davies, "Systemy baz danych", Wydawnictwo Naukowo-Techniczne, Warszawa, 2003
- Richard Stones, Neil Matthew, Bazy Danych i MySQL, Helion, Gliwice 2003
- Microsoft SQL Server 2005 od środka: Mechanizm składowania danych, APN Promise, Warszawa 2007
- Microsoft SQL Server 2005 od środka: Zapytania w języku T-SQL, APN Promise, Warszawa 2006 Ewa Łuszczyk, Mirosława Koperkowska, Ćwiczenia z Access 2003 - wersja polska, wyd. Mikom, Warszawa 2004
- Ben Forta, Poznaj SQL w 10 minut, Intersoftland, Warszawa 2000
- Adam Majczak, SQL od podstaw, wyd. I, Translator s.c., Warszawa 2001
- Stones Richard, Matthew Neil, Bazy danych i MySQL, Helion, Gliwice 2003
- Prague, Cary N., Access 2003 PL: biblia, Helion, Gliwice 2004
Additional information
Additional information (registration calendar, class conductors, localization and schedules of classes), might be available in the USOSweb system: