National 5 Computing - Databases - Analysis and Design

All systems have functional and non-functional requirements. Functional requirements are:

• Are defined by the client

• Specify exactly what the system should do.

• Meet the needs of the end user

• Specifies what the system can not do

A primary school is organising a range of 30 activities for its 550 pupils for the last day of term. The organiser wishes to create and use a database.

 

label the requirements

a

b

End User

Requirement Elicitation

Functional

A school stores details about its pupils in a database. Which of the following thing must the school do to comply with the General Data Protection Regulation (GDPR)?

• Keep the data on a computer

• Keep the data for one year only

• Keep the data accurate and up to data

• Tell the teachers to let pupils see their data.

Dr Anderson store details about her patients in a database. Which of the following is an implication of the General Data Protection Regulation (GDPR)?

• She must use the data for its declared purpose only

• She must not print out the data

• She must get consent from the patients to read their details during an appointment

• She must ask patients to type in their own data

Which of the following is not an implication of the General Data Protection Regulation (GDPR)?

• Processed lawfully, fairly and in a transparent manner in relation to individuals

• Used for the declared purpose only

• Stored for no longer than 3 years

• Accurate

What is the data type of the Event Code Field?

• Number

• Text

• Date

• Time

What is the data type of the Event Date field?

• Number

• Text

• Date

• Time

Identify the Primary Key from the table.

Match the following

• A unique identifier of a record

• SQL

• A field in a table that links to the primary key in another table

• Primary Key

• A regulation on information privacy

• GDPR

• Structured Query Language

• Referential Integrity

• Accuracy and consistency of data within a relationship

• Foreign Key

How many entities are shown in the diagram?