Subject: Database Design (17.IZOO20 )
Study programmes of the course:
| Type of studies | Title |
|---|---|
| Undergraduate Academic Studies | Industrial Engineering (Year: 4, Semester: Winter) |
Acquiring in-depth knowledge in the field of contemporary data base systems, data base design techniques and involvement into real data base design project.
By the end of the course, students should be able to: demonstrate understanding of the principles of database systems generally and the Entity-relational and the relational database models specifically; explain the basic principles and common trade-offs in designing a relational database, and to design it; set up, query, and update a relational database using interactive SQL.
Development of procedures for data management and data base concept. Fundamental concepts and characteristics of data models. Entity Relationship (ER) data model. Relational data model. Classification and types of constraints in relational data model. Functional dependencies and equivalent keys of relation scheme. Update anomalies. Normal forms. Techniques for relational data base schema design. Structured Query Language (SQL) for data definition and data manipulation.
Lectures; laboratory exercises; individual consultations; team work on the design of conceptual data base schema; individual work (assignments). Students are encouraged to communicate, to reason critically, to work independently and to contribute actively to teaching process.
| Authors | Title | Year | Publisher | Language |
|---|---|---|---|---|
| 2013 | English | |||
| 2012 | English | |||
| 2010 | English |
| Course activity | Pre-examination | Obligations | Number of points |
|---|---|---|---|
| Complex exercises | Yes | Yes | 10.00 |
| Test | Yes | Yes | 10.00 |
| Test | Yes | Yes | 10.00 |
| Complex exercises | Yes | Yes | 10.00 |
| Oral part of the exam | No | Yes | 30.00 |
| Project task | Yes | Yes | 15.00 |
| Complex exercises | Yes | Yes | 15.00 |
Prof. Ristić Sonja
Full Professor
Lectures
Assistant - Master Antanasijević Dajana
Assistant - Master
Computational classes
Assistant - Master Gladić Dejana
Assistant - Master
Computational classes
Assistant - Master Krstić Dušan
Assistant - Master
Computational classes
Assistant - Master Petrovački Jelena
Assistant - Master
Computational classes
Faculty of Technical Sciences
© 2024. Faculty of Technical Sciences.
Contact:
Address: Trg Dositeja Obradovića 6, 21102 Novi Sad
© 2024. Faculty of Technical Sciences.