Data Modeling and Databases II

Course name: Data Modeling and Databases II
Course number: XYZ
Knowledge area: Software Development Fundamentals, Software Engineering

Administrative details

Faculty: Computer Science and Engineering
Year of instruction: 2nd year of BS
Semester of instruction: 2nd semester
No. of Credits: 4 ECTS
Total workload on average: 144 hours overall
Frontal lecture hours: 2 per week
Frontal tutorial hours: 2 per week
Lab hours: 2 per week
Individual lab hours: 0
Frequency: weekly throughout the semester
Grading mode: letters: A, B, C, D

Prerequisites

Data Modelling and Databases I
Data Structures and Algorithms I
Data Structures and Algorithms II
Discrete Math/Logic
Introduction to Programming I
Introduction to Programming II

Course outline

While the course Data Modelling and Databases I covered the core concepts behind database design and the relational model, there are further considerations that should be addressed to pursue a career in this field. This course will expand upon what it has been presented in DMD I course with focus on both software design, under the form of conceptual and logical DB design, and physical optimization. More attention will be given to the functioning of Database Management Systems (DBMS), looking at the internal implementation details.

Expected learning outcomes

Design, develop and implement a mid-scale relational database for an application domain using a relational DBMS
Understand physical database design, implementation, and optimization issues
Devise appropriate ways to store and index data

Expected acquired core competences

Relational databases
Data modeling
Database design
Database systems
Indexing
Information storage and retrieval
Implementation of RDBMS
Relational query languages
Query implementation and optimization
Software construction
Software design
Software engineering

Textbook

Reference material

Lecturing and lab slides and material will be provided
Several resources are available online and will be pointed during the course

Required computer resources

Students should have laptops.

Evaluation

Assignments and project (30%)
Mid-term Exam (30 %)
Written Final (40%)

BSc:DataModelingDatabasesII old

Contents