tubes basdat
Post on 23-Jun-2015
1.102 Views
Preview:
TRANSCRIPT
Tugas BesarSistem Basis Data
Deskripsi Tugas BesarMembuat dokumentasi perancangan basis
data berdasarkan kasus pengembangan sistem di suatu organisasi
Dokumen-dokumen yang yarus dilengkapi:1. Deskripsi mengenai kasus / organisasi /
kebutuhan data2. Entity Relationship Diagram (ERD)3. Model Relasional4. Normalisasi (pengecekan dari model
relasional)5. Sintax SQL
Syntax SQL yang harus dilengkapiData Definition Language (DDL)
1. Create, alter, drop2. Default value3. 5 categories Integrity Constraints
PRIMARY KEY REFERENCES
Foreign key constraint UNIQUE NOT NULL CHECK
Generalized dependences expressed as valid condition in WHERE clause
Syntax SQL yang harus dilengkapi (lanjutan)Data Manipulation Language (insert)
InsertUpdateDeleteQuery (select, where, distinct)Query relationship 1-NQuery relationship N-NGroup by dan Aggregate function
(count,sum,max,min,avg)Nested query : 2 dan 3 tingkatAljabar relasional (Union, intersection, difference,
join)
top related