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:

A

: 86 – 100

AB

: 78 – 85.99

B

: 70 – 77.99

BC

: 62 – 69.99

C

: 54 – 61.99

D

: 40 – 53.99

E

: 0 – 39.99

Reading list

  1. Korth and Silberschatz, 1997, Data Base Systems Concept, McGraw-Hill
  2. C.J.Date, 1982, An Introduction to Data Base System
  3. Elmasri and Navathe, 2000,Fundamental of Database Systems, Addison-Wesley, Inc.

4.      Winarko, Edi. 2006, Perancangan Database dengan Power Designer 6.32.