What is a table in database terminology?
A collection of related data organized in rows and columns, where each row represents a record and each column represents a field
What is a record in a database?
A single row in a database table that contains all the information about one particular item or entity
What is a field in a database?
A single column in a database table that stores a specific type of data (e.g., name, age, address)
What is a key field and why is it important?
A field that uniquely identifies each record in a table.
What is a query in database terms?
A request for specific data from a database, used to search, filter, or extract information based on certain criteria
What is a form in a database application?
A user interface that allows users to enter, edit, or view data in a more user-friendly way than directly editing tables
What is a report in database terminology?
A formatted presentation of data from a database, often used for printing or displaying information in an organized manner
What is a macro in database applications?
A set of automated commands or actions that can be executed to perform repetitive tasks in a database
What is a relationship in database design?
A connection between two or more tables that allows data to be linked and shared between them
Name the 4 relationship types
- 1 to 1
- 1 to many
- many to one
- Many to many
What does importing data mean in database context?
The process of bringing data from external sources (like spreadsheets or other databases) into your database
What is the Text data type used for?
Storing alphabetic characters, words, and sentences (e.g., names, addresses, descriptions)
What is the Number data type used for?
Storing numerical values that can be used in mathematical calculations (e.g., age, quantity, price)
What is the Date/Time data type used for?
Storing dates and times in a standardized format (e.g., birth dates, appointment times)
What is the Boolean/Yes-No data type used for?
Storing true/false or yes/no values (e.g., married status, membership status)
What is the Currency data type used for?
Storing monetary values with appropriate formatting and precision for financial calculations
Why is data validation important in databases?
To ensure data accuracy, consistency, and integrity by preventing incorrect or inappropriate data from being entered
What is presence validation?
A validation check that ensures a field is not left empty - it must contain some data
What is length validation?
A validation check that ensures data entered is within specified minimum and maximum character limits
What is type validation?
A validation check that ensures data entered matches the expected data type (e.g., numbers only in a numeric field)
What is format validation?
A validation check that ensures data follows a specific pattern or format (e.g., email addresses, phone numbers)
What is range validation?
A validation check that ensures numerical data falls within specified minimum and maximum values
What does the < operator do in database queries?
Returns records where the field value is less than the specified value
What does the > operator do in database queries?
Returns records where the field value is greater than the specified value
