Save
2.5 Databases
Lesson 8
Save
Share
Learn
Content
Leaderboard
Share
Learn
Created by
Zee
Visit profile
Cards (23)
What is the primary function of a DBMS?
Interface between
OS
and user for data access
View source
What are the main functions of a DBMS?
Data storage
,
retrieval
, and update
View source
How does a DBMS simplify data access for users?
By hiding the internal structure of the
database
View source
What does a DBMS allow users to do with data?
Store, retrieve, and update
information
View source
What is the purpose of a data dictionary in a DBMS?
To maintain
metadata
about the database
View source
What is a key function of DBMS regarding security?
Handle
password
allocation and checking
View source
How do user database views work in a DBMS?
They provide different
access levels
to users
View source
What might a receptionist in a hospital see in a DBMS?
Patient name and address, not
medical
info
View source
What is a range check in data validation?
Ensures
input
data
lies within a
specific
range
View source
What does a presence check do?
Prevents progress if a
required field
is blank
View source
What is a format check used for?
To ensure data matches a
specific
pattern
View source
What does a data type check ensure?
Input
data
is
of
a
particular
data
type
View source
What is the purpose of a length check?
To ensure
input data string
is sensible length
View source
What is 'Restricted' validation in databases?
Limits
data entry
to
specific valid choices
View source
What is verification in data entry?
Checking
entered
data matches intended data
View source
How is verification typically performed?
By comparing
data
with another
copy
View source
What is referential integrity in databases?
Ensures
foreign keys
correspond to
primary keys
View source
What happens if referential integrity is violated?
Errors occur when
foreign keys
are invalid
View source
What information does a Data Dictionary hold?
Information about every table in the
database
Information about every
field
in the database
Characteristics
of each data item (length, type)
Restrictions on column values (
validation rules
)
Relationships between data items
Programs accessing data and their
permissions
View source
What is the role of a DB Administrator regarding user access?
Assigns different
access levels
to users
View source
How does a DBMS handle backup and recovery?
Provides ability to recover
database
after failure
View source
What is the significance of 'Not Null' fields in a database?
Records can't be added
without
data
in those fields
View source
What is the purpose of input masks in format checks?
To create specific
patterns
for data entry
View source
See similar decks
1.3.2 Databases
OCR A-Level Computer Science > 1.3 Exchanging data
46 cards
10.1.2 Database management systems (DBMS)
AQA A-Level Computer Science > 10.0 Fundamentals of databases > 10.1 Database concepts
74 cards
10.0 Fundamentals of databases
AQA A-Level Computer Science
743 cards
10.1 Database concepts
AQA A-Level Computer Science > 10.0 Fundamentals of databases
99 cards
10.2 Relational databases
AQA A-Level Computer Science > 10.0 Fundamentals of databases
143 cards
3.7.1 Database concepts
AQA GCSE Computer Science > 3.7 Relational databases and structured query language (SQL)
37 cards
10.2.2 Normalization
AQA A-Level Computer Science > 10.0 Fundamentals of databases > 10.2 Relational databases
113 cards
10.1.1 Data models
AQA A-Level Computer Science > 10.0 Fundamentals of databases > 10.1 Database concepts
25 cards
3.7 Relational databases and structured query language (SQL)
AQA GCSE Computer Science
150 cards
1.4.2 The role of reason and perception
OCR A-Level Philosophy > 1. Epistemology > 1.4 The limits of knowledge
87 cards
10.2.1 Tables, records, and fields
AQA A-Level Computer Science > 10.0 Fundamentals of databases > 10.2 Relational databases
30 cards
1.3 Reason as a source of knowledge
OCR A-Level Philosophy > 1. Epistemology
81 cards
10.4 Transactions and concurrency
AQA A-Level Computer Science > 10.0 Fundamentals of databases
266 cards
10.4.1 ACID properties
AQA A-Level Computer Science > 10.0 Fundamentals of databases > 10.4 Transactions and concurrency
36 cards
1.3 Reason as a source of knowledge
AQA A-Level Philosophy > 1. Epistemology
137 cards
10.3.2 Data manipulation language (DML)
AQA A-Level Computer Science > 10.0 Fundamentals of databases > 10.3 Structured Query Language (SQL)
136 cards
10.3.1 Data definition language (DDL)
AQA A-Level Computer Science > 10.0 Fundamentals of databases > 10.3 Structured Query Language (SQL)
99 cards
10.3 Structured Query Language (SQL)
AQA A-Level Computer Science > 10.0 Fundamentals of databases
235 cards
10.4.2 Concurrency control
AQA A-Level Computer Science > 10.0 Fundamentals of databases > 10.4 Transactions and concurrency
230 cards
3.7.2 Structured Query Language (SQL)
AQA GCSE Computer Science > 3.7 Relational databases and structured query language (SQL)
113 cards
Databases
24 cards