TI2104

TI2104 DATABASE SYSTEMS
Credits: 3 Course Coordinator:
Contact hours:

 

Three hour class session each week Instructor(s): RG, SKY
Textbook(s) and other supplemental materials
  1. C.J. Date, An Introduction to Database Systems, 6th edition, Addison Wesley, 2002
  2. Ramez Elmasri, Shamkant B. Navathe, Sham, “Fundamentals of Database Systems”, 3rd edition, Edisson Wesley, 1998
Course information Kuliah ini membahas konsep dasar basis data, hal-hal yang terkait dengan basis data dan keberadaannya dalam organisasi, teknik pemodelan dan proses perancangan basis data, query dengan menggunakan SQL serta implementasi rancangan sistem basis data dengan menggunakan perangkat lunak Oracle.
This course discusses the basic concepts of database, the things associated with the database and its presence in the organization, process modeling techniques and database design, querying using SQL and database system design implementation using Oracle software.
Pre-requisite

  • KU1072 Introduction to Information Technology
Co-requisite
Required Course
Learning outcomes Mahasiswa memiliki pemahaman dan kemampuan untuk merancang tabel data, basis data, relasi antar tabel data, melakukan pencarian dan manipulasi data yang tersimpan dalam database dengan menggunakan teknik pemrograman SQL
To develop an understanding and skills to design and implement data tables, databases, create relation among tables, queries and manipulate data using SQL programming techniques.
Student Outcomes

a

b c d e f g h I j k
R

 

Lecture/Lab Topics Covered

Week Topics
1 Introduction to Database Systems
2 Database Enviroments
3 Ralational Database Model
4 Planning, Design, and Administating Database
5-6 ER Diagram – Database Model
7 Function Depedency and Relational-Database Normalization,
8 Midterm Test
9 Introducion to SQL
10 SQL Programming – Single Table
11 SQL Programming – Multi Tables
12 Data Warehouse
13 Data Mininng
14-15    Class Presentation : Student Group Assignment
16    Final Test