Database Design Concepts Flashcards
What is a field
A single bit of information about a person or an item
What is a record
A group of related fields about an item or person that is captured in a table
What is a primary key
A field that holds a unique identifier for each record in the database
What is data integrity
How accurate and consistent the data in a database is
What is data independence
The separation between data and the application in which it is being used
What is data redundancy
Having the exact same data in different places in the database
What is data security
How well the data in the database is protected from crashes, hacks and accidental deletion
What is data maintenance
Monthly, daily or hourly tasks that are run to fix errors within a database and prevent anomalies from occurring
What is an insertion anomaly
The database has been created in such a way that required data cannot be added unless another piece of unavailable data is also added
What is a deletion anomaly
The legitimate deletion of a record of data can cause the deletion of some required data
What is a modification anomaly
Incorrect data may have to be changed, which could involve many records having to be changed - leading to possible changes being made incorrectly
