Exforsys.com
 
Home Tech Articles PL SQL
 

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.


Download this Tutorial

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.


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.



2. C. Mapping ER Models into Relations : Download Tutorial Slides : PDF 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.


2. D. Advanced ER Mapping : Download Tutorial Slides : PDF 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.

Read Next: Practice Oracle SQL*Plus Live - Part 3



 

 

Comments


said:

  Couldn't download these tutorials. someone help me please!
June 10, 2009, 2:58 pm

Post Your Comment:

Members Please Login
Your Name:*
e-mail ID:(required for notification)*
Image Verification: 
 
 Subscribe    

Sponsored Links

 

Subscribe via RSS


Get Daily Updates via Subscribe to Exforsys Free Training via email


Get Latest Free Training Updates delivered directly to your Inbox...

Enter your email address:


 

Subscribe to Exforsys Free Training via RSS
 

 
Partners -  Privacy and Legal Policy -  Site News -  Contact   Sitemap  

Copyright © 2000 - 2009 exforsys.com. All Rights Reserved

Page copy protected against web site content infringement by Copyscape