Exforsys.com
 
Home Tech Articles PL SQL
 

Data Modeling Overview Tutorial

 
Before we start learning Oracle , it's very important that you understand the Relational Database Concepts and Data Modeling concepts. Please go through this very good tutorial to get an overview. Data Modeling Overview: A data model is a plan for building a database. To be effective, it must be simple enough to communicate to the end user the data structure required by the database

yet detailed enough for the database design to use to create the physical structure. A data model is a conceptual representation of the data structures that are required by a database. The data structures include the data objects, the associations between data objects, and the rules which govern operations on the objects. As the name implies, the data model focuses on what data is required and how it should be organized rather than what operations will be performed on the data. To use a common analogy, the data model is equivalent to an architect's building plans.

A data model is independent of hardware or software constraints. Rather than try to represent the data as a database would see it, the data model focuses on representing the data as the user sees it in the "real world". It serves as a bridge between the concepts that make up real-world events and processes and the physical representation of those concepts in a database.

Data Modeling





 

 

Comments


joydeep_rays said:

  please clarify:
ORA-00600: INTERNAL ERROR CODE, ARGUMENTS: [4194],[51],[61],[ ],[ ],[ ],[ ],[ ]
I AM facing this problem in my server.
Joydeep
October 17, 2005, 2:26 am

Mohammed Abdul Afroze said:

  Hi All,

This internal error code is nothing but the files related to the db had been corrupted.So,the best solution for this,trace the controlfile at mount stage in sql prompt.And check the process id by giving the command !ps -x in sql prompt.Goto udump directory and copy that trace file to $HOME.shut down ur db and take the bkup of control file and remove the controlfile.Go to trace file and set the set-1 with noresetlogs option.And run that script. in sql prompt.And open the db normally.Simply we can say that tuning the db.
October 13, 2006, 9:00 am

chaudharyshamraiz said:

  plz any one can mail me the complete tutorial of sql/sql* in my mail address which is chaudharyshamraiz@gmail.com
thanks
December 24, 2006, 2:31 am

gbolu said:

  plz any one can mail me the complete tutorial of sql/sql* in my mail address which is chaudharyshamraiz@gmail.comThis email address is being protected from spam bots, you need Javascript enabled to view it
thanks.
February 4, 2007, 12:34 pm

hrishi said:

  Can any one mail the complete tutorial of sql/,sql as I wanted to take certification .
Thank you very much
April 3, 2007, 2:22 pm

ramya298 said:

  can anyone please help me the procedure for taking oracle certification?please email me at ramya298@rediffmail.com
April 11, 2007, 7:16 pm

Nikki007 said:

  I would like to know about the oracle application in the area of clinical data management.
Can any body send me the total tutorial of introduction to oracle ?
IF any wishes it them mail me on nikki11842@gmail.com
June 29, 2007, 4:07 am

0 said:

  I would like to know about the Oracle Application in the area of Clinical Data Management. Can any body post the total tutorial of Oracle Clinical?
January 24, 2009, 8:51 am

satyan said:

  i am making a programming that show an error pl.any body help me
my code is
DECLARE
GRADE CHAR:='A';
BEGIN
CASE GRADE
WHEN 'A' THEN dbms_output.put_line('Excellent');
WHEN 'B' THEN dbms_output.put_line('Very Good');
WHEN 'C' THEN dbms_output.put_line('Good');
WHEN 'D' THEN dbms_output.put_line('Fair');
WHEN 'F' THEN dbms_output.put_line('Poor');
ELSE dbms_output.put_line('No such grade');
END CASE;
END;
/
ERROR at line 4:
ORA-06550: line 4, column 1:
PLS-00103: Encountered the symbol "CASE" when expecting one of the following:
begin declare exit for goto if loop mod null pragma raise
return select update while <an identifier>
<a double-quoted delimited-identifier> <a bind variable> <<
close current delete fetch lock insert open rollback
savepoint set sql execute commit forall
<a single-quoted SQL string>
January 27, 2009, 6:29 am

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