Data Modeling and Database Systems

Објавено: June 28, 2022
1. Course Title Data Modeling and Database Systems
2. Code 4ФЕИТ07Л009
3. Study program КТИ,КХИЕ,КСИАР,ТКИИ
4. Organizer of the study program (unit, institute, department) Faculty of Electrical Engineering and Information Technologies
5. Degree (first, second, third cycle) First cycle
6. Academic year/semester III/6, IV/8, II/4 7. Number of ECTS credits 6
8. Lecturer D-r Goran Jakimovski
9. Course Prerequisites Passed: Data Structures and Programming
10. Course Goals (acquired competencies): Modeling using EA and EEA diagrams. Writing queries using SQL and relational algebra. Upon completion, the student will be able to design and implement their own databases, maintain and write SQL queries.
– Modeling databases from scratch, defining restrictions and normalization
– Translating client requests into a database model
– mapping database models into a database in mysql
– working with relational databases and writing sql queries
– creating triggers and indexes
11. Course Syllabus: Introduction to data structures. Physical organization of memory. Concept of data. Different data structures. Defining data blocks. PILE, Hash, B, B +, B * memory organization. Hard Drive organization. Data storage and disk access. Access Optimization.
Real-world models. Class diagram.
Introduction to the Entity-Association diagram. Extended EA diagram. Modeling. Mapping the EEA diagram into Relational databases. Create tables with SQL syntax. Differences between SQL databases and relational databases.Making queries. Relational algebra. Relational calculations. Advanced operators and results from questions in relational algebra.
Introduction to SQL queries. SQL syntax. Result of the queries. Multi-sets. Aggregate functions. Defining functional dependence of data. Defining of functional dependence. Data Normalization. Normal forms. Defining Events. Triggers
12. Learning methods: Theoretical and practical (laboratory) classes
13. Total number of course hours 2 + 2 + 1 + 0
14. Distribution of course hours 180
15. Forms of teaching 15.1. Lectures-theoretical teaching 30
15.2. Exercises (laboratory, practice classes), seminars, teamwork 45
16. Other course activities 16.1. Projects, seminar papers 25
16.2. Individual tasks 20
16.3. Homework and self-learning 60
17. Grading 17.1. Exams 0
17.2. Seminar work/project (presentation: written and oral) 0
17.3. Activity and participation 0
17.4. Final exam 100
18. Grading criteria (points) up to 50 points 5 (five) (F)
from 51to 60 points 6 (six) (E)
from 61to 70 points 7 (seven) (D)
from 71to 80 points 8 (eight) (C)
from 81to 90 points 9 (nine) (B)
from 91to 100 points 10 (ten) (A)
19. Conditions for acquiring teacher’s signature and for taking final exam Practical (laboratory) exercises
20. Forms of assessment During the semester, two partial exams are scheduled (in the middle of the semester and at the end of it with the duration of 120 minutes, with additional 30 minutes), which have theoretical and practical part. The students have the option to take the entire exam (not using the partial exams). Students have to take the practical and the theoretical part of the exam at the same time. The theoretical part is consisted of short questions from the curriculum, whereas, the practical part is consisted of requests to model, design and develop a database, followed by writing SQL queries. The theoretical part takes 30% and the theoretical part takes 70% of the final grade.
21. Language Macedonian and English
22. Method of monitoring of teaching quality Internal evaluation and survey
23. Literature
23.1. Required Literature
No. Author Title Publisher Year
1 Elmasri, Navathe Fundamentals of database systems ed 7 Pearson 2015
2 C.J. Date An introduction to database systems Pearson 2015
3 Hector Garcia-molina, Ulman, Widom Database Systems: The Complete Book Pearson 2008