Basis Data
Databases · Data & Basis Data · 4 sks wajib · MIK1624303 (2020: PAIK6303)
Membuka Manajemen Basis Data
Materi
Folder Drive ↗Sebelum UTS 15
- 1 Overview PDF ↗
- 2.1 MODEL RELATIONAL PDF ↗
- 2.2 Database modelling PDF ↗
- 2.3 Entity and Attribute PDF ↗
- 3.1 Relationship PDF ↗
- 3.2 Tipe Relationship PDF ↗
- 3.3 Supertype Subtype PDF ↗
- 4.1 Relationship Mapping PDF ↗
- 4.2 Mapping PDF ↗
- 4.3 Generalization, Specialization and Aggregation in ER Model PDF ↗
- 5 Normalization Catatan PDF ↗
- 6.1 NORMALIZATION Advanced Catatan PDF ↗
- 6.2 Relational Algebra Advanced PDF ↗
- 6.3 Relational Algebra 1 PDF ↗
- 6.4 Relational Algebra PDF ↗
Lainnya Kontrak Kuliah
Catatan
- 1 SQL dasar — SELECT sampai GROUP BY Membaca data dengan SELECT, memfilter, mengurutkan, agregasi, dan JOIN. Semua bisa langsung dicoba di SQLite dalam browser. ▶ visual
- 2 Normalisasi — 1NF, 2NF, 3NF, BCNF Kenapa tabel "satu untuk semua" bermasalah, functional dependency, dan langkah normalisasi dengan contoh KRS. ▶ visual
UTS & UAS
ada pembahasanUTS
2025- Normalisasi — 1NF, 2NF, 3NF, BCNF · Periksa dependensi dan bedakan bentuk normal.
UAS
2025- SQL dasar — SELECT sampai GROUP BY · Gabungkan tabel dengan JOIN dan jaga grain hasil query.
Silabus
- 1 Definisi Basis data dan sistem basis data, arsitektur basis data, pengguna basis data
- 2 Model data representasional dan Model relasional
- 3 Entitas dan atribut
- 4 Tipe data, relationship, dan constraints
- 5 Entity Integrity Constraints, dan Referential Integrity Constraints
- 6 Relationship, kardinalitas, optionalitas
- 7 Diagram ER
- 8 Aljabar Relasional
- 9 Normalisasi (ketergantungan fungsional, 1NF, 2NF, 3NF, BCNF, 4NF dan 5NF)
- 10 SQL
- 11 DDL
- 12 DML
- 13 Studi kasus
Sumber: Silabus Informatika 2020 (PAIK6303).
Referensi
- Ramakhrisnan, Raghu & Gehrke, Johanes. Database Management System , 3rd edition. McGraw Hill. 2013
- Silberschat, Abraham; Korth, F Henry; Sudharsan S, Database System Concepts, 7 th edition, McGraw Hill, 2020
- Domdouzis, Konstantinos; Lake, Peter; Crowther, Paul; Concise Guide to Database, 2 nd edition, Springer, 2021
- Elmashri; Navathe; Fundamentals of Database System, 7 th edition, Pearson, 2016
- Oracle Database Design
- Oracle Database Programming with SQL