Data Modeling and Database Systems

Објавено: October 23, 2019
  1.    Course Title Data Modeling and Database Systems
  2.    Code 3ФЕИТ07Л018
  3.    Study program KHIE, KSIAR, KTI, TKII
  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 II/4, III/6, IV/8   7.    Number of ECTS credits 6.00
  8.    Lecturer Dr 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.

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 10
17.2. Seminar work/project (presentation: written and oral) 10
17.3. Activity and participation 0
17.4. Final exam 80
18.    Grading criteria (points) up to 50 points     5 (five) (F)
from 51 to 60 points     6 (six) (E)
from 61 to 70 points     7 (seven) (D)
from 71 to 80 points     8 (eight) (C)
from 81 to 90 points     9 (nine) (B)
from 91 to 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 Evaluation of the curriculum using tests and quizzes
23.   Literature
23.1. Required Literature
No. Author Title Publisher Year
1 Rames Elmasri, Shamkant Navathe Fundamentals of database systems Pearson 2015
2 C.J. Date An introduction to database systems Pearson 2015
3 Hector Garcia-Molina, Jerfrey Ullman Database systems: the complete book Pearson 2008