Subject: Databases
(12 -
SE0016) Basic Information
Course specification
Course is active from 27.10.2012.. Precondition courses
Basic students' education in databases. Students gain fundamental knowledge in databases and learn basic techniques of implementation, use and maintenance of databases. The acquired knowledge is used in practice and in future engineering courses: Databases 2, Software Specification and Modeling, Information System Engineering, Business Informatics, 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. 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.
|