1. It is a structured query language used for accessing and manipulating database.
2. There are different types of commands used in SQL. They are: (DDL) Data-Definition Language; (DML) Data Manipulation Language; (DQL) Data-Query Language; (TCL) Transaction Control Language; (DCL) Data-Control Language;
3. It Retrieves data from database and executes queries against a database.

1. The process of creating, implementing and maintaining the enterprise data in a system is known as Designing of databases.
2. The performance and success of an application depends on good database design.
3. MySQL provides performance dashboard, reports and statistics regarding the designing of database.

1. The number of entity types involved is known as Degree of relationship
2. One - Unary, Two - Binary, Three - Ternary.
3. It also connects one entity to itself as a loop.

1. The table consists of several rows and columns.
2. Table can be divided into smaller parts, in terms of columns.
3. Each column is known as attributes. The attribute is defined in a table to hold values of same type.
4. This is known as Attribute Domain.

The featured of RDBMS are its:
(i) High Availability
(ii) High Performance
(iii) Robust Transactions and support
(iv) Ease of management
(v) Less cost

1. The Database Administrator (DBA) frequently uses few commands to control the entire database.
2. These commands are known as Administrative MySQL Commands.
3. USE Database, Show Databases, Show tables, etc, ... are the commands used by Database - Administrator.

1. A DBMS that manages the relational database is known as Relational Data Base Management System.
2. The basic RDBMS concept includes Database, Tables, Tuple, Attribute, Schema and Key that are discussed in RDBMS Jargons.
3. RDBMS is basis for SQL and for all modern database systems like MySQL, oracle and Microsoft Access.

(i) A database is a place where we store, retrieve and manage data.
(ii) Meaningful information like your name, your favorite color etc,... to complex data like astronomical data that scientist handle, everything comes under database.
(iii) In a database, we would be grouping only related data together and storing them under one group name called table.

Few major functions performed using SQL are listed below:
(i) Executes queries against a database.
(ii) Retrieves data from database.
(iii) Inserts and updates records in a database
(iv) Delete records from database
(v) Creates new databases and new tables in a database

(i)  A single entry in a table is called a Row or Record or Tuple.
(ii) Set of related data are represented in a row or tuple.
(iii) The horizontal entity in a table is known as a Record or row.

(i) MySQL is a database management system founded by Monty Widenius
(ii) MySQL is open source software that allows managing relational databases.
(iii) It also provides the flexibility of changing the source code as per the needs.
(iv) It runs on multiple platforms like Windows, Linux and is scalable, reliable and fast.

The three major parts that forms a database are Tables, Queries and Views.
(i) Tables - similar to an excel sheet, containing multiple rows and columns. Where each row is a record and each column is an attribute.
(ii) Queries - It is a question with multiple conditions posted to the database. The records in the database that satisfies the passed conditions are retrieved.
(iii) Views - A set of stored queries.

(i) Database Administrators (DBA's) who takes care of configuration, installation, performance, security and data backup.
(ii) DBA's possess the skills on database design, database queries, RDMS, SQL and networking.
(iii) The primary task is the creation of new user and providing them with access rights.

(i) DB2
(ii) MySQL
(iii) Oracle
(iv) PostgreSQL
(v) SQLite
(vi) SQL Server
(vii) Sybase

Write short note on Columns (attributes) in a table.
(i) The table consists of several rows and columns.
(ii) Table can be divided into smaller parts, in terms of columns.
(iii) Each column is known as attributes.
Example:
a. In the Employee table four attributes are available namely Id, Name, Age and Salary. The attribute is defined in a table to hold values of same type.
b. This is known as Attribute Domain.
c. In the Employee table, the Name field will hold only characters not the numbers in it.
(iv) The vertical entity in a table is known as Attribute or Column.