Summary of PEMODELAN BASIS DATA

Gedung Panehan Pasca Sarjana Lantai 1,
Jl. Telekomunikasi Terusan Buah Batu,
Bandung - 40257, Indonesia

E-Mail: clove@telkomuniversity.ac.id
Khusus Dosen: +62 821-1666-3563
Khusus Mahasiswa: +62 812-2200-1813

Selamat Datang di Perkuliahan Daring Mata Kuliah Pemodelan Basis Data

Announcements

RPS Pemodelan Basis Data

01 Introduction to Database

Lecturers Note 01 Introduction to Database

Quiz Review Sub-CLO-05-2-1 [1]

Tugas Sub-CLO-05-2-1 [1]

Forum Diskusi Minggu 1 Sub-CLO-05-2-1 [1]

External Link 01 : What is Database and SQL?

External Link 01 : History of Database

External Link 01 : Database Systems Development Life cycle

External Link 01 : Database Life Cycle

02 Pemodelan Data dalam Organisasi

Daftar Kelompok Tugas Besar

Lecture Note 02 Pemodelan Data dalam Organisasi

Quiz Review Sub-CLO-05-2-2 [1]

Forum Diskusi Minggu Sub-CLO-05-2-2 [1]

External Link 02 : Pemodelan Data

External Link 02 : Pemodelan Data conseptual-logical-physical

03 Pemodelan E-R Lanjut

Lecture Note 03 Pemodelan E-R Lanjut

Quiz Review Sub-CLO-05-2-2 [2]

Forum Diskusi Minggu 3 Sub-CLO-05-2-2 [2]

External Link 03 : Pemodelan Data menggunakan Ms Visio

External Link 03 : Pemodelan Data menggunakan Draw.io

04 Review / Latihan Soal Conceptual Modelling

Exercise 04

Progress Report 1 : ERD

05 Logical Database Design dan Model Relasional

Lecture Note 05 Logical Database Design dan Model Relasional

Quiz Review Sub-CLO-05-2-2 [3]

Forum Diskusi Sub-CLO-05-2-2 [3]

06 Anomali Data dan Functional Dependency

Lecture Note 06 Anomali Data dan Functional Dependency

Quiz Review Sub-CLO-05-2-2 [4]

Forum Diskusi Sub-CLO-05-2-2 [4]

07 Normalisasi

Lecture Note 07 Normalisasi

Quiz Review Sub-CLO-05-2-2 [5]

Progress Report - Final

Forum Diskusi Sub-CLO-05-2-2[5]

External Link 07 : Normalisasi

08 Assessment CLO 1&2

09 Review Tugas Besar

Forum Diskusi Minggu 09

Progress Report - Revisi

10 Presentasi Tugas Besar

11 Physical Database Design&Implementasi

11 Physical Database Design - Lecture Note

Quiz Review - Physical Database Design &amp; Implementation DB Sub-CLO-05-2-3 [1]

11 Database Implementation - Lecture Note

Forum Diskusi Minggu 11 Sub-CLO-05-2-3 [1]

12 Processing Single Table (Part 1)

12 Processing Single Table (Part 1) - Lecture Note

Quiz Review - Processing SIngle Table (Part 1) Sub-CLO-05-2-3 [2]

Forum Diskusi Minggu 12 Sub-CLO-05-2-3 [2]

External Link - W3Schools SQL

13 Processing Single Table (Part 2)

13 Processing SIngle Table (Part 2) - Lecture Note

Quiz Review - Processing Single Table (Part 2) Sub-CLO-05-2-3 [3]

Forum Diskusi Minggu 13 Sub-CLO-05-2-3 [3]

External Link - SQL Tutorial

14 Processing Multiple Tables and SubQuery

14 Processing Multiple Tables - Lecture Note

Quiz Review - Processing Multiple Tables dan Subquery Sub-CLO-05-2-3 [4]

Forum Diskusi Minggu 14 Sub-CLO-05-2-3 [4]

External Link - Join Visual Representation

External Link - W3Resource Subquery

Progress Report : DDL DML

PEMODELAN BASIS DATA

Quiz Review - Physical Database Design & Implementation DB Sub-CLO-05-2-3 [1]