Subject: Databases
(12 -
EE417A) Basic Information
Course specification
Course is active from 01.10.2005.. 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, in projects of database and information system development, as well as in advanced courses requiring a use of basic knowledge in databases. The evolution of data management process and the notion of a database. Basic concepts and characteristics of data models. ER data model. Relational data model. A classification and types of database constraints in the relational data model. Functional dependency and the relation scheme key. Basic design techniques of relational database schemas. Basic characteristics of database management systems. The use of SQL in creating database schemas and data manipulation. 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.
|