Year 9 - ICT - 21-9-15

Thai Sikh International School

E-Learning Programme – Online Assignment –   21/09/2015

Name :                                                                                                                        Subject :  ICT

Year   :  9 A/B                                                                                                      Schedule No. :  02     

AdmnNo	Name	Class	Dateofadmission	Nationality
123	Deepa	10	5-10-1999	Indian
119	Mahesh	9	24-09-2000	Indian
345	Hari	8	11-11-1998	Indian

   a.       How many records and fields are there in this table?  

   b.      Which field can be suitable primary key ?      

   c.       What will be a suitable data type for each field ?