BSc:DataModelingDatabasesII old

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

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%)