Module/Course Title: Database

Module course code

KOMS120204

Student Workload
119 hours

Credits

3 / 4.5 ETCS

Semester

2

Frequency

Even Semester

Duration

16

1

Type of course

Core Study Courses

Contact hours


40 hours of face-to-face (theoretical) class activity

Independent Study


48 hours of independent activity
48 hours of structured activities

Class Size

30

2

Prerequisites for participation (if applicable)

-

3

Learning Outcomes

  1. Students can demonstrate systematic thinking in analyzing and designing software and database solutions
  2. Students can apply effective methods in developing software and databases
  3. Students can create and evaluate software and database solutions
  4. Students can design databases in the form of Entity Relationship Diagrams
  5. Students can apply relational mapping
  6. Students can apply normalization database
  7. Students can create ERD
  8. Student can apply relational mapping and normalization processes based on case studies

4

Subject aims/Content

Database is one of the compulsory courses in the Computer Science Study Programme. Database course is a course that provides basic database concepts to students, how to create data models, design databases properly and explain information systems where database applications can be applied. Database discusses Entity Relationship Diagram (ERD). Transform ERD into Relational Database. Perform database normalization to solve data anomaly problems.(1NF-3NF).

Study Material

Introduction to Database

  • Data and Types of Data;
  • Information, sources of information;
  • Database.

Introduction to Database Systems

  • File System Vs Database System
  • Database Users
  • Information Systems

Data Types and Data Abstraction

  1. Conceptual Level
  2. Physical Level
  3. View Level

Database Modeling with ER Diagram Diagrams

  1. Entity
  2. Relation
  3. Attribute

Database Modeling with ER Diagram Diagrams

  1. Composite Attribute
  2. Multivalued Attribute
  3. Derivative Attribute

Database Modeling with ER Diagram Diagrams

  1. Unary Relationship
  2. Binary Relationship
  3. Ternary Relationship

Database Modeling with ER Diagram Diagrams

  1. Cardinality
  2. Modality

-

Transformation of ER Diagram into Relational Database

  1. The concept of the relational model
  2. Relational Integrity Constraints
  3. Entity Integrity
  4. Referential integrity

Normalization 1NF

2NF Normalization

3NF Normalization

Performing Normalization starting from Cases or the Universal Table

Structure Query Language

SQL

  1. Data Definition Language (DDL)
  2. Data Manipulation Language (DML)
  3. Transaction Control Language

-

5

Teaching methods

Synchronous:

Face-to-face meetings/online meetings

6

Assesment Methods

Attendance and participation

7

This module/course is used in the following study programme/s as well

Computer Science Study Programme

8

Responsibility for module/course

  • I Nyoman Saputra Wahyu Wijaya, S.Kom., M.Cs
  • NIDN : 0826108901

9

Other Information

  1. Silberschatz, Avi, et al. 2019. Database System Concepts Seventh Edition. McGraw-Hill
  2.  Ramez Elmasri, Shamkant B. Navathe.2015. Fundamentals of Data-base Systems. Pearson
  3. David M. Kroenke, Database Processing (Fundamental, Design, Implementation)
  4. Oracle Academy Database Foundation and Database Desain Courses
  5. I. N. S. W. Wijaya, K. A. Seputra, and W. G. S. Parwita, “Comparison of the BM25 and rabinkarp algorithm for plagiarism detection,” J. Phys. Conf. Ser., vol. 1810, no. 1, 2021, doi: 10.1088/1742-6596/1810/1/012032.
  6. https://www.youtube.com/watch?v=wOD02sezmX8
  7. https://www.youtube.com/watch?v=7m6gXeMDaHc