• Home
  • Archive
  • Tools
  • Contact Us

The Customize Windows

Technology Journal

  • Cloud Computing
  • Computer
  • Digital Photography
  • Windows 7
  • Archive
  • Cloud Computing
  • Virtualization
  • Computer and Internet
  • Digital Photography
  • Android
  • Sysadmin
  • Electronics
  • Big Data
  • Virtualization
  • Downloads
  • Web Development
  • Apple
  • Android
Advertisement
You are here:Home » Relational Model : Outline

By Abhishek Ghosh April 21, 2013 5:01 pm Updated on April 21, 2013

Relational Model : Outline

Advertisement

Relational Model is a data model based on predicate logic and the theory of sets. Relational Model is most commonly used today to manage data dynamically. Edgar Frank Codd discovered it and IBM laboratory in San Jose, California; quickly established it as a new paradigm in the database models. The basic idea is the use of “relationships”. These relationships may be logically considered as sets of data called “tuples”. Although this is the theory of relational databases was created by Edgar Frank Codd , most of the time it is conceptualized in a more easy to imagine, that is, thinking in every relationship as if they were a table which consists of records and columns (also called fields).

 

Description of Relational Model

 

In Relational Model, all data is stored in relations and as every relationship is within a set of data, the order in which they are stored is not relevant (unlike other models such as the hierarchical and the network model). This has the considerable advantage that it is easier to understand and use by a non-expert user. The information can be retrieved or stored by means of queries that provide broad flexibility and power to manage information.

This model considers the database as a collection of relations. Simply, a relation is a table that is more than a set of rows, each row is a set of fields and each field represents a value that describes the real world. Each row also be called tuple or record and each column also can be called field or attribute.

Advertisement

---

To manipulate the information we use a relational language, currently has two formal languages ??are the Relational Algebra and Relational Calculus. Relational algebra describe how to perform a query, however, relational calculus indicates what you want to return.

 

Outline and Instance of Relational Model

 

A schema contains the definition of a structure (usually relationships or tables in a database), that is, it determines the identity of the relationship and what kind of information can be stored within it, in other words, the schema contains the metadata relationship. Any scheme will consist of:

  • Name of the relationship (their ID).
  • Name of the attributes (or fields) of the relationship and their domains, the domain of an attribute or field defines the allowed values ??for the same, equivalent datatype e.g. character, integer, date, string etc.

 

An instance is formally applying a schema to a finite set of data. In technical words it can be defined as the content of a table in a given time, but it is also valid to refer to an instance when working or to show only a subset of the information contained in a relation or table, for example:

  • Certain characters and numbers (a single column of a single row).
  • Some or all rows with all or some columns Each row is a tuple.
  • The number of rows is called cardinality.
  • The number of columns is called arity or degree.

 

Relational Database

 

Relational Model

 
A relational database is a set of one or more tables structured in records (rows) and fields (columns) those are linked together by a common field in both cases, they have the same characteristics such as field name, type and length; this field is usually called ID, ID or password. A way to build this database is called relational model. [ Suggested Reading : What is a Database, How it Works ]

Strictly speaking the term refers to a specific collection of data, but it is often used in the wrong way as a synonym of the software used to manage the data collection. This software is known as DBMS ( database management system data ) or relational RDBMS (relational database management).

 

Practical Example of Relational Database with Visualization

 

MySQL is a RDMS. But actually we can not see the imagined theoretical relational model via command line interface. That is why we use PHPMyAdmin.

 

Abhishek-GhoshOutline and Instance of Relational Model

Tagged With in the relational model a field is called
Facebook Twitter Pinterest

Abhishek Ghosh

About Abhishek Ghosh

Abhishek Ghosh is a Businessman, Surgeon, Author and Blogger. You can keep touch with him on Twitter - @AbhishekCTRL.

Here’s what we’ve got for you which might like :

Articles Related to Relational Model : Outline

  • Nginx WordPress Installation Guide (All Steps)

    This is a Full Nginx WordPress Installation Guide With All the Steps, Including Some Optimization and Setup Which is Compatible With WordPress DOT ORG Example Settings For Nginx.

  • Changing Data With cURL for OpenStack Swift (HP Cloud CDN)

    Changing Data With cURL For Object is Quite Easy in OpenStack Swift. Here Are Examples With HP Cloud CDN To Make it Clear. Official Examples Are Bad.

  • WordPress & PHP : Different AdSense Units on Mobile Devices

    Here is How To Serve Different AdSense Units on Mobile Devices on WordPress With PHP. WordPress Has Function Which Can Be Used In Free Way.

  • Theoretical Foundations of Big Data : Part 3

    Theoretical Foundations of Big Data is third and final part of our series of articles. We have talked about Data Mining, OLAP & softwares.

performing a search on this website can help you. Also, we have YouTube Videos.

Take The Conversation Further ...

We'd love to know your thoughts on this article.
Meet the Author over on Twitter to join the conversation right now!

If you want to Advertise on our Article or want a Sponsored Article, you are invited to Contact us.

Contact Us

Subscribe To Our Free Newsletter

Get new posts by email:

Please Confirm the Subscription When Approval Email Will Arrive in Your Email Inbox as Second Step.

Search this website…

 

Popular Articles

Our Homepage is best place to find popular articles!

Here Are Some Good to Read Articles :

  • Cloud Computing Service Models
  • What is Cloud Computing?
  • Cloud Computing and Social Networks in Mobile Space
  • ARM Processor Architecture
  • What Camera Mode to Choose
  • Indispensable MySQL queries for custom fields in WordPress
  • Windows 7 Speech Recognition Scripting Related Tutorials

Social Networks

  • Pinterest (24.3K Followers)
  • Twitter (5.8k Followers)
  • Facebook (5.7k Followers)
  • LinkedIn (3.7k Followers)
  • YouTube (1.3k Followers)
  • GitHub (Repository)
  • GitHub (Gists)
Looking to publish sponsored article on our website?

Contact us

Recent Posts

  • Affordable Earphone/IEM for Audiophiles: HiFiMan RE-400 WaterlineOctober 2, 2023
  • What is Hardware Security Module (HSM)September 30, 2023
  • Transducer Technologies of HeadphonesSeptember 28, 2023
  • What is Analog-to-Digital Converter (ADC)September 27, 2023
  • Comparison of Tube Amplifiers and SemiconductorsSeptember 26, 2023
PC users can consult Corrine Chorney for Security.

Want to know more about us?

Read Notability and Mentions & Our Setup.

Copyright © 2023 - The Customize Windows | dESIGNed by The Customize Windows

Copyright  · Privacy Policy  · Advertising Policy  · Terms of Service  · Refund Policy