7 terms
A database is an organized, persistent collection of structured data managed by a DBMS that controls storage, querying, concurrency and recovery.
A DBMS, or database management system, is software that stores, retrieves, secures and manages data in databases while enforcing consistency.
A foreign key is a column or set of columns in a relational table that must match a key in another table, enforcing referential integrity.
A primary key is the column or set of columns that uniquely identifies each row in a database table and cannot contain null values.
A relational database stores data in tables of rows and columns linked by keys and queried with SQL, enforcing integrity through constraints and transactions.
A schema in databases is the formal definition of how data is organized, including its tables, columns, data types, keys and constraints.
A table in a relational database is a named structure of rows and typed columns that stores one kind of entity under a schema enforced by…