Databases 1 | Faculty of Technical Sciences

Subject: Databases 1 (17.RI43A)

Native organizations units: Sub-department for Applied Computer Science and Informatics

Type of studies	Title
Undergraduate Academic Studies	Measurement-Information Technologies and Control Engineering (Year: 4, Semester: Winter)

General information:

Category	Professional-applicative
Scientific or art field	Applied Computer Science and Informatics
ECTS	8

Basic students education in databases. Students gain fundamental knowledge in databases and learn basic techniques of implementation, use and maintenance of databases.

Students acquire basic knowledge on ER and relational data models, the SQL language and file organization, which is further used in the practice and specialized courses in: Databases 2, Software Specification and Modeling, Information System Engineering, Business Informatics, and Database Systems.

Databases and their role in the development and exploitation of information systems. Basic notions and concepts in databases, Database management system. Data models. ER data model; Relational data model. Relational algebra. Types of database constraints in relational data model. Functional dependency and the relation scheme key. Fundamentals of database design. The database management system language SQL. Physical data structures and file systems. Methods and process of file organization. Pile, Sequential, Hash, Index-Sequential and Index B-tree file organization. Transaction data processing.

Teaching is performed through lessons, oral and computer exercises (in the computer classroom), as well as consultations. Through the teaching process, students are constantly motivated to an intensive discussion, problem oriented reasoning, independent study work and active participation in the whole lecturing process. The prerequisite to enter final exam is to complete all the pre-exam assignments by earning at least 30 points.

Authors	Title	Year	Publisher	Language
Groff, James R., Weinberg, Paul N., Oppel, Andrew J.	SQL: The Complete Reference, 3rd Edition	2009	McGraw Hill, Inc.	English
Date, C.J.	An Introduction to Database Systems, (8th Edition)	2003	Pearson, Boston	English

Course activity	Pre-examination	Obligations	Number of points
Project task	Yes	Yes	15.00
Complex exercises	Yes	Yes	10.00
Complex exercises	Yes	Yes	10.00
Complex exercises	Yes	No	10.00
Complex exercises	Yes	Yes	10.00
Project task	Yes	Yes	15.00
Complex exercises	Yes	Yes	10.00
Oral part of the exam	No	Yes	30.00