13S112BP1 - Databases 1
Course specification | ||||
---|---|---|---|---|
Course title | Databases 1 | |||
Acronym | 13S112BP1 | |||
Study programme | Software Engineering | |||
Module | ||||
Type of study | bachelor academic studies | |||
Lecturer (for classes) | ||||
Lecturer/Associate (for practice) | ||||
Lecturer/Associate (for OTC) | ||||
ESPB | 6.0 | Status | mandatory | |
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.ac.rs/rti/bp1/index.html | |||
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. Normalization. SQL. | |||
Contents of exercises | Laboratory exercises: Design and implementation of concrete data base using commercially available DBMS. | |||
Literature | ||||
| ||||
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 |