: EmpId : Each employee is identified by a unique data value called EmpId, which in turn gets reflected in employee table as a column to store for each employee record a unique identification value. The data type of this column is text with field size equal to . Being a column to store unique values and also because of its capability to identify an employee record, it is designated as primary key field. Its Required property is set to Yes and Zero length property is set to No with Indexed property as Yes (No Duplicates).
Fname : This column refers to the first name of employee and its data type is declared as Text because it is meant to store string of alphabets. Its Field size is set to on the assumption that first name of every employee can be completely accommodated within this field size. The Required property is set to Yes with Zero Length Property being No to imply that every employee has a first name and no employee record can be stored unless the first name is also stored. Mname : Mname column is meant to store the middle name of an employee.
It data type is declared as text with field width equal to . The Required Property can be set to No and Zero Length property to Yes to imply that many employees may not have middle name. Therefore, the storing of value in this field becomes optional. Lname : Lname column has been included in the table structure to store the Last name of an employee.
The data type of this column is Text with field size set to . The Required Property can be set to No and Allow Zero Length property to Yes for the reason which applies to Mname. PhoneNo : This column is meant to store the Phone number of the employee and its data type is set to Text with field size equal to . The Required property is set to No with Allow Zero Length property set to Yes to imply that null values are permitted