11 A school library has a file for storing details of the books it has and a file for storing details of its borrowers. The two files are linked using a common field. Book Fle Published Number in stock 1999 2 Code Title Author 1857028898 The Code Book Simon Singh 0747591054 The Deathly Hallows JK Rowling 0748791167 Sepulchre Kate Mosse 0563371218 Full Circle Michael Palin 2007 8 Cost 10.99 17.99 18.99 19.99 3 2007 1997 1 Years 10 and 11 Borrower File Number Name Form Book Borrowed 0102 Me Te Loan 11A 1857028898 1097 Gurvinder Moore 100 0747591054 0767 Akhtar Aftab 10B 0748791 167 0611 Graham Reeves 0563371218 (a) How many records are there in the book file ? Due Back 14/06/2010 12/06/2010 06/06/2010 08/06/2010 100 [1] ***THIBITISHR*********** (b) How many fields are there in the borrower file? [1] *HTETETTELSESERIERRIER (c) What type of database do these two files form? [1] Maria is the principal of the International Municipal school. She has employed Paulo, a systems analyst, to create a new database system to store records of her final year IGCSE students. Examples of the details of the students which will be stored are: Velia Grimaldi, A3058, Female, 161, Leaving Giuseppe Campo, A3072 , Male, 177, Staying on to 6th form Nicola Donati, B3085, Female, 173, Staying on to 6th form Giovanni Agnelli, C3102, Male, 172, Leaving (a) Complete the following table by entering the field names and most appropriate data type for each field. For any numeric field, specify the type of number. Data type Field name Name Boolean Height 11 A school library has a file for storing details of the books it has and a file for storing details of its borrowers. The two files are linked using a common field. Book File Published Number in stock 1999 2 Code Title Author 1857028898 The Code Book Simon Singh 074759 1054 The Deathly Hallows JK Rowling 0748791167 Sepulchre Kate Mosse 0563371218 Full Circle Michael Palin 2007 8 Cost 10.99 17.99 18.99 19.99 2007 3 1997 1 Years 10 and 11 Borrower File Form Number 0102 11A 1097 Name Me Te Loan Gurvinder Moore Akhtar Aftab Graham Reeves Book Borrowed 1857028898 0747591054 0748791167 0563371218 100 10B 10D Due Back 14/06/2010 12/06/2010 06/06/2010 08/06/2010 0767 0611 (h) What data type would be most appropriate for the Due Back field? 11 A school library has a file for storing details of the books it has and a file for storing details of its borrowers. The two files are linked using a common field. Book File Published Number in stock 1999 2 Code Title Author 1857028898 The Code Book Simon Singh 0747591054 The Deathly Hallows JK Rowling 0748791167 Sepulchre Kate Mosse 0563371218 Full Circle Michael Palin 2007 8 Cost 10.99 17.99 18.99 19.99 2007 3 1997 1 Number 0102 Years 10 and 11 Borrower File Name Form Book Borrowed Me Te Loan 11A 1857028898 Gurvinder Moore 100 0747591054 Akhtar Aftab 10B 0748791 167 Graham Reeves 10D 0563371218 1097 Due Back 14/06/2010 12/06/2010 06/06/2010 08/06/2010 0767 0611 (h) What data type would be most appropriate for the Due Back field
