Fasilkom UI, 2005 By Indra Budi

1
Fasilkom UI, 2005By Indra Budi Siti Aminah
Intro to Course
IKI20420 BASIS DATA
2
Lecturers

• Class A
• Indra Budi
• Room 1222
• indra_at_cs.ui.ac.id
• Class B
• Siti Aminah
• Room 1226
• aminah_at_cs.ui.ac.id

3
Course Goals

• Provide a Practical Introduction to Database
  Models, Theory, and Systems
• Focus on Both Theory and Practice
• Theory Demonstrates Mathematical Basis of
  Databases (Relational Model and Concurrency
  Control)
• Practice Provides Experimental Framework for
  Illustrating Theory (Actual Database Systems and
  their Usage)

4
Textbooks and Class Materials

• Required Text
• Fundamentals of Database Systems, Elmasri and
  Navathe, Addison-Wesley, 4th ed (2004)
• You can order the book via our library
• Course Web Site
• http//telaga.cs.ui.ac.id/WebKuliah/basisdata2005
• Course Forum
• - forum.iki.basisdata

5
Topics Tentative Schedule
6
Topics Tentative Schedule
7
Topics Tentative Schedule
8
Topics Tentative Schedule
9
Group Project

• Design - Your choice of design tool
• Entity Relationship
• Mapping to Relational Model Normalization
• GUI Development - Your choice of Programming
  Language
• Interactions to Database via ODBC/JDBC
• Database System Platform
• Oracle 10g
• Self-Learning and Knowledge Acquisition
• All Programming Projects Will be Demonstrated by
  the Team for Correctness and Grading

10
Group Project

• Report I System description and design (29th
  March)
• System Description
• (E)ER
• Mapping to Relational Normalization
• Report II Final System (6th June)
• System Implementation Docs
• Demo!

11
Group Paper (tentative)

• Comparation of common DBMS (Oracle, MS SQL
  Server, DB2, MySQL, PostgreSQL, MS Access)
• Due 30th May

12
Grading (tentative)

• Presences Participations 5
• Group Project 35
• Group Paper 5
• Quizzes Homeworks 15
• Mid Test 20
• Final Test 20
• Note. There is peer-evaluation on each group
  assignment.

13
Tutorial Assistants

• Tutorial Schedule Monday 15.00 pm
• Tutorial Materials
• Exercises on ER, EER, Mapping to Relational,
  Normalization, SQL
• Tutorials on tools ER-Win/Visio/other design
  tool, Oracle 10g, Prog lang (PHP/ASP/Others),
  ODBC
• On demand
• Assistants
• Class A Arnold Willem, Theresia Budiarti,
  Antonius Hermawan (email arwi20, thbu20,
  anhe20_at_mhs.cs.ui.ac.id)
• Class B Wadiono Valens , Ferry Haris, Imelda
  Tandra
• (email wava20, feha20, imta20_at_mhs.cs.ui.ac.id)