Question

Child
ID
DOB
Gender Group
109
First Last
Name Name
Vedansh Gupta
Mack Tyagi
30/06/10
2A
214
09/12/08
1B
115
Aditi
Thakur
13/04/09
1A
108
Vikrant
Chauhan 02/02/09
ζ η η ζ η ζζ
2A
141
Swati
Saini
06/05/10
2B
233
01/08/10
3A
Vishakha Tyagi
Madhur Gupta
274
06/03/10
ЗВ
a.
State the number of fields and records in the above table.
b. Give one reason why Summer_Camp table would need to add a need to add a new record​

Answer 1

Answer:

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.Read more on Sarthaks.com - https://www.sarthaks.com/125793/following-table-named-summercamp-shows-part-information-children-attending-summer-shimla