MySQL is a relational database management system based on the Structured Query
Language, which is the popular language for accessing and managing the records
in the database. MySQL is open-source and free software. It is supported
by Oracle Company.Database is a collection of related data and data is a collection of facts and figures
that can be processed to produce information.
Mostly data represents recordable facts. Data aids in producing information, which
is based on facts. For example, if we have data about marks obtained by all
students, we can then conclude about toppers and average marks.
A database management system stores data in such a way that it becomes easier
to retrieve, manipulate, and produce information.
Some basic points about Database
Database − A database is a collection of tables, with related data.
Table − A table is a matrix with data. A table in a database looks like a
simple spreadsheet.
Column − One column (data element) contains data of one and the same
kind, for example the column postcode.
Row − A row (= tuple, entry or record) is a group of related data, for
example the data of one subscription.
Primary Key − A primary key is unique. A key value can not occur twice in
one table. With a key, you can only find one row.
Foreign Key − A foreign key is the linking pin between two tables.