The data type of this field and other properties must be identical to that of EmpId, except that its Indexed property must be set to No . This column as per design is expected to refer to EmpId column of Employees table and therefore must be defined as foreign key. Its relationship with EmpId column of Employees table must also be specified to ensure referential integrity. AuthBy : This column is meant to store the identity of the employee who has authorised the vouchers.
This column is similar to PrepBy column. Therefore, its data type, properties and relationship with EmpId are the same as those for PrepBy column. Support : This table is created to store the details of support documents annexed to a voucher. It is designed to have the following four columns: vNo : This column is meant to store the voucher number to which this document is annexed.
Its data type should be the same as that of Vno in Vouchers table because this column refers to Vno column of Vouchers table to maintain referential integrity. Its value cannot be null and therefore its Allow Zero Length property must be set to No with Required Property being Yes . Since there may be more than one support documents annexed to a voucher, the values stored in this column cannot be unique and therefore this column alone cannot be a primary key field. sNo : This column has been included in the table structure to store serial numbers , , … to correspond to the serial number of documents being annexed.
Duplicate values will occur in this field also because the serial number of documents across the vouchers shall be the same. However, both the columns: Svno and Sno together provide a unique value because the documents, for every voucher are serially numbered and therefore unique. Both the columns together need be declared as Primary key of this table. dName : This column refers to Document name.
Its data type is Text with field size equal to to mean that within this character limit the document name can