WorksheetsITGS Term 2 Terms (Kahoot Sux)
Total questions: 46
Worksheet time: 23mins
Business Databases
For flight or train information allowing customers to view and book travel over the Internet.
Use databases to store both the contents of web pages and details about user's behaviour etc.
Includes customer information, product data, and supplier details.
Holds huge volumes of articles, images etc accessible with an Internet connection.
Transport Databases
For flight or train information allowing customers to view and book travel over the Internet.
Use databases to store both the contents of web pages and details about user's behavior, including common searches and topics of interest.
Includes customer information, product data, and supplier details.
Holds huge volumes of articles, images, and video accessible to anybody with an Internet connection.
Search Engines
For flight or train information allowing customers to view and book travel over the Internet.
Holds huge volumes of articles, images, and video accessible to anybody with an Internet connection.
Includes customer information, product data, and supplier details.
Use databases to store both the contents of web pages and details about user's behavior, including common searches and topics of interest.
Online Databases
For flight or train information allowing customers to view and book travel over the Internet.
Includes customer information, product data, and supplier details.
Holds huge volumes of articles, images, and video accessible to anybody with an Internet connection.
Use databases to store both the contents of web pages and details about user's behavior, including common searches and topics of interest.
Government Databases
The smallest pieces of information in a database.
Includes criminal records, tax records, medical records, libraries' databases of books, and schools' databases of students.
A collection of fields that relate to the same item.
Collections of records that are all of the same type.
Fields
Includes criminal records, tax records, medical records, libraries' databases of books, and schools' databases of students.
The smallest pieces of information in a database.
A collection of fields that relate to the same item.
Collections of records that are all of the same type.
Record
Includes criminal records, tax records, medical records, libraries' databases of books, and schools' databases of students.
A collection of fields that relate to the same item.
The smallest pieces of information in a database.
Collections of records that are all of the same type.
Tables
Includes criminal records, tax records, medical records, libraries' databases of books, and schools' databases of students.
A collection of fields that relate to the same item.
The smallest pieces of information in a database.
Collections of records that are all of the same type.
Primary Key
The AuthorID field in the Books table because it only exists to be a part of a relationship with another table.
Also known as a key field, it allows each record to be uniquely identified.
Also known as alternative keys or indexes. A secondary key is a field which might be used to search a table.
Consists of two or more fields which, separately do not uniquely identify records, but do when combined.
Composite Key
The AuthorID field in the Books table because it only exists to be a part of a relationship with another table.
Also known as a key field, it allows each record to be uniquely identified.
Also known as alternative keys or indexes. A secondary key is a field which might be used to search a table.
Consists of two or more fields which, separately do not uniquely identify records, but do when combined.
Secondary Keys
The AuthorID field in the Books table because it only exists to be a part of a relationship with another table.
Also known as a key field, it allows each record to be uniquely identified.
Also known as alternative keys or indexes. A secondary key is a field which might be used to search a table.
Consists of two or more fields which, separately do not uniquely identify records, but do when combined.
Foreign Key
Consists of two or more fields which, separately do not uniquely identify records, but do when combined.
Also known as a key field, it allows each record to be uniquely identified.
Also known as alternative keys or indexes. A secondary key is a field which might be used to search a table.
The AuthorID field in the Books table because it only exists to be a part of a relationship with another table.
Data Type
Determines which sort of data can be stored in it such as text, numbers, a date, or an image.
The process of creating a relational database which has no redundant data.
A relationship where one author has too many books, but one book only has one author.
A database which contains just one table.
Flat File Database
A database which contains just one table.
The process of creating a relational database which has no redundant data.
A relationship where one author has too many books, but one book only has one author.
Determines which sort of data can be stored in it such as text, numbers, a date, or an image.
Normalisation
Determines which sort of data can be stored in it such as text, numbers, a date, or an image.
The process of creating a relational database which has no redundant data.
A relationship where one author has too many books, but one book only has one author.
A database which contains just one table.
One-to-many relationship
Determines which sort of data can be stored in it such as text, numbers, a date, or an image.
The process of creating a relational database which has no redundant data.
A relationship where one author has too many books, but one book only has one author.
A database which contains just one table.
Query
A way of selecting only the records in a database that match certain criteria.
A language for writing instructions to manage databases.
(AND, OR, and NOT) are used to combine criteria.
Allows you to create a query that can be updated easily to reflect a new search term.
Boolean Operators
A way of selecting only the records in a database that match certain criteria.
A language for writing instructions to manage databases.
(AND, OR, and NOT) are used to combine criteria.
Allows you to create a query that can be updated easily to reflect a new search term.
SQL (Structured Query Language)
A way of selecting only the records in a database that match certain criteria.
A language for writing instructions to manage databases.
(AND, OR, and NOT) are used to combine criteria.
Allows you to create a query that can be updated easily to reflect a new search term.
Parameter Query
A way of selecting only the records in a database that match certain criteria.
Allows you to create a query that can be updated easily to reflect a new search term.
(AND, OR, and NOT) are used to combine criteria.
A language for writing instructions to manage databases.
Forms
A way of presenting data from a table in a database in a more professional manner.
Ensuring that data is correct, relevant, and up to date.
Used to present a user friendly graphical interphase for entering and altering data in a database.
These terms represent common ways of transferring data between different database and spreadsheet applications.
CSV (or comma) and TSV (or delimited values)
A way of presenting data from a table in a database in a more professional manner.
Ensuring that data is correct, relevant, and up to date.
Used to present a user friendly graphical interphase for entering and altering data in a database.
These terms represent common ways of transferring data between different database and spreadsheet applications.
Reports
A way of presenting data from a table in a database in a more professional manner.
Ensuring that data is correct, relevant, and up to date.
Used to present a user friendly graphical interphase for entering and altering data in a database.
These terms represent common ways of transferring data between different database and spreadsheet applications.
Data Integrity
A way of presenting data from a table in a database in a more professional manner.
Ensuring that data is correct, relevant, and up to date.
Used to present a user friendly graphical interphase for entering and altering data in a database.
Used to present a user friendly graphical interphase for entering and altering data in a database.
Data Validation
Checks that a field contains only certain characters.
Checks the number of characters in a field.
The process of ensuring that data is in the correct format for a particular field.
Checks that a numeric field is above or below a certain value.
Range Check
Checks that a field contains only certain characters.
Checks the number of characters in a field.
The process of ensuring that data is in the correct format for a particular field.
Checks that a numeric field is above or below a certain value.
Length Check
Checks that a field contains only certain characters.
Checks that a numeric field is above or below a certain value.
The process of ensuring that data is in the correct format for a particular field.
Checks the number of characters in a field.
Character Check
Checks that a field contains only certain characters.
The process of ensuring that data is in the correct format for a particular field.
Checks the number of characters in a field.
Checks that a numeric field is above or below a certain value.
Presence Check
Used to restrict a field to a set of pre-determined values.
Based on two or more related fields whose values depend on each other.
A mathematical check for numeric fields. Calculations are performed on a field and the result is stored in the field itself.
Checks that the field is not blank.
Consistency Check
Used to restrict a field to a set of pre-determined values.
Based on two or more related fields whose values depend on each other.
A mathematical check for numeric fields. Calculations are performed on a field and the result is stored in the field itself.
Checks that the field is not blank.
Check digit
Used to restrict a field to a set of pre-determined values.
Based on two or more related fields whose values depend on each other.
Based on two or more related fields whose values depend on each other.
A mathematical check for numeric fields. Calculations are performed on a field and the result is stored in the field itself.
Value List
Based on two or more related fields whose values depend on each other.
Used to restrict a field to a set of pre-determined values.
A mathematical check for numeric fields. Calculations are performed on a field and the result is stored in the field itself.
Checks that the field is not blank.
Verification
Once data has been entered, it can be compared with the original paper documents to confirm it's correct.
Helps to avoid typing mistakes that may have occurred when the data was entered.
Checks that data actually is correct.
In some cases, it may be sufficient to ask the person if the data stored is correct.
Entering Data Twice
Once data has been entered, it can be compared with the original paper documents to confirm it's correct.
Checks that data actually is correct.
Helps to avoid typing mistakes that may have occurred when the data was entered.
In some cases, it may be sufficient to ask the person if the data stored is correct.
Comparing with Original Documents
Once data has been entered, it can be compared with the original paper documents to confirm it's correct.
Helps to avoid typing mistakes that may have occurred when the data was entered.
Checks that data actually is correct.
In some cases, it may be sufficient to ask the person if the data stored is correct.
Verifying with the data subject
Once data has been entered, it can be compared with the original paper documents to confirm it's correct.
Helps to avoid typing mistakes that may have occurred when the data was entered.
Checks that data actually is correct.
In some cases, it may be sufficient to ask the person if the data stored is correct.
Data warehouses
Used to build up a profile of an individual by combining data about them from several databases.
Causes concerns about the security measures in place in other countries as well as the privacy controls governing who is allowed to access the data.
Warehouses and large centralized databases have allowed vast amounts of data to be collected, stored, and processed in one location.
The process of discovering hidden patterns and trends in large databases.
Data/computer matching
Used to build up a profile of an individual by combining data about them from several databases.
Causes concerns about the security measures in place in other countries as well as the privacy controls governing who is allowed to access the data.
Warehouses and large centralized databases have allowed vast amounts of data to be collected, stored, and processed in one location.
The process of discovering hidden patterns and trends in large databases.
Data mining or knowledge discovery
Used to build up a profile of an individual by combining data about them from several databases.
Causes concerns about the security measures in place in other countries as well as the privacy controls governing who is allowed to access the data.
Warehouses and large centralized databases have allowed vast amounts of data to be collected, stored, and processed in one location.
The process of discovering hidden patterns and trends in large databases.
Trans-border data flow
Used to build up a profile of an individual by combining data about them from several databases.
The process of discovering hidden patterns and trends in large databases.
Warehouses and large centralized databases have allowed vast amounts of data to be collected, stored, and processed in one location.
Policy whereby individuals' data will be collected unless they specifically request it not to be.
Personally identifiable data or sensitive data
Means no data wil be collected unless the user specifically agrees.
State how the data organizations collect will be used and who will have access to it.
Includes private data such as medical records or financial records.
Policy whereby individuals' data will be collected unless they specifically request it not to be.
Privacy policies
Means no data will be collected unless the user specifically agrees.
State how the data organizations collect will be used and who will have access to it.
Includes private data such as medical records or financial records.
Policy whereby individuals' data will be collected unless they specifically request it not to be.
Opt-out policy
Means no data will be collected unless the user specifically agrees.
State how the data organizations collect will be used and who will have access to it.
Policy whereby individuals' data will be collected unless they specifically request it not to be.
Includes private data such as medical records or financial records.
Opt-in policy
State how the data organizations collect will be used and who will have access to it.
Means no data will be collected unless the user specifically agrees.
Includes private data such as medical records or financial records.
Policy whereby individuals' data will be collected unless they specifically request it not to be.
Database auditing
Allows data controllers to view both successful and unsuccessful attempts to access, change, or delete data in a database.
Correct Answer?
Wrong Answer?
A law that governs the use of data collected and stored on a computer system.
Data Protection Act
Allows data controllers to view both successful and unsuccessful attempts to access, change, or delete data in a database.
Wrong Answer?
Correct Answer?
A law that governs the use of data collected and stored on a computer system.
