Please download there very simple to understand PDF Documents by topic which we will be referring to them in our practice session. If you have printer , please print them instead of just reading them electronically.

Chapter 1: Introduction

Relational database systems have become increasingly popular single the late 1970's. They offer a powerful method for storing data in an application-independent manner. This means for many enterprises the database is at the core of the I.T. strategy. Developments can progress around a relatively stable database structure which is secure, reliable, efficient, and transparent.

Download this Tutorial

Follow the links for details explanation. Please do so after you complete going through the tutorial from the above link.

• The Database Approach
• User Types
• Database Architecture
  • External View
  • Conceptual View
  • Internal View
  • Mappings
• DBMS
• Database Administrator
• Facilities and Limitations
  • Data Independence
• Data Redundancy
• Data Integrity

Chapter 2 - Database Analysis

Basic database analysis techniques, Entity Relationship modelling, and mapping ER diagrams to relations.

2. A. Database Analysis : Download Tutorial Slides : PDF

Please read in detail after you complete the above PDF Tutorial.

2. B. Mapping ER Models into Relations : Download Tutorial Slides : PDF

In this section you will learn How to construct an ER model, understand the problems associated with ER models and understand the modelling concepts of Enhanced ER modelling.

Please read in detail after you complete the above PDF Tutorial.

• Country Bus Company
• Entities
• Relationships
• Draw E-R Diagram
• Attributes
• Problems with ER Models
• Fan traps
• Chasm traps
• Enhanced ER Models (EER)
• Specialisation
• Generalisation