Database Management Flashcards
(18 cards)
What is a foreign key?
A field that links to the primary key of another table to establish relationships.
What is a primary key?
A unique identifier for each record in a table (e.g., Student ID).
What is a composite key?
A primary key made of multiple fields
What is a candidate key?
A field or set of fields that could serve as a primary key.
Why are keys important in databases?
They ensure data integrity and enable table relationships.
What is a database table?
A structured set of data organized in rows (records) and columns (fields).
What is a field in a database?
A column representing a specific attribute (e.g., “Age”).
What is a record?
A row containing all data about one entity (e.g., a student’s details).
What is normalization?
Organizing data to reduce redundancy and improve efficiency.
What is a relational database?
A database that uses tables linked by relationships (e.g., SQL databases).
What is a database query?
A request to retrieve or manipulate data (e.g., SQL SELECT statement).
What is a database report?
A formatted summary of data for analysis or printing.
How is a report different from a query?
A query retrieves raw data; a report presents it in a readable format.
What is HTML?
HyperText Markup Language (used to structure web pages).
What is a responsive web design?
A design that adapts to different screen sizes (e.g., mobile-friendly).
