The following table named SummerCamp shows part of the information kep

1.	The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla.Child IDFirst NameLast NameDOBGenderGroup109VedanshGupta30/06/10M2A214MackTyagi09/12/08M1B115AditiThakur13/04/09F1A108VikrantChauhan02/02/09M2A141SwatiSaini06/05/10F2B233VishakhaTyagi01/08/10F3A274MadhuGupta06/03/10M3B1. State the number of fields in’the above table.2. State the number of records in the above table.3. Give one reason why SummerCamp would add a record.4. Give one reason why SummerCamp would edit a record.5. Give one reason why SummerCamp would delete a record.6. Give any two data types used in the table.
Answer» 1. Number of fields-6 2. Number of records-7 3. If a new child joins the SummerCamp, then SummerCamp would add a record to the table. 4. If a child is shifted from one group to another, then SummerCamp would edit a record in the table. 5. If any child leaves the SummerCamp, then SummerCamp would delete a record of that child from the table. 6. Text and Date/Time.

The following table named SummerCamp shows part of the information kept on children attending the summer camp in Shimla.Child IDFirst NameLast NameDOBGenderGroup109VedanshGupta30/06/10M2A214MackTyagi09/12/08M1B115AditiThakur13/04/09F1A108VikrantChauhan02/02/09M2A141SwatiSaini06/05/10F2B233VishakhaTyagi01/08/10F3A274MadhuGupta06/03/10M3B1. State the number of fields in’the above table.2. State the number of records in the above table.3. Give one reason why SummerCamp would add a record.4. Give one reason why SummerCamp would edit a record.5. Give one reason why SummerCamp would delete a record.6. Give any two data types used in the table.

Answer»

1. Number of fields-6

2. Number of records-7

3. If a new child joins the SummerCamp, then SummerCamp would add a record to the table.

4. If a child is shifted from one group to another, then SummerCamp would edit a record in the table.

5. If any child leaves the SummerCamp, then SummerCamp would delete a record of that child from the table.

6. Text and Date/Time.