Background Pattern

Database Management

Course Code

II2250

Number of Credits

2

Semester

4

Course Type

C

NoCodeCourseRelation
1IF2040Database ModelingPrerequisite
2II2250Database ManagementEquivalent

Study Material

Study MaterialDepth
Database architectureExpert
Storage system and file structureExpert
Database tuningExpert
PengindeksanExpert
Query processingExpert
Integrity constraintsExpert
Database securityExpert
TransactionsExpert
ConcurrencyExpert

Graduate Learning Outcomes (GLO) carried by the course

CPMK CodeCourse Learning Outcomes Elements (CLO)
CPMK 1Explains the basic principles of how data is stored and file structure, improving database performance, the basics of transaction management (including concurrency and recovery systems), database security, and database system architecture.
CPMK 2Demonstrate the ability to improve database performance by utilizing various database performance improvement techniques, indexing and hashing, query optimization, and database programming according to organizational needs.
CPMK 3Demonstrate the ability to maintain data integrity and security in accordance with the organization's business needs
CPMK 4Demonstrate basic skills as a database administrator.

Learning Method

  • Lectures and problem-based learning

Learning Modality

  • Synchronous in-person class

Assessment Methods

  • Mid-term exam, final exam, assignments, and quizzes