March 12th, 2010

Relational Model

Posted by admin in B. SQL Basics

The relational data model retrieves information from a collection of tables and returns that information to the user as one table. Just use the table name(s) to get the table(s) that you want. Relationships between data contained in multiple tables is done by matching data values.

The relational model of data was refined in 1969-1970 by Dr. E.F. Codd. His Relational DataBase Management System (RDBMS) consisted of:

No database system supports the relational model completely, but most implementations are a close match. All data is represented in a two-dimensional table and, for that reason, it is very easy to work with. All data is in tables including the application data tables, index tables, database and creation information, control and security, table statistics, program SQL statements, etc. All but the program SQL statements may be retained by you using SQL SELECT statements so that you can see how the database works.SELECT statements so that you can see how the database works.

One Response to ' Relational Model '

Subscribe to comments with RSS or TrackBack to ' Relational Model '.

  1. GORDON said,
    on September 7th, 2010 at 7:38 pm


    CheapTabletsOnline.com. Canadian Health&Care.Best quality drugs.No prescription online pharmacy.Special Internet Prices. Online Pharmacy. Buy pills online

    Buy:100% Pure Okinawan Coral Calcium.Valtrex.Lumigan.Synthroid.Nexium.Petcam (Metacam) Oral Suspension.Prednisolone.Retin-A.Human Growth Hormone.Actos.Arimidex.Zyban.Zovirax.Accutane.Mega Hoodia.Prevacid….

Leave a reply

:mrgreen: :neutral: :twisted: :shock: :smile: :???: :cool: :evil: :grin: :oops: :razz: :roll: :wink: :cry: :eek: :lol: :mad: :sad: