Analysis & Design
These are the people who will use the database.
What are end users?
A field that uniquely identifies each record.
What is a Primary Key?
The most common type of database relationship.
What is One-to-Many (1:M)?
The SQL clause used to specify which fields are displayed.
What is SELECT?
A value created during a query rather than stored in the database.
What is a Computed/Calculated Value?
These describe the processes, activities and information a system needs.
What are functional requirements?
A primary key from another table used to create a link.
What is a Foreign Key?
The relationship between a School and a Headteacher.
What is One-to-One (1:1)?
The SQL clause used to filter records.
What is WHERE?
The SQL keyword used to give a temporary name (Alias) to a calculated field.
What is AS?
Staff need to be able to update pupil records when a new member joins a club is this type of reequirement.
What is an end-user requirement?
A key made from two or more fields.
What is a Compound Key?
The notation used in ER diagrams to represent "many".
What is Crow's Foot notation?
The wildcard used in Access SQL to represent zero, one or many characters.
What is the asterisk (*) wildcard?
The aggregate function that returns the number of records.
What is COUNT?
A gym database must store member details, calculate monthly fees and produce membership reports is these types of requirements.
What are functional requirements?
In a Pupil table, this field would most likely be used as the primary key.
What is PupilID?
The type of relationship between Student and Subject.
What is Many-to-Many (M:M)?
If six tables are used in a query, this is the number of joins required.
What has five joins?
The SQL clause required when mixing aggregate and non-aggregate fields.
What is GROUP BY?
A customer wants to view all bookings made for their holiday resort is this type of requirement.
What is an end-user requirement?
ResortID stored in the Hotel table is this type of key.
What is a Foreign Key?
This type of relationship can result in data duplication and is not desirable in database design.
What is Many-to-Many?
What SQL query would you use to change all staff members salaries by 5%?
What is an UPDATE query(with calculation)?
The first query when implementing secondary queries should produce this.
What is a single (computed) value?