Page 275 - Trackpad 402_Class-X_Final
P. 275

The list of the field properties available for Numeric Data types are:
            •  AutoValue: Its auto increment numeric unique value that is automatically inserted in the field when a new record is
              added into a table. In most of the cases it's the primary key of the table. The user cannot enter data in the field that
              is assigned as AutoValue. It has the drop-down that contains “Yes”.
            •  Length: It defines the maximum length a field can have to hold a value. This option is not allowed to modify when
              the Auto Value property is set to “Yes”. For example, the field “Section” should be only single alphabet, the Length
              of the field can be “1”.
            •  Default Value: It’s the default value that can be assigned in the field. While data entry user can make a change in it.
              For Example the field “Marks”, can be assigned a default value 30. This option will not be available, when the Auto
              Value property is “Yes”.
            •  Decimal Places: It specify the number of decimal places in a numeric field. For example, if you fix decimal places as
              2 for salary then you are allowed to enter salary as 3456.78.
            •  Format Example: It allows the user to change how the data in a field will be displayed in the Table Data View.
            The list of the field properties available for Character Data types are:
            •  Length: It defines the maximum length a field can have to hold a value. For example, the field “Section” should be
              only single alphabet, the Length of the field can be “1”.
            •  Entry Required: The field with Entry Required as “Yes” means that the field cannot be left blank. The user needs to
              enter data in this field. It contains a drop-down “Yes”/“No”. The default value for this property is “NO” which means
              the field if left blank will contain a NULL(empty/nothing) value.
            •  Default Value: It's the default value that can be assigned in the field. This value gets automatically added in a field
              at the time of adding a record in a table. The user if want can make a change in it. For example the field “Title”, can
              be assigned a default value “Ms”.
            •  Format Example: It allows the user to change how the data in a field will be displayed in the Table Data View.



                    DATA TYPES IN DATABASE

            Data types help you define the type of the data that can be stored in a field/ column. Data types in OpenOffice Base
            are broadly classified into five main categories, which are as follows:

            Numeric Types

            The numeric data types are used to store data in the form of numbers which can be integers or numbers with decimals.
            Arithmetic operations can be performed on numeric data.
            We can use these data types for creating fields like RollNo, Phone number, Marks, Year of Joining, Salary, Cost, Amount
            or any other numeric value.

            The list of available numeric types is:

                       Data Type                Name                             Description

                  Yes/No                BOOLEAN                Values as 0 or 1. Example: True or False, Yes or No.
                  Tiny Integer          TINYINT                Store integer range between 0 to 255

                                                                                                  15
                                                                                           15
                  Small Integer         SMALLINT               Store integer range between -2  to + 2 -1
                                                                                                  31
                                                                                           31
                  Integer               INTEGER                Store integer range between -2  to + 2 -1
                                                                               63
                                                                                      63
                  Big Integer           BIGINT                 Range between -2  to + 2 -1

                                                                                   Database  Management System  275
   270   271   272   273   274   275   276   277   278   279   280