Flashcards in Databases Deck (16)
Ensuring that data is correct after it has been processed
When data appears unnecessarily more than once in a database
When the structure of the database with its data is kept separately from the applications that use the data.
A group of tables linked together by primary and foreign keys
A field in a table that uniquely identifies each record
A field in one table that references the primary key field in another table
A primary key that is made up of multiple fields and together they uniquely identify each record.
A DBMS is designed to allow the definition, creation, querying, updating, and administration of databases.
An index is a separate file that stores addresses to blocks or direct link to the complete row of data from a table to enable fast searching.
An object in a system that we want to model and store data about
A view is the result set of a stored query on the data. A view contains rows and columns, just like a real table. The fields in a view are fields from one or more real
tables in the database
Uses objects to model the required behaviours rather than tables
Data is stored in a number of computers at different physical locations but it appears as one logical database.
Connection between two tables by primary/foreign keys
A set of attributes modelling an entity (table)