In this article, I will try to demonstrate what a relational database is, and how to properly design your database to store informations in it.
A database stores data in an organized way so that it can be searched and retreived later. A database is collection of one or more tables. Table is much like an excel spreadsheet, in that it’s made up of rows and columns. All rows have the same column, and each column contains the data itself.
Term relational comes from mathematical relations, tables are connected in relation and you can retreive information from more tables at once.
Relational databases are created using a special computer language, structured query language (SQL), that is the standard for database interoperability.
Structure of Database
Most important thing that we need to know is that database is collection of tables. Tables are made by columns and rows. Each row has same columns and each column contains the data itself.
As I mention tables are created from column and rows. Each column has it own data type. With the help of the columns you can make relation of two tables in the database. Relations are used to search from one table to another or merge information in another table.
From the above figure you can have good point of what really database is. The figure is one table in database which have four columns and three rows. Speaking in detail four columns are name, email, birthdate and city, while rows are horizontally and each column contain the data itself. For example data in column name and row one is “Bujar Ademi“.
By this we can agreed that database is collection of tables and their relation. To summarize this part relational databases as I said early are created using a special computer language, structure query language (SQL). SQL is the foundation for all of the popular database applications available today, from Access, SQL Server to Oracle.