Storing Information

Information Overload

The Internet exists because there is information transferred from one computer to another but as there are billions of computers connected to the internet this becomes a many to many relationships( a data model at its core). You might have come across the term IoT(Internet of Things) which basically encompasses everything that is connected to the internet, systems that talk to each other. Information can be anything that exists in this world such as a persons identity(name, age, address) consists of data about that individual.
So we know that information can be transferred, but the information does not just appear out of nowhere, it has to be obtained and then stored somewhere, which is where Databases come into play.

SQL and DBMS

During my first and second module of my Software Engineering Bootcamp, we had a thorough insight into the Backend of Programming and how all the different components interact with each other.
DBMS stands for Database Management System, this is the software that captures then analyzes and stores the data. Our projects were in Active record which implements the object-relational mapping (ORM) pattern.
SQL stands for Standard Query Language and its what we had used to communicate with our Database.

SELECT column_name FROM table_name ORDER BY column_name ASC;

this is an example of SQL syntax e that can be applied to any table that is stored in your database. This specific code would be able to grab a column from your desired table and return the rows in order for the specified column.
This is just a small example of what SQL is capable of.
But just by seeing this, you should be able to grasp what you are capable of doing when you have multiple rows and columns of data, that you can process and present to the end-user. The same can be said when the opposite is done when information is gathered from the user or multiple end-user and the power someone would have with all that information, a lot of ethical issues.