Module designation | Database (MAT206) | ||||||||||||||
Semester(s) in which the module is taught | 4th | ||||||||||||||
Person responsible for the module | Drs. Edi Winarko, M.Cs. | ||||||||||||||
Language | Indonesian | ||||||||||||||
Relation to curriculum | Compulsory / elective / specialisation | ||||||||||||||
Teaching methods | Lecture and lesson. | ||||||||||||||
Workload (incl. contact hours, self-study hours) | 2×110 minutes (2×50 minutes lecture and lesson, 2×60 minutes structural activities, 2×60 minutes self-study) per week for 16 weeks | ||||||||||||||
Credit points | 2 CP (3,2 ECTS) | ||||||||||||||
Required and recommended prerequisites for joining the module | – Algorithms and Programming (MAT101) | ||||||||||||||
Module objectives/intended learning outcomes | General Competence (Knowledge): Capable can understanding database systems and using DBMS systems in data storage.Specific Competence: students are 1. Able to understand basic database concepts (introduction to databases, database architecture, description, and data models).2. Able to build an Entity Relationship Model (ER-Diagram)3. Able to perform Data Normalization (Normal form and redundancy, Functional Dependence, Normalization Process, Normal Form I, II, III, and BCNF)4. Able to Build Relational Models (Relational Database, Relational Algebra, Relational Calculus)5. Able to apply SQL Language in defining and manipulating data.6. Able to implement database design (ER-Diagram) in a Database (Database Design and Query, and case studies)
| ||||||||||||||
Content | Basic Database Concepts, Entity Relationship Model, Normalization, Functional Dependencies, Normal Form I, II, III, and BCNF, Relational Model (Relational Database, Relational Algebra, Relational Calculus), SQL Language, Database Implementation (Database Design and Query, and case studies) | ||||||||||||||
Examination forms | Essay | ||||||||||||||
Study and examination requirements | Students are considered to pass if they at least have got a final score 40 (D). Final score is calculated as follows: 10% softskill+20% assignment + 20% Quiz + 25% midterm + 25% final exam.
Final index is defined as follow:
| ||||||||||||||
Reading list |
4. Winarko, Edi. 2006, Perancangan Database dengan Power Designer 6.32. |