Page 37 - TP_Prime_V2.2_Class8
P. 37
Terms Related to a Database
Data is stored in the table of a database, as shown in the below diagram.
FIELDS
Primary key (Reg No.) Student's Name Father’s Name Date of Birth Class
VIII
187/11
Mr. K.S. Kant
15/08/2007
Krishna Kant
RECORDS 156/12 Rishi Sharma Mr. N.K. Sharma 22/10/2008 IX WORKING WITH ACCESS 2016
Mr. G.S. Patel
Suraj Patel
194/11
IX
16/04/2008
123/12 Priyansh Sagar Mr. P.K. Sagar 18/06/2007 VIII
Table: Student's Detail
The commonly used terms of the relational database are:
• Table: Table is also known as Relation. It is a group of related data organised in
columns and rows in a database. The columns contain a number of headings such as Reg 35
No., Name, Father's Name, Date of Birth, Class, etc. These columns are also known
as a Fields. A set of values for the fields is called a Record. Each row in the table
represents one record.
• Primary Key: It is a unique field by which the records are uniquely identified in a
table. A table can have only one primary key. It ensures that each record can be
uniquely distinguished from others, preventing duplicate entries and maintaining data
integrity. For example, in a table 'Student's detail' the 'Reg No.' can be referred to
as primary key.
• Query: A query is one of the most powerful object of database. It allows you to retrieve
information from a table based on specific criteria or condition. By creating and executing
a query, you can efficiently find and access the data you need from the database. Queries
can be used to filter, sort and analyse data, making them essential for effective data
management and decision-making.
• Report: A report is a formatted presentation of data retrieved from a database, typically
generated from tables or queries. Reports are used to summarise, analyse, and present
information in a clear and organised manner for decision-making or review.
• Form: A form is a database object used to create a user-friendly interface for entering,
updating, and viewing records in a table that it is connected to. It allows users to interact
with the database without directly manipulating the table, making data entry and editing
easier. Additionally, it enables users to view records from the table one by one or in a
structured layout, depending on the form design.
If more than one fields are combined to form a primary key, then it
Fun
Fact! is called a composite key.

