●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
●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.
●Redundancy − Storing data twice, redundantly to make the system faster.
●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.
●Compound Key − A compound key (composite key) is a key that consists of
multiple columns, because one column is not sufficiently unique.
●Index − An index in a database resembles an index at the back of a book.
●Referential Integrity − Referential Integrity makes sure that a foreign key value
always points to an existing row.
MySQL is a fast, easy-to-use RDBMS being used for many small and big businesses.
MySQL is developed, marketed and supported by MySQL AB, which is a Swedish
company. MySQL is becoming so popular because of many good reasons −
● MySQL is released under an open-source license. So you have nothing to pay to
● MySQL is a very powerful program in its own right. It handles a large subset of
the functionality of the most expensive and powerful database packages.
● MySQL uses a standard form of the well-known SQL data language.