O-LevelComputer ScienceDatabases2210/22 · May/June 2017 · Q512 Marks
A database table, SHEEP, is used to keep a record of the sheep on a farm. Each sheep has a unique ear tag, EARnnnn; n is a single digit. The farmer keeps a record of the date of birth, the gender and the current weight of each sheep in kilograms.
- (a)Identify the four fields required for the database. Give each field a suitable name and data type. Provide a sample of data that you could expect to see in the field. Field 1 name Data type Data sample Field 2 name Data type Data sample Field 3 name Data type Data sample Field 4 name Data type Data sample[8]
- (b)State the field that you would choose as the primary key.[1]
- (c)Using the query-by-example grid below, write a query to identify the ear tags of all male sheep weighing over 10 kilograms. Only display the ear tags. Field: Table: Sort: Show: Criteria: or:[3]
Mark scheme
Marking points from the official mark scheme (May/June 2017). The mark or mark type is shown in brackets.
- [1] Field name, data type and sample for EarTag
- [1] Field name, data type and sample for DOB
- [1] Field name, data type and sample for Gender
- [1] Field name, data type and sample for Weight
- [1] EarTag
- [1] Field: EarTag (Show selected)
- [1] Criteria: ='M' for Gender
- [1] Criteria: >10 for Weight
Write your answer and get it marked
On Oracle Prep you can write or photograph your own answer and have it marked by AI against this mark scheme, with feedback on what you missed.
Sign up free →