Database Basics

[last updated: 2021-05-10]
go to: databases
-----

• A DataBase is a collection of data (words and numbers),
  that is structured and organized to make it easy to enter and retrieve specific information.
  from: https://www3.ntu.edu.sg/home/ehchua/programming/sql/MySQL_Beginner.html
  A MySQL database server contains many databases (or schemas). Each database consists of one or more tables. A table is made up of columns (or fields) and rows (records).

• A DBMS is a database management system
  that handles interfacing (entering and retrieving data) with the database.
  mySQL is a DBMS.

• There are several different kinds of databases, but I'm limiting this to:
  Relational Databases (RDB), also called "SQL databases."
  • A RDB consists of tables, which are themselves composed of rows and columns.
  • Each row in the table is a Record, and the values in the columns are all related to the entity defined in the record.

.

.

.

eof