Database Concepts

What is a DATABASE?

• A type of computer virus
• A type of food
• A musical instrument
• An organized collection of data

What is a collection of related fields that represents a complete set of information?

• Record

• Field

• Database

• Information

What is the tiniest nugget of data in a database, representing a characteristic or attribute of an entity?

• Row

• Database

• Field

• Table

What is a field in a database table that is used to establish a link between two tables?

• Primary Key

• Index

• Unique Key

• Foreign Key

What is a unique identifier for a record in a table?

• Index key

• Foreign key

• Secondary key

• Primary key

Can you find the hidden treasures? Identify the Primary Key(s) from this mysterious diagram

• PARCELID in PARCELS TABLE

• OWNERNUM in OWNERS TABLE

• PARCELID in TAX TABLE

• PARCELID in FIRES TABLE

Identify the Foreign Key(s) from this diagram

• PARCELID in PARCELS TABLE

• OWNERNUM in OWNERS TABLE

• PARCELID in TAX TABLE

• PARCELID in FIRES TABLE

• ONUM in PARCELS

Why do we need a DATABASE SYSTEM?

• To efficiently store and manage small volumes of data.

• To efficiently store, retrieve and manage small volumes of files.

• To efficiently store, retrieve, and manage large volumes of data.

• To efficiently store, retrieve, and manage large volumes of papers.

Which task involves managing the physical aspects of the database, including installation, configuration, and maintenance?

• Works closely with business stakeholders to understand their data needs and aligns data initiatives with organizational goals.

• Defines data standards, establishes data quality guidelines, and oversees data-related policies.

• Responsible for data governance, ensuring that data is used ethically, securely, and in compliance with regulations.

• Manages the physical aspects of the database, including installation, configuration, and maintenance.

What is the simplest type of database model, organizing data in a structured way? where rows represent records and columns represent attributes or fields