ITGS Term 2 Terms (Kahoot Sux)

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.