13E113BP - Databases 1

Course specification
Course title		Databases 1
Acronym		13E113BP
Study programme		Electrical Engineering and Computing
Module
Type of study		bachelor academic studies
Lecturer (for classes)		professor PhD Miloš Cvetanović
Lecturer/Associate (for practice)		MA Stefan Tubić, electrical and computer engineer asst. MA Tamara Šekularac Obradović, electrical and computer engineer
Lecturer/Associate (for OTC)		MA Stefan Tubić, electrical and computer engineer asst. MA Tamara Šekularac Obradović, electrical and computer engineer
ESPB		6.0	Status	elective
Condition		None
The goal		1. Introduce students to fundamentals and principles of DBMS. 2. Introduce the database design concepts. 3. Provide students with the ability to design and implement concrete data base and use commercially available DBMS.
The outcome		Students are capable to design and implement concrete data base and use commercially available DBMS.
Contents
URL to the subject page		https://rti.etf.bg.edu.rs/rti/bp1/index.html
URL to lectures		https://teams.microsoft.com/l/team/19%3aouxbLyn32pp5c7muH3yGuZpJdbCFmeZKUYT_G7azdrU1%40thread.tacv2/conversations?groupId=83be7308-50fd-4805-8e0d-2f3b0fe790f8&tenantId=1774ef2e-9c62-478a-8d3a-fd2a495547ba
Contents of lectures		Fundamentals and Principles of DBMS. Data Abstraction. Instances and Schemes. Data Independence. Data Models. DDL, DML. Entity-Relationship Model. Relational Data Model. Relational Algebra & Calculus, SQL. Optimization of Relational Queries. Object-Oriented Database Systems. Object-Relational Database Systems.Transaction processing. Validation techniques. Crash recovery. Commercial Systems.
Contents of exercises		Laboratory exercises: Design and implementation of concrete data base using commercially available DBMS.
Literature
Database System Concepts, A. Silberschatz, H. Korth, S Sudarshan, McGraw Hill International Edition, 2005. (Original title) Database Systems:The Complete Book, H. Garcia-Molina, J.D.Ulman, J. Widom, Prentice Hall, 2002. (Original title) Upravljanje Transakcijama, M.Bojovic, Akademska misao, 2003. (Original title)
Number of hours per week during the semester/trimester/year
Lectures	Exercises	OTC	Study and Research	Other classes
2	2	1
Methods of teaching		30 hours of lectures + 30 hours of supervised problem classes + 15 hours of supervised laboratory classes, midterm tests and project. Approximately 75 hours of personal study and exercise (3 hours per week during semester, and approximately 30 hours of preparation during exam term).
Knowledge score (maximum points 100)
Pre obligations		Points	Final exam	Points
Activites during lectures		0	Test paper	60
Practical lessons		10	Oral examination	0
Projects		10
Colloquia		20
Seminars		0