Suppose the principal of the school has decided to award scholarship to some needy students for which income of the guardian must be known. But school has not maintained income attribute with table GUARDIAN so far. Therefore, the database designer now needs to add a new attribute ‘income’ of data type INT in the table GUARDIAN.

SQL is an abbreviation for the term Structure Query Language. It is a type of database query language (DQL) that is primarily used for storing data and managing it in the Relational DBMS. This language was the first commercial language introduced for the Relational model of the database by E.

Basically, SQL is a language that is used to manage data that's held in a relational database management system. It uses tables to both manipulate and retrieve information from databases for analysis.