Page 378 - TP_IT_V1.0_C10_flipbpookl
P. 378
Data Type Name Signed Description
31
31
Integer INTEGER Yes Store integer range between -2 to + 2 -1
63
63
Big Integer BIGINT Yes Range between -2 to + 2 -1
Number NUMERIC Yes Unlimited
Decimal DECIMAL Yes Unlimited
Real REAL Yes 5×e− 324 to 1.79×10 308
Float FLOAT Yes 5×e− 324 to 1.79×10 308
Double DOUBLE Yes 5×e− 324 to 1.79×10 308
Alphanumeric/Text Data Type
It stores a set of numbers, alphabets or other characters. No arithmetic calculations can be performed on text data. We can
use this data type for creating name, address, city, customer name, product name, product description, etc.
The list of available Alphanumeric/ Text Data type is:
Data Type Name Description
Memo LONGVARCHAR Store up to the max length or number indicated by user. It is
used to store some descriptive data having more than 255
characters. Memo data type allows to store text data up to 64000
characters. For example: Medical description of a patient, Student
achievement details in student table.
Text (fix) CHAR Store exactly the length specified by user. It is used to store fixed
number of characters. For example: Mobile number, Pincode,
License Number, Passport Number, etc.
Text VARCHAR Store up to the specified length. The number of bytes allocated
depends on the number of characters. For example if Name in
student table is VARCHAR(20) and you save name as “Vedika”
which has 7 characters then only 7 bytes out of 20 will be used.
Text VARCHAR_ Store up the specified length. Comparisons are not case sensitive
IGNORECASE but stores capitals as you type them.
8. List down the objects of a database.
Ans. Some common objects in a database include:
● Tables: 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: Forms serve as user interfaces that facilitate the input, editing, and viewing of data within an RDBMS. They
provide a user-friendly way to interact with the database, allowing users to input data through graphical elements such
as text boxes, drop-down menus, checkboxes, and buttons.
• Reports: Reports are formatted presentations of data generated from the database, typically in the form of structured
documents or visual representations. They provide a concise and meaningful summary of information derived from the
underlying data, often organised into tables, charts, graphs, or narratives.
376 Trackpad Information Technology (Ver. 1.0)-X

