What is the diagram below an example of?
ERD diagram
Structure diagram
Wireframe
Which Act of Parliament covers ensuring the prior consent of users before storing personal information?
Data Protection Act
Computer Misuse Act
Copyright, Designs and Patents Act
Which of the following is a definition of an entity?
Entities represent people, places, objects or things, about which tables will be created in a database
An ‘entity’ is another term for a database
Entities are used to perform searches and sorts on a database
Which of the following is a definition of an attribute?
An attribute is a form of validation that can be applied to fields in a database
An attribute is a characteristic of an entity and will become a field during implementation
An attribute is another term for ‘field type’ e.g. text, number, date
What is the purpose of a data dictionary?
To provide descriptions of the data held in the database, so that a reference point exists when creating the database system
To act as a glossary of terms defining what is meant by the words database, attribute, entity, relationship etc.
To define the relationships between different tables .
Which of the following is a definition of a presence check?
A validation rule used to ensure that a field is not left blank
A validation rule used to ensure that every table has a foreign key
A check used to make sure that any images appear as they should
Which validation rule is applied when the data in a field must be one of a preset list of values?
Range check
Restricted choice
Length check
What is the table shown below an example of?
Field(s) Area Name, Available, Manager
Table(s) Sports area
Criteria Available = "True"
Sort Order Area Name ASC
Data dictionary
Query design
What does the shorthand ‘ASC’ stand for when used to state the sort order of a query?
Ascertain
Ascending
ASCII
What does the shorthand ‘DESC’ stand for when used to state the sort order of a query?
Description
Descendant
Descending