Databases Flashcards Preview

Computer Science > Databases > Flashcards

Flashcards in Databases Deck (17):
1

Database

A persistent, organised store of data

2

DBMS

Database management system
-separates application from the database
-provides different views of the database
-allows applications to query the database
-can provide automatic backups
-maintains data integrity
-data is protected from corruption

3

Forms

Inout screen, which allow us to input data into a database
-text boxes, checkboxes

4

Queries

Feature of a DBMS that allows the database to be searched
-selects records based on specified criteria

5

Reports

Output screen. A snapshot of data at a given time

6

Modules

A selection of code within a DBMS that allows the user interface to be tailored

7

Range check

Data is within a suitable range

8

Type check

Data is the right type (e.g. integer)

9

Check digit

Checks digits are correct (e.g. barcodes)

10

Length check

Checks data is suitable length

11

Lookup

Looks up acceptable values in a table

12

Presence check

Data has been entered

13

Data redundancy

Same data is store more than once, unnecessarily

14

Data inconsistency

Different versions of the same data have different values because duplicate versions have been stored and updated differently

15

Primary key

A field in a table that uniquely identifies a record

16

Foreign key

Primary key from another table to create a relationship between those tables

17

Data-handling software

-creates tables
-define fields
-define primary keys
-define relationships