My Blog

My Formal Blog

 

Soal UAS SBD 2010

 

Soal latihan Recovery :

Soal UAS SBD 2010

 

Tugas Transaction Processing

 

Tugas SBD untuk minggu ini :

1. Resume Bab Transaction Processing (tugas kelompok)

2. Soal Transaction Processing (Tugas Individu)

Tugas dikumpul hari Rabu, 16 November 2011.

 

Soal Latihan SBD

 

Berikut beberapa soal latihan untuk dipelajari :

Soal Quiz 13 Oktober 2011

Soal UTS SBD 2010

 

SISTEM BASIS DATA Semester Ganjil 2011

 

Aturan dan materi perkuliahan Sistem Basis Data untuk semester Ganjil 2011 dapat diunduh disini :

ch0-rules

ch01-Introduction

Untuk Form Penilaian tugas dan softskill dapat diunduh disini :

FORM PENILAIAN SOFTSKILL

 

Pembahasan Soal Quiz dan Tugas PBDR

 

Berikut merupakan pembahasan soal latihan dan kuiz PBDR :

Quiz 1

Latihan SQL

QUIZ DDL

QUIZ SQL

QUIZ UAS

 

Materi PTI Semester Genap 2010

 

Berikut materi PTI untuk semester genap 2010 :

Ch00-Pengantar Teknik Informatika (CS1013)

PTI-20102-01-Computing Disciplines

PTI-20092-02-SDM di Bidang TIK

PTI-20092-03-Computing Before Computers

PTI-20092-04-History of Modern Computing

PTI-20092-06-Representasi Bilangan_Gerbang Logika

PTI-20092-07-Intro to Computer Architecture

PTI-20092-08-Intro to Operating Systems

PTI-20092-09-Intro to Algorithms and Efficiency

PTI-20092-10-Intro to Algorithmic Strategies

PTI-20092-11-Intro to Programming

PTI-20092-12-Intro to Software Engineering

PTI-20092-13-Intro to Computer Networks

PTI-20092-14-Intro to Concurrency-Parallelism_Distributed Computer Systems_Middleware

PTI-20092-15-Intro to Discrete_Data Structures

PTI-20092-16-Intro to Professionalism

PTI-20092-17-Intro to Computer Based Systems_Databases

 

Materi PBDR Semester Genap 2010

 

Berikut materi PBDR untuk semester genap 2010 :

ch0-rules

ch01 – introduction

ch02 Relational Model (1)

ch02 Relational Model (2]

ch04 ER Diagram (1)

ch05 ER Diagram (2)

Normalisasi 1

COntoh2 Normalisasi

Functional Dependency 1

Functional Dependency 2

Materi setelah UTS :

SQL 1 [basic]

SQL2

SQL3

SQL4

 

Materi Transaction, Concurency & Recovery

 

Berikut materi SBD untuk materi transaction processing, Concurency Control dan Recovery :

Ch11-Transaction Processing

Ch12-Concurency Control

Ch13-Recovery System

Presedence Graph

 

Materi Transaction Processing

 

Berikut materi transaction processing :

Transaction Processing 1

Transaction Processing 2

 

Materi SBD : Query Processing dan Query Optimization

 

Berikut materi Query Processing dan Query Optimization :

ch08-Query Processing 1 [Overview QP]

ch09-Query Processing 2 [Measures Query Cost-Selection Sorting]

ch10-Query Processing 3 [Measures Query Cost-Join]

ch12-Query Optimization 1

ch13-Query Optimization 2

Catatan :

Mohon maaf Design slide dengan terpaksa harus disederhanakan untuk kemudahan akses file