Database, Tables and Records

A relational database stores related information in tables. A table has named columns that define the structure and rows (records) that hold the data.

Table and record

A table combines a defined structure with records. For example, an employee table can store one row per employee and columns such as employee ID, name, department and joining date.

Database

A database groups related tables. A student-management database may contain separate student, marks and fee-payment tables that are linked by keys.

Users and privileges

Database accounts should receive only the privileges they need. For example, an HR application can be allowed to read or update HR tables without receiving access to unrelated marketing data.

Why use a database?

Compared with manually maintained files, a database provides structured storage, controlled concurrent access, querying, constraints, indexing, backup options and centralized authorization.

Subhendu Mohapatra

Author & Instructor at plus2net

I write and maintain practical tutorials on Python, PHP, SQL, JavaScript, HTML, jQuery, and web development at plus2net. The tutorials focus on clear explanations, working examples, and code that readers can test and adapt while learning.

About the author   Watch on YouTube

Connect: