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

