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
   373   374   375   376   377   378   379   380   381   382   383