• 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

This Article Has Been Shared 173 Times!

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

  • XWidget : What it is and What are the possibilities

    XWidget is a free platform to Customize Windows. XWidget has powerful visual widget editor and lot of excellent widgets are available.

  • Facial Recognition : In Softwares and Living Creatures

    Facial Recognition is an important and interesting feature of many animals and simulated Facial Recognition done by the softwares to detect One from others.

  • Computational Complexity Theory : Basics

    Computational complexity theory theoretically deals with problems to be treated in mathematically defined computer models,like use of resources or storage space.

  • Neuroprosthetics and Modeling of Neurons

    Neuroprosthetics and Modeling of Neurons is the next generation thought to make the human life more better gathering the knowledge of Neuroscience, Computing.

  • RISC or Reduced Instruction Set Computing

    RISC or Reduced Instruction Set Computing is a type of design of Central Processing Unit which are generally used in microprocessors or microcontrollers.

Additionally, 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

  • What is Voice User Interface (VUI) January 31, 2023
  • Proxy Server: Design Pattern in Programming January 30, 2023
  • Cyberpunk Aesthetics: What’s in it Special January 27, 2023
  • How to Do Electrical Layout Plan for Adding Smart Switches January 26, 2023
  • What is a Data Mesh? January 25, 2023

About This Article

Cite this article as: Abhishek Ghosh, "Relational Model : Outline," in The Customize Windows, April 21, 2013, February 1, 2023, https://thecustomizewindows.com/2013/04/relational-model-outline/.

Source:The Customize Windows, JiMA.in

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

We use cookies on our website to give you the most relevant experience by remembering your preferences and repeat visits. By clicking “Accept”, you consent to the use of ALL the cookies.
Do not sell my personal information.
Cookie SettingsAccept
Manage consent

Privacy Overview

This website uses cookies to improve your experience while you navigate through the website. Out of these, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may affect your browsing experience.
Necessary
Always Enabled
Necessary cookies are absolutely essential for the website to function properly. These cookies ensure basic functionalities and security features of the website, anonymously.
CookieDurationDescription
cookielawinfo-checkbox-analytics11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Analytics".
cookielawinfo-checkbox-functional11 monthsThe cookie is set by GDPR cookie consent to record the user consent for the cookies in the category "Functional".
cookielawinfo-checkbox-necessary11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookies is used to store the user consent for the cookies in the category "Necessary".
cookielawinfo-checkbox-others11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Other.
cookielawinfo-checkbox-performance11 monthsThis cookie is set by GDPR Cookie Consent plugin. The cookie is used to store the user consent for the cookies in the category "Performance".
viewed_cookie_policy11 monthsThe cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. It does not store any personal data.
Functional
Functional cookies help to perform certain functionalities like sharing the content of the website on social media platforms, collect feedbacks, and other third-party features.
Performance
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Analytics
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Advertisement
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Others
Other uncategorized cookies are those that are being analyzed and have not been classified into a category as yet.
SAVE & ACCEPT