Course ePortfolio

IM-Databases

This course addresses Database Fundamentals in Computer Science Engineering.

Computer Science Curricula 2013 ACM. Knowledge Management: Information Management (IM).

  • Introduction to DBMS concepts
  • Data modeling and database design
  • Relational database design
  • Query languages
  • Storage and indexing
  • Query processing
  • Transaction processing
  • Recovery
Share

Introduction to Computer Sciences 

Algorithms

Pedagogical Approach

Encouraging group collaboration to promote interaction. Tutor supervise and supports student collaboration in positive ways.

Learning Outcomes

  • Compare and contrast appropriate data models, including internal structures, for different types of data. [Assessment].
  • Describe concepts in modeling notation (e.g., Entity-Relation Diagrams or UML) and how they would be used. [Familiarity].
  • Describe the basic principles of the relational data model. [Familiarity].
  • Apply the modeling concepts and notation of the relational data model. [Usage].
  • Mapping conceptual schema to a relational schema
  • Relational Database design.

 

Assessment

Students are assessed based on written homework, programming works, and midterm and final exams. The projects involve a large-scale relational database design using a commercial DBMS such as PostgreSQL and MariaDB.

Other Information

None