Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

AS Computer Science > Chapter 8 - Databases > Flashcards

Chapter 8 - Databases Flashcards

1
Q

Data base

A

Structured collection of items of data that can be accessed by different applications programs

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Relational database

A

A database where the data items are linked by internal pointers

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Table

A

Group of similar data, in a database, with rows for each instance of an entity and columns for each attribute

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Record

A

A row in a table in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Field

A

Column in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Tuple

A

One instance of an entity, which is represented by a row in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Entity

A

Real - life object that is represented as a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Attribute

A

An individual data item stored for an entity eg. Person attributes could be name, address etc

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

Candidate key

A

An attribute or smallest set of attributes in a table where no tuple has the same value

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

Primary key

A

Unique identifier for a table. Special case for a candidate key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Secondary key

A

Key that is an alternative to the primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Foreign key

A

Set of attributes in one table that refer to the primary key in another table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Relationship

A

Situation in which one table in a database has a foreign key that refers to a primary key in another table in the database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

Referential integrity

A

Property of a database that does not contain any values of a foreign key that are not matched to the corresponding primary key

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Index

A

Data structure built from one or more columns in a database table to speed up searching for data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

E-R model/diagram

A

Entity - Relationship
Graphical representation of a database and the relationship between the entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

Normalisation

A

Process of organising data to be stored in a database into two or more

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Types of normalisation (3)

A

1NF
2NF
3NF

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Normalisation

A

The process of organising data to be stored in a database into two or more tables and relationships between the tables, so that data redundancy is minimised

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

1NF

A

First Normal Form

Entities do not contain repeated groups of attributes

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

2NF

A

Entities are in 1NF and any non-key attributes depend on the primary key. There are no partial dependencies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

3NF

A

Third Normal Form

Entities are in 2NF and all non-key attributes are independent. The table contains no non-key dependencies

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

DBMS

A

Database Management System

System software for the definition, creation and manipulation of a database

24
Q

Data dictionary

A

Set of data that contains metadata (data about other data) for a database

25
Data modelling
The analysis and definition of the data structures required in a database and to produce a data model
26
Logical schema
A data model for a specific database that is independent of the DBMS used to build that database
27
Access rights
Permissions given to database users to access, modify or delete data
28
Developer interface
Feature of a DBMS that provides developers with the commands required for definition, creation and manipulation of a database
29
SQL
Structured Query Language The standard query language used with relation databases for data definition and data modification
30
Query processor
Feature of a DBMS that processes and executes queries written in SQL
31
DDL
Data Definition Language A language used to create, modify and remove the data structures that form a database
32
DML
Data Manipulation Language Language used to add, modify, delete, and retrieve the data stored in a relational database
33
SQL script
List of SQL commands that perform a given task, often stored in a file for reuse
34
Composite key
Set of attributes that form a primary key to provide a unique identifier for a table (Combination of different keys)
35
What is a file
File is a collection of items of data that can be structured as a collection of records where each record is made up of fields containing data about the same thing
36
Problem with a file based approach (2)
If the records are to be processed by another program, that program must be written to the exact same record structure. If the structure is changed by one program, the other program must be rewritten as well, causing problems if updating programs is not carefully managed
37
38
Limitations of a file based approach (3)
Storage space is wasted when data items are duplicated by the separate applications and some data is redundant Data can be altered by one application and not by another, becoming inconsistent Enquiries available can depend on the structure of the data and the software used so that the data is not independent
39
Advantages of a relational database compared to a file based approach (5)
Reduced data redundancy Improved data integrity/consistency/referential integrity Allows for program-data independence Complex queries can be executed
40
41
How do relational databases keep the number of copies to a minimum
Using pointers between tables
42
How do databases ensure the consistency of data
Updating is controlled or automatic
43
Types of keys (4)
Candidate key Primary key Secondary key Foreign key
44
Forms of relationships (4)
1:1 1:m m:1 m:m (Can be mandatory or optional)
45
46
How a DBMS addresses the limitations of a file based approach: Data redundancy issue
By storing data in separate linked tables, which reduces duplication of data as most items are only stored once. Items of data used to link tables (foreign keys) are stored more than once. DBMS flags any possible errors when any attempt is made to accidentally delete this type of item
47
How a DBMS addresses the limitations of a file based approach: Data inconsistency issue
Solved by storing most items of data only once, allowing updated items to be seen by several applications. Due to the consistency, there is improved data integrity.
48
How a DBMS addresses the limitations of a file based approach: Data dependency issue
Data is independent of the application using the database, so changes made to the structure of the data will be managed by the DBMS and have little/no effect on the applications using the database. Any fields/tables added/removed will not affect the applications that don’t use them as each application only has access to the fields/tables it requires.
49
DBMS approach
It uses a data dictionary to store the metadata, including the definition of tables, attributes, relationships between tables and any indexing. The data dictionary can also define the validation rules used for the entry of data and contain data about the physical storage of the data. It also makes use of data modelling It helps to provide data security to prevent the unwanted alteration, corruption, deletion or sharing of data with others that have no right to access it
50
Benefit of using a data dictionary
It improves the integrity of the data stored, helping to ensure that it is accurate, complete and consistent
51
Security measures taken by DBMS (6)
Using usernames & passwords to prevent unauthorised access to the database Using access rights to manage actions authorised users can take (read/write/delete or read only etc.) Using access rights to manage parts of the database they have access to Automatic creation and scheduling of regular backups Encryption of the data stored Automatic creation of an audit trail or activity log to record the actions taken by users of the database
52
53
DBMS software tools (2)
Developer interface Query processor
54
Data types for attributes (SQL)
CHARACTER VARCHAR(n) BOOLEAN INTEGER REAL DATE TIME
55
SQL (DML) maintenance commands (3)
INSERT INTO - adds new row to table DELETE FROM - removes row from table UPDATE - edits row in table
56
SQL (DML) query command (8)
SELECT FROM - fetches data from database WHERE - includes only rows in a query that match a given condition ORDER BY - sorts results numerically or alphabetically GROUP BY - arranges data into groups INNER JOIN - combines rows from different tables if the join condition is true SUM - returns sum of all values in a column COUNT - counts number of rows where column is not NUL AVG - returns average for a column

AS Computer Science (10 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions