Pronita is a programmer in an institution and is asked to handle the r

1.	Pronita is a programmer in an institution and is asked to handle the records containing personal information of the teachers teaching in the institution. Use the information to give the answer of the following questions (1) to (3). 1. Suggest five held names, which you think must be present in the table Teacherlnfo and why? 2. Give the data type of the suggested fields. 3. Which held is most likely to be the key field and why?
Answer» Suggested five fields are as follows: 1. TCode —> To store the code of the teachers. TName —> To store the name of the teachers. TSubject —> To store the name of subjects for which the teacher is placed in the institution. Address —> To store the address of the teachers. Salary —> To store the monthly income of the teachers. 2. TCode —> Text TName —> Text TSubject —> Text Address —> Text Salary —> Number 3. TCode is most likely to be the key field because it has a unique value for each of the records.

Pronita is a programmer in an institution and is asked to handle the records containing personal information of the teachers teaching in the institution. Use the information to give the answer of the following questions (1) to (3). 1. Suggest five held names, which you think must be present in the table Teacherlnfo and why? 2. Give the data type of the suggested fields. 3. Which held is most likely to be the key field and why?

Answer»

Suggested five fields are as follows:

1. TCode —> To store the code of the teachers.

TName —> To store the name of the teachers.

TSubject —> To store the name of subjects for which the teacher is placed in the institution.

Address —> To store the address of the teachers.

Salary —> To store the monthly income of the teachers.

2. TCode —> Text

TName —> Text

TSubject —> Text

Address —> Text

Salary —> Number

3. TCode is most likely to be the key field because it has a unique value for each of the records.