RDB

Database design/creation practice

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
13
Level: 
II
  • Business analysis
    • Screening out entities
    • Creation of ERD
  • Design procedure of databases
    • Schema
    • Index
    • Distributed databases
  • Physical designs
  • Creation of tables
    • Restriction
    • Data loading
  • Items required in actual DB application developments
    • Procedures for the designs of business forms and screens

Typical open source RDBMS products

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
12
Level: 
II
  • Following typical open source RDBMSs’s history of developments, main functions,features, and their licenses
    • PostgreSQL
    • Firebird
    • MySQL
    • SQLite
  • Comparison with commercial RDBMS
  • Reason of using open source RDBMS
  • Portability
  • Difference among RDBMSs
    • Backup (online and offline)
    • Specialized features
      • Vacuum

Database access in SQL

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
11
Level: 
II
  • SQL (Structured Query Language)
    • Structure
    • Principle
    • Operation specifications
    • Types
    • Features.
  • Creation of tables
    • Data type specification
    • Handling of NULL
    • Specifying procedures of primary key and foreign key.
  • Data retrieval and query processing
    • SELECT statements
      • Processing of data

The database physical structure

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
10
Level: 
II
  • Physical structure of databases required in the implementation of relational databases.
  • Purpose of physical design of databases, and procedures required in the physical design
    • Tradeoff to note in the design
    • How to locate data, index and log
    • Securing database storage area.

Database indexes

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
9
Level: 
II
  • Concept of index
  • Principle of index
    • Algorisms of retrieval
  • Implementation of index
    • Physical structure
    • Performance
    • Recovery characteristics of index.
  • Features, advantages and disadvantages with various types of index
    • Binary tree (B tree)
    • Index-organized tables
    • Bitmap index
    • Reverse key index
    • Hash cluster (hash index)

Normalization

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
8
Level: 
I
  • Outline of normalization
    • Basic concepts
    • Functional dependency
    • Types of normal forms.
  • Normalization procedures and methods

ER models

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
7
Level: 
I
  • Outline of ER model (Entity-Relational model)
  • Data representation methods
    • Entity
    • Relationship
    • Attribute
    • Cardinality
  • ERD (Entity Relational Diagram)
    • Components

Basic database design theory

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
6
Level: 
I
  • Methods and procedures for database design
    • Business analysis
    • Conceptual design
    • Physical design
    • Database design
  • Two analytic techniques
    • The top-down approach
    • The bottom-up approach.

DOA

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
5
Level: 
I
  • Outline of DOA (Data-Oriented Approach)
    • Difference from the conventional process design approaches.
  • Data models
    • Conceptual data model
    • Logical data model
    • Physical data model
  • Three-layer schemas.
    • Conceptual schema
    • External schema
    • Internal schema

Database components

Code No
Skill Category No: 
8
Skill No: 
1
Topic No: 
4
Level: 
I
  • Definition of the components of a relational database
    • Table
    • Attribute
    • Tuple
  • Relational schemas
    • Introduction relational schemas
    • Main keys to identify only one record
    • Main keys having plural attributes
    • External keys.
  • Set operations
    • Union
    • Difference
    • Intersection
    • Cartesian product
Syndicate content