Review

1
Review
2
Database Introduction

• Database vs File Processing
• Database Actors
• DBA, Database Designers, Database users,
  Application Programmer
• DBMS

3
Database Concept

• Database schema
• Three-Schema Architectures of DBMS
• Internal, Conceptual External
• Database Development

4
Database Modeling

• Using ER-Diagram
• Entity
• Relationship
• Attributes
• Cardinality
• Participation
• Higher Degree Relationship

5
E-ER Diagram

• Specialization
• Generalization
• Sub-Class Super-Class

6
Relational Model

• Domain
• Tuples
• Attributes
• Relations
• Primary Key
• Referential Integrity
• Foreign Key

7
ER-to-Relational Model

• Mapping ER to Relational Model
• Mapping EER to Relational Model
• Reverse Engineering ? Relational Model to ER
  Diagram
• Normalization
• 1st, 2nd, 3rd Normal Form

8
Relational Algebra

• Select
• Project
• Union
• Difference
• Intersection
• Cross Product
• Join
• Division

9
Relational calculus

• Tuple RC
• Domain RC

10
SQL

• Create table
• Delete table
• Alter table
• Select From Where
• DISTINCT Operators
• Null Values
• Nested Queries (Sub Queries)
• Operators ? , , _, etc
• View Table
• Join Operation
• Cross, Natural, Theta, Outer
• Aggregation Function
• SUM, AVG, COUNT, MAX, MIN
• GROUP BY
• Order BY
• Having

11
Trigger, Stored Procedure Indexing

• Trigger vs Stored Procedure
• Primary Index, Clustering Secondary Index
• Multilevel Index
• B-Tree vs B-Tree
• Create Index in SQL

12
Transaction

• ACID
• Problem
• Lost Update, Incorrect summary, dirty read, etc
• Schedule
• Serial, Serializability, Precedence Graph
• Concurrency Control
• Deadlock
• 2-Phase Locking Protocol
• Timestamp
• Recovery
• Deferred, Immediate Shadow
• 2PC Protocol

13
UAS

• Rabu, 2 Juni 2006 jam 09.00 ruang 403 404
• Open notes, 1 lembar A4, tulisan tangan sendiri,
  tidak boleh foto copy.
• Materi Semua dengan fokus SQL s/d database
  recovery.