Databases Flashcards Preview

Computer Science > Databases > Flashcards

Flashcards in Databases Deck (16)
Loading flashcards...
1

Data
consistency

Ensuring that data is correct after it has been processed

2

Data
redundancy

When data appears unnecessarily more than once in a database

3

Data
independence

When the structure of the database with its data is kept separately from the applications that use the data.

4

Relational
Database

A group of tables linked together by primary and foreign keys

5

Primary Key

A field in a table that uniquely identifies each record

6

Foreign Key

A field in one table that references the primary key field in another table

7

Compound key

A primary key that is made up of multiple fields and together they uniquely identify each record.

8

Database
Management
System

A DBMS is designed to allow the definition, creation, querying, updating, and administration of databases.

9

Table Index

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.

10

Entity

An object in a system that we want to model and store data about

11

Database view

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

12

Object Oriented
Database

Uses objects to model the required behaviours rather than tables

13

Distributed
Database

Data is stored in a number of computers at different physical locations but it appears as one logical database.

14

Link

Connection between two tables by primary/foreign keys

15

Relation

A set of attributes modelling an entity (table)

16

Flat file

Contains one table and one key field it is useful for SIMPLE solutions