Use LEFT and RIGHT arrow keys to navigate between flashcards;
Use UP and DOWN arrow keys to flip the card;
H to show hint;
A reads text to speech;
16 Cards in this Set
- Front
- Back
Data Consistency |
Ensuring that data is correct after it has been processed |
|
Data redundancy |
When data appears unnecessarily more than oncein a database |
|
Data independence |
When the structure of the database with it datais kept separately from the applications that use the data. |
|
Relational Database |
A group of tables linkedtogether by primary and foreign keys |
|
Primary Key |
A field in a table that uniquely identifies each record |
|
Foreign Key |
A field in one table that references the primary key field in another table |
|
Compound key |
A primary key that is made up of multiple fields and together theyuniquely identify each record. |
|
Database Management System |
A DBMS is designed to allow the definition,creation, querying, update, and administration of databases. |
|
Table Index |
An index is a copy of select columns of data from a table that can be searched very efficiently (usually to search for groups of data) that also includes a low-level disk block address or direct link to the complete row of data it was copied from. |
|
Entity |
An object in a system that we want to model and store data about. |
|
Database view |
A view is the result set of a stored query on the data. A view contains rows andcolumns, just like a real table. The fields in a view are fields from one or more real tablesin the database |
|
Object Oriented Database |
Uses objects to model the required behaviours rather than tables |
|
Distributed Database |
Data is stored in a number of computers at different physical locations but it appears as one logical database. |
|
Link |
Connection between two tables by primary/foreign keys |
|
Relation |
A set of attributes modelling an entity (table) |
|
Flat file |
contains one table and one key field it is useful for SIMPLE solutions |