DFC 2083 DATABASE DESIGN

1. LOGICAL DESIGN

1.1. LAB 1: FUNDAMENTAL OF DATABASE MANAGEMENT SYSTEM

1.1.1. DBMS

1.2. LAB 2: RELATIONAL DATA MODEL

1.2.1. Component of Database

1.2.1.1. Record(Tuple)

1.2.1.2. Attribute(field)

1.2.1.3. Domain

1.2.1.4. Degree

1.2.1.5. Cardinality

1.2.2. Relation Scheme and Relation Instance

1.2.2.1. Relation

1.2.2.2. Attribute

1.2.2.3. Domain

1.2.3. Relation Keys

1.2.3.1. Primary Key

1.2.3.2. Candidate Key

1.2.3.3. Foreign Key

1.2.4. Integrity Rules

1.2.4.1. Entity Integrity

1.2.4.2. Referential Integrity

1.3. LAB 3: ENTITY RELATIONSHIP MODEL AND NORMALIZATION

1.3.1. ERD

1.3.1.1. Chen Model

1.3.1.2. Crow' Foot Model

1.3.2. Normalization

1.3.2.1. Dependencies

1.3.2.1.1. Functional

1.3.2.1.2. Transitive

1.3.2.2. UNF - 3NF

2. PHYSICAL DESIGN

2.1. LAB 4: STRUCTURED QUERY LANGUAGE

2.1.1. DDL

2.1.2. DML

2.1.3. SQL Advance Command

2.1.4. SQL Functions

2.2. LAB 5: DATABASE TRANSACTION MANAGEMENT

2.2.1. Perform transaction using SQL statement

2.2.2. Use START TRANSACTION and COMMIT statement