A teacher has decided to use a database table as her mark book for her Computer Science class, which she has called MARKBOOK. For each student, the following data will be recorded: first name, last name, their year 10 test score and their year 11 test score. The class has 32 students. (a) State the number of fields and records required for this database. Number of Fields \_\_\_\_ Number of Records \_\_\_\_ [2] (b) The data in MARKBOOK is stored under category headings: LastName, FirstName, Y10TestScore and Y11TestScore. State, with a reason, whether any of these headings would be suitable as a primary key. \_\_\_\_ \_\_\_\_ \_\_\_\_ \_\_\_\_ [2] (c)Complete the query-by-example grid to only display the first name, last name and year 10 test score of each student who achieved 50 or more in their year 10 test. The output should be in test score order with the highest marks at the top of the list. | Field: | | | | | | :--- | :--- | :--- | :--- | :--- | | Table: | | | | | | Sort: | | | | | | Show: | □ | □ | □ | □ | | Criteria: | | | | | | or: | | | | | [4]

2019 - O/N - 0478/23 | Q7

0/7

0 correct · 0 wrong

A teacher has decided to use a database table as her mark...