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.
   32   33   34   35   36   37   38   39   40   41   42