Data Modeling and Database Systems

Course title: Data Modeling and Database Systems

Code: 3ФЕИТ07Л018

Number of credits (ECTS): 6

Weekly number of classes: 2+2+1+0

Prerequisite for enrollment of the subject: Passed: Data Structures and Programming

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.

Total available number of classes: 180

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.

Literature: