A (large) collection of data items and links between them, structured in a way that it can be accessed by a number of applications.
1 of 25
Flat File Database
A database held as a table and stored in a single file.
2 of 25
Relational Database
A complex database structure that holds a variety of different data. Where data items are related to each other and are linked together by pointers in the database.
3 of 25
Database Management System (DBMS)
Software that can find data in a database, add new data and change existing data.
4 of 25
Data Type
A formal description of the kind of data being stored or manipulated within a program or system.
5 of 25
Query
A question asked of the database.
6 of 25
Data Capture
The collection of data for entering into a computer.
7 of 25
Form
Designed to collect information from human users.
8 of 25
Validation
Automatic checking of data entered into a computer system.
9 of 25
Verification
The use of checks to make sure data is consistent and has not been corrupted.
10 of 25
Data Redundancy
Attributes are unnecessarily duplicated in a database, increasing storage requirements and/or causing data inconsistency.
11 of 25
Data Independence
Data is kept separate from the software that manages it.
12 of 25
Data Integrity
The accuracy/reliability/completeness of data.
13 of 25
Attribute
Describes each individual data item within the entity. Stored as a field.
14 of 25
Entity
Identifies a group collection of information, which describes the subject of that entity.
15 of 25
Primary Key
Uniquely identifies a record. Often called a key field.
16 of 25
Composite Key
A key made up of more than one field. Consists of two or more keys which together uniquely identify a record.
17 of 25
Foreign Key
A referential constraint or link between two tables. An attribute in one table and a primary key in another table.
18 of 25
Relationships
Describes a link between two entities. Where data items are linked together by keys stored in the database.
19 of 25
Referential Integrity
Prevents users or applications from entering inconsistent data.
20 of 25
Data Duplication
When there are duplicate copies of data, wasting storage space and making data redundant.
21 of 25
Data Inconsistency
When an attribute has more than one value as it will be stored in more than one entity.
22 of 25
Data Dictionary
A file containing descriptions of, and other information about, the structure of data held in the database.
23 of 25
Logical Data Model
Shows entities, relationships and keys. Attributes of each entity are identified. No description of physical structure.
24 of 25
Physical Data Model
Includes specification of all entities and columns. Includes table name, column name and data type. Contains primary keys and specifies relationships using foreign keys.
25 of 25
Other cards in this set
Card 2
Front
A database held as a table and stored in a single file.
Back
Flat File Database
Card 3
Front
A complex database structure that holds a variety of different data. Where data items are related to each other and are linked together by pointers in the database.
Back
Card 4
Front
Software that can find data in a database, add new data and change existing data.
Back
Card 5
Front
A formal description of the kind of data being stored or manipulated within a program or system.
Comments
No comments have yet been made