There are two types of database structures. Although it is a quite small table as shown the columns consist of attributes of data and the rows consist of data stored corresponding to these attributes.įigure 1 Example of a table in Relational Database How do relational databases work? Following is an example of a relational database. The rows consist of records that exist corresponding to a unique identification number which is called a key.
The columns in this table consist of the attributes or characteristics of data on which the data is categorized. A relational database is based on a relational model which is a pretty simple model in which the data is stored in the form of tables consisting of rows and columns. This makes it easier to depict the data and data handling is made easier when it is arranged in tables. Relational DatabaseĪ relational database can be considered as a table in which the categories of data are stored in columns and the data is stored in rows. So before understanding the working of SQL we will first have to understand how relational databases work. SQL is mainly used on relational databases. In order to understand how SQL works first, we have to understand the median on which it is used. SQL is used to access the data in these tables, query it, modify it, delete it, or use it for our own analysis. In rows, the data is stored and the rows are called table records. In columns, there are different characteristics on which the data is categorized. In these tables, there is a set of rows and columns. A relational database is a type of database in which the data is stored in the form of tables. Most commonly SQL is used to work with relational databases. SQL is an acronym for Structured Query Language and it is a programming language that is used to work with databases. On what principles does it work and what is its history? SQL In this article, we will discuss what is SQL? And what part is it playing in shaping business in today’s world? In order to understand this first, we need to understand what is the need for SQL and how it works.
0 kommentar(er)
