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

