|
Practice Oracle SQL*Plus Live - Part 2 |
|
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.
Follow the links for details explanation. Please do so after you complete going through the tutorial from the above link.
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.
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.
In this chapter you will learn how to map 1:1 relationships into relations, map 1:m relationships into relations map m:n relationships into relations,differences between mapping optional and mandatory relationships.
Please read in detail after you complete the above PDF Tutorial.
In this chapter you will learn How to map parallel relationships into relations,map unary relationships into relations and map superclasses and subclasses into relations
Please read in detail after you complete the above PDF Tutorial.
Trackback(0)
 |
TrackBack URI for this entry
Subscribe to this comment's feed
Show/Hide comments
Show/Hide comment form