Beginner's Guide to Databases
The questions and answers discussed at the beginning of the video are as follows:
What is database?
A database is a collection of inter-related data having properties which define the data.
What is DBMS?
DBMS = Database Management System
It is a software tool which is used to manage databases.
What is table?
Relational Model.It is a unit of data in relational model of databases and is made up of rows and columns.
What is record?
It is a row of data in a table. It is also known as tuple.
What is an attribute?It is a column of values in a table. It is also known as feature.
What is degree?
Degree = number of columns in a table
What is cardinality?
Cardinality = number of rows in a table
What is data type?
It defines the type of data that can be handled by a particular column of a table.
What is primary key?
A collection of one or more columns which uniquely identify every row of a table in a database
What is query?
A question which is put forward to a database.
What is SEQUEL?
Programming language to answer queries from a user posed to a database is known as SEQUEL (SQL)
SEQUEL: Structured English Query Language
SQL: Structured Query Language