Databases

This course prepares students to design databases using the entity-relationship model and normalisation, implement relational databases and SQL queries, and apply transactions, indexes and access control in databases. Study materials: Data Management (DM).

Topics

1. Databases using the entity-relationship model and normalisation
2. Relational databases and SQL queries
3. Transactions, indexes and access control in databases

Each course outcome derives from one programme outcome.

1. CPMK0701

   Students are able to design storage schemas for data and information in various formats

   CPL07
2. CPMK0702

   Students are able to implement methods for managing data and information in various formats

   CPL07

CPL07

Design and implement methods to manage data and information in various formats.

–

Prerequisite for

• IF25-22014 Web Application Development · 3 credits · Semester 4
• IF25-22015 Information Systems · 2 credits · Semester 4
• IF25-22017 Mobile Application Development · 3 credits · Semester 4

• IF2215 Basis Data · 3 credits · Kode, semester 4→3