Page 224 - IT_V1.0_Class10
P. 224

  Field Name: A field name is the identifier of a field as it contains the data that is to be stored in
                         that field. Generally, it represents a particular property of the table entity. For example, in a table
                         of student record, ‘STU_NAME’ field describes the name and ‘DOB’ field describes the date of
                         birth of the student. In simple words, it is the name of the column. For convenience, a field name
                         should denote the contents of that field. Field name can consist of letters, numbers and some
                         special characters like period (.), exclamation (!), single apostrophe (’), square brackets ( [ ] ), etc. If
                         a field name consists of more than two words, then join them by underscore sign ( _ ).

                        Field Type: This option allows you to specify the data type for each field.
                        Description: The description field is optional though it is a good practice to give field description
                         so that any person other than the programmer can understand the purpose of the field.

                        Field Properties: Field properties control how data is handled in a database. In LibreOffice Base,
                         these include:
                            Entry Required: Ensures the field cannot be left blank.

                            Auto Value: Automatically generates incrementing values for new records.
                            Length: Specifies the maximum number of characters or digits the field can hold.

                            Default Value: Sets a predefined value for new records in the field.
                            Format: Defines how the data is displayed, including format and alignment options.

              Step 2:  Type a name for the field in the Field Name column.
              Step 3:  Select the data type from the drop-down list in the Field Type column.




                       2                           3










                                                                                                                   4


                                                                                                 Field Description
                  Field                                Field Name
                Properties
                                                         Field Type

              Step 4:  Mention the details of the field in the Description column.
              Similarly, you can add more fields in the table.

              Consider the following points while creating a table:
                In a table, each field should have a unique name. No two fields in a table can have an identical name.
                Each field should be predefined with data type that identifies the type of data to be entered in  that field.

                A special field that uniquely identifies a record in a table is called primary key. In primary key column, no
                 two records can be identical, for example, in your class, two students cannot have the same roll number
                 even if their names are same.




                222     Information Technology Play (Ver 1.0)-X
   219   220   221   222   223   224   225   226   227   228   229