Database Fundamentals

• Introduction
• Objectives
• Database Definition
• Database System Definition
• Database Properties
• DBMS Definition
• DBMS Functions
• Advantages & Disadvantages of Database
• The Three Levels of Architecture
• External Level
• Conceptual Level
• Internal Level
• Mapping
• Advantages of the Architecture
• How Does the Application Program Access the Database
• Distributed Processing & Architectural Design
• Data Independence
• Data Models
• Data Models Definition
• Categories of Data Models
• Who Deals with Database
• Database Administrator
• System Analyst
• Database Designer
• Application Programmer
• End User
• Entity-Relationship Model
• Basic Concepts
• Entities
• Keys
• Design Issues
• Entity-Relationship Diagram
• Weak Entity Sets
• Design of an E-R Database Schema
• Reduction of an E-R Schema to Tables
• Relational Database Design Using ER-to-Relational Mapping
• Secuirty
• Introduction
• DCL
• Grant / Revoke
• SQL- The Relational Database Standard Language
• Data Definition, Constraints
• Basic Queries in SQL
• More Complex SQL Queries
• Insert, Delete and Update Statements in SQL
• Views (Virtual Tables) in SQL
• Indexes
• System Catalog
• Embedded SQL
• Normalization
• Functional Dependencies
• First Normal Form
• General Definitions of Second and Third Normal Forms

None