DATABASE CONCEPTS

DATABASE CONCEPTS

1. File System

   • Limitations of a File System
     • Difficulty in Access
     • Data Redundancy
     • Data Inconsistency
     • Data Isolation
     • Data Dependence
     • Controlled Data Sharing

2. Database Management System

   • File System to DBMS
   • Key Concepts in DBMS
     • Database Schema
     • Data Constraint
     • Meta-data or Data Dictionary
     • Database Instance
     • Query
     • Data Manipulation
     • Database Engine

3. Relational Data Model

   • Terminology
     • ATTRIBUTE
     • TUPLE
     • DOMAIN
     • DEGREE
     • CARDINALITY

4. Important Properties of a Relation

5. Keys in a Relational Database

   • Candidate Key
   • Primary Key
   • Composite Primary Key
   • Foreign Key