Introduction to Databases *
Back
Course informations
| Study program level |
Undergraduate |
| Study program |
Management |
| Study program direction |
Informatics management |
| Course year |
3. |
| Course semester |
V |
| Course status |
Core |
| ECTS |
5 |
| Lectures (h) |
30 |
| Excercises (h) |
30 |
| Seminars (h) |
- |
Course objectives
Since students will, no matter what, have access to databases in their future employment, it is necessary to ensure that they know how to properly define the basics of databases. Part of the students will work on the level of administration and maintenance of the database, while the other part will create new databases, models and relationships. In this case it is necessary to obtain the basics of the databases. Student should be able to:
- Develop and understand a simpler conceptual or logical model of data
- Define core SQL command statements and solve simpler program tasks in SQL language,
- Independently use Microsoft Access, MySQL, MSSQL server and Firebird,
- Understand what ODBC is and can use it practically
Course outcomes
- Define basic terms and concepts of relational database theory
- Apply the learned theoretical basis and create a database in more specific DBMS systems
- Using theoretical principles, create / comment on the database schema, and simpler SQL procedures / triggers
- Create simple SQL DDL and DML commands
- Create and apply ODBC interface to databases
Course content
Introduction to the course and database. Database concept, database content - data and metadata. Model data, semantics, ANSI / SPARC architecture. Data abstractions. Conceptual modeling - ER-model. Relational model data - introduction, structure, integrity. Operations in Relational data model. Logical Data Model - Normalization, IDEF1X. SQL concept, standard, development. SQL DDL. SQL DML. Advanced use of SQL. Transactions, procedures, functions, triggers. Security and protection - authorization, privileges. Views - types, purpose. Faithfulness of DBMS with RMP and Codd rules. Distributed bases. Advanced concepts and application of databases. Unselected Databases (MONGODB).
