Subject: Fundamentals of databases
(17 -
SIT022) Basic Information
Course specification
Course is active from 01.10.2010.. Course which have preconditioned courses Fundamentals of databases
Studying concepts of relational databases. Studying the SQL language, standards for accessing relational databases, and representative CASE data modeling tools. Knowledge about the concepts of relational databases. Knowledge to use the SQL language to access relational databases. Skills in using CASE tools for modeling relational databases. Database Evolution / Database Management System Elements / Data Modeling: ER Model / Relational Data Model / Relational Algebra / SQL Language / Limits and triggers / Indexes / Procedural Extensions of SQL / Stored Procedures / Transaction Management / Object Relational Mapping Teaching methods include: Lectures, computer exercises, homework assignments and consultations. In lectures, by using the necessary didactic means, the content of the subject is exposed and the active participation of students is raised by asking questions. The practical aspect of the course is covered at laboratory practice classes through assignments which students do independently or with the help of teaching assistants. A student is expected to demonstrate the ability of independent task solving or understanding of the solution. During the consultations, students are given additional explanations of the contents of the lectures and exercises. The assessment of the exam is based on the success of the laboratory exercises and the oral exam.
|