Page 302 - TP_IT_V1.0_C10_flipbpookl
P. 302

Table: PRODUCT
                             PID         PRODUCTNAME       MANUFACTURER            PRICE         EXPIRYDATE

                            TP01         Talcum Powder            LAK               40           2011-06-26
                            FW05           Face Wash             ABC                45           2010-12-01
                            BS01            Bath Soap            ABC                55           2010-09-10
                            SH06            Shampoo               XYZ               120          2012-04-09
                            FW12           Face Wash              XYZ               95           2010-08-15

                                                            Table: CLIENT

                                      CID            CLIENTNAME            CITY             PID
                                       1            Cosmetic Shop          Delhi           FW05
                                       6             Total Health        Mumbai             BS01
                                       12              Live Life           Delhi            SH06
                                       15             Pretty One           Delhi           FW05
                                       16              Dreams           Bengaluru           TP01

                                       14             Expressions          Delhi            NULL
              Primary Key: PRODUCT- PID
                           CLIENT - CID
                           PID is a foreign key in the CLIENT table
              In the above table PRODUCT, the primary key is PID. In table CLIENT, the primary key is CID. The relationship between
              PRODUCT and CLIENT is made because of the presence of a common field PID. So PID is a Primary key in table PRODUCT
              and a Foreign key in table CLIENT.

              Objects of a Database

              In a relational database management system, an object in a database is a structure or a feature that is used to store,
              represent or retrieve data. In fact, a database is a collection of these objects that work on multiple sets of data related to
              each other. These objects serve various purposes and play critical roles in organising, accessing, and managing the database
              efficiently. These objects are displayed in Database pane when you open LibreOffice Base window. These include:
              •  Tables: By default, Table Object is selected in the Database Pane. A table is the basic unit of any DBMS. It is a structured
                collection of data organised into rows and columns, forming a grid-like structure. Each row represents a single record
                or entry in the database, while each column represents a specific attribute or field pertaining to that record. Tables
                provide a logical and efficient way to organise data, enabling users to store, retrieve, and manipulate information with
                ease. They serve as the primary building blocks upon which the entire database is formed.
              •  Queries: Queries are powerful tools within an RDBMS that allow users to extract, manipulate, and analyse data
                stored in the database. Queries allow users to obtain the precise information they need for various purposes, such
                as reporting, analysis, or application development.
              •  Forms: A form is a feature of a database using which we can enter data in a table in an easy and user-friendly
                manner. They provide a user-friendly way to facilitate the input, editing, and viewing of data within an RDBMS with
                the help of graphical elements such as text boxes, drop-down menus, checkboxes, and buttons.

              •  Reports: Reports are formatted presentations of data generated from a database. They take raw data and turn it
                into a structured, easy-to-understand format. The output of a query may be displayed in the form of reports with
                data arranged in the form of rows and columns. But if we want the report to be formal and in proper layout, then
                we can use the Reports feature of RDBMS.

                300   Trackpad Information Technology (Ver. 1.0)-X
   297   298   299   300   301   302   303   304   305   306   307