Minggu, 24 September 2017
Matkul

BASIS DATA

AIK21333 - 4 sks - Ada Link Rusak?


ModulDatabase Soal dan Pembahasan
Database Soal
Kumpulan soal UTS dan UAS sistem basis data
27 Maret 2016 :
Penambahan soal UAS 2014/2015
Soal kuis SBD tentang conflict serializability dan serializability graph
soal
Database Pembahasan
Pembahasan soal UTS SBD tahun 2012/2013
Thanks to Reza Ardiansyah (IF 2011)
Pembahasan soal UAS SBD 2012-2013
Pembahasan oleh Reza Ardiansyah (IF2011)
PEMBAHASAN UTS SISTEM BASIS DATA 2013-2014 no 4 a 5 a b
PEMBAHASAN UAS SISTEM BASIS DATA 2013-2014
Pembahasan UTS SBD 2015-2016
Modul Kuliah
Modul Pre-UTS
Kontrak kuliah, deskripsi mata kuliah, tujuan perkuliahan, topik bahasan, dsb
Konsep dasar, basis data dan sistem informasi, pemrosesan konvensional dan basis data, basis data dan redudancy, komponen basis data, sistem manajemen basis data (SMBD), bahasa SMBD, lingkungan sistem basis data, keuntungan dan risiko pendekatan basis data
Model data, kategori model data, model data konseptual, entitas, atribut, nilai, model relasional, kunci primer, kunci tamu, domains, basis data relasional, pemberian nama atribut
Relationship, jenis relationship, cardinality, model Entity/Relationship (E/R), simbol dan diagram E/R, strong and weak entity, full and partial participation, multiway relationship, contoh aplikasi basis data
Aljabar relasional, Union, intersection, Set-difference, cartesian product, operasi Select, project, rename, Join, natural join, outer join, division, aggregate.
Perancangan basis data, Siklus hidup sistem informasi, tahapan perancangan basis data, Strategy Conceptual design, strategy Top-Down, strategy bottom-up, strategy inside-out, strategy campuran, logical design.
Structured Query Language, pengertian query, Data Definition Language (DDL), Data Manipulation Language (DML), struktur dasar SQL, klausa SELECT, WHERE, fungsi agregate.
SQL bagian 2: Operasi JOIN, contoh operasi JOIN, query bertingkat
Normalisasi, bentuk normal, relasi dengan anomali, tahapan normalisasi, unnormalized relation, 1NF, 2NF, 3NF relation, Boyce Code Normal Form (BCNF).
Contoh soal basis data
Contoh soal dan jawaban tentang SQL
Contoh soal dan jawaban tentang SQL
Modul Pasca-UTS
Kontrak kuliah
Overview sistem basis data
Constraints dan Triggers
Trigger
index
File dan indeks
Tree structured indexing
Hash-based indexing, hashing function, static hashing, extendible hashing, linear hashing
Transaction management, properties of transaction, consistency and isolation, database consistency, Atomicity and durability, transaction and schedules, serializability, lock-based concurrency control, strict two-phase locking
Concurrency control, two-phase locking, lock-management, deadlocks, deadlock prevention, concurrency control in B+ tree
Table constraints, domain constraints, assertion, triggers, condition, action
Soal latihan hash-based
Soal latihan stored procedure and trigger
Recovery manager, phases of restart, ARIES recovery algorithm, log, undo phase, redo phase, undo algorithm
Transaction management, properties of transaction, schedule, serializability, conflict serializability
Concurrency control, deadlock prevention, deadlock detection, the phantom problem, index-locking, timestamp ordering
Pemrosesan Query
Lock-based concurency control, Strict Two-Phase Locking (Strict 2PL), Schedule Illustrating Strict 2PL with Serial Execution and interleaved actions
Lock management, Lock Table Entry, Lock and Unlock Requests, Performance of Lock-Based Concurrency Control, Blocking and Aborting, Conservative 2PL
Premium Tutorial
Loading...
DMW - ASK
Stuck dalam pemecahan masalah pada pemrograman kamu? Sekarang kamu bisa saling tanya-jawab di halaman baru kami. TANYA DISINI
Info Lomba dan Kompetisi
Closed: 29 September 2017
Dapatkan info lengkap tentang lomba dan kompetensi yang mendatang, lihat halaman CSI Corner atau join group Facebook CSI [Creativity and Support for Informatics]