Database terms

?
  • Created by: Emily
  • Created on: 04-01-13 12:20
Database
A persistent organised store of data
1 of 21
Persistent Storage
Non-volatile storage on a secondary storage medium such as a hard disk
2 of 21
Data duplication/Data redundancy
Where the same data is stored more than once unnecessarily
3 of 21
Program-Data Independence
Where the applications that use a shared database are separated from the actual data by a database management system.
4 of 21
DBMS
Database Management System. The system that separates the applications from the data.
5 of 21
Views
A feature of a DBMS that provides different users to have different viewing and accessing rights.
6 of 21
Flat file
A persistent organised store of data where data is stored in a single file.
7 of 21
Relational database
A persistent organised store of data where data is stored as a collection of related tables to minimise data redundancy.
8 of 21
Entity
A real world object about which data is stored in a database.
9 of 21
Record
Data stored about one instance of an entity.
10 of 21
Field
One specific data item being stored (such as surname or shoe size)
11 of 21
Primary key
A field in a table that uniquely identifies a record
12 of 21
Foreign Key
A field in one table that is the primary key in another table, used to create a relationship.
13 of 21
Relationship
The logical connection created between two tables
14 of 21
Form
An interactive window used for data entry.
15 of 21
Validation
When the computer software checks that the data entered is sensible.
16 of 21
Verification
A type of validation where data is entered twice and checked that each version is the same (to avoid data being entered with typos)
17 of 21
Queries
A feature of a DBMS that allows the database to be interrogated
18 of 21
Logical operator
Used in complex criteria in queries. NOT, AND, OR.
19 of 21
Reports
Data from a database that has been processed and present on a page.
20 of 21
Modules
Sections of code within a DBMS that allow the user interface to be tailored.
21 of 21

Other cards in this set

Card 2

Front

Persistent Storage

Back

Non-volatile storage on a secondary storage medium such as a hard disk

Card 3

Front

Data duplication/Data redundancy

Back

Preview of the front of card 3

Card 4

Front

Program-Data Independence

Back

Preview of the front of card 4

Card 5

Front

DBMS

Back

Preview of the front of card 5
View more cards

Comments

furqan98

Report

Amazing!

jamtay

Report

Hi, what an amazing explanation of database system. I recently shifted my self-storage mile-end business online. As you can understand from the name, we have a huge data of our customers. This explanation literally helps me a lot in understanding our problem. 

Similar Computing resources:

See all Computing resources »