Course Objectives
The course gives basic information about SQL statements, functions, queries and data manipulation, in addition to PL/SQL statements, composite data types and exceptions
Prerequisites
None Requisites for MySQL
Course Outline
- 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
Course Duration
- Lectures: 15 Hours.
- Lab: 12 Hours.
Hardware Requirements
P IV 1000 1 GB RAM
Assessment
- Lab Assignments: 40 %
- Exam: 60 %