HOME
|
SIGN IN TO GLOW
|
SCHOOL WEBSITE
General
Purpose Packages
Automated
Systems
Commercial Data
Processing
Computer Systems
Hardware
Computer Systems
Software
Programming
Course
Arrangements
Standard Grade Home
Basic Operations
1. Database Home
2. Sorting
3. Searching
4. Adding & Editing Records
Advanced Topics & Practice
5. Validation & Uniqueness
6. Practice
Football Teams
Movies
7. Computed Fields
8. Passwords
9. Format & Layout
10. Creating a New Layout
11. Creating a New Database
Expert Systems
Summary & Revision
Helpful Extras
Index
Glossary
Arrangements
Homework
Foundation
General
Credit
Credit Homework Questions
Database Homework 1
Name:
Email:
(optional)
1
CHOOSE YOUR TEACHER FROM THE OPTIONS BELOW
Mr McGivern
Mrs Smith
Mr Munro
Mr Carey
2
A car loans company keep a database of all their customers loan details.
An extract from one record is shown below:
What is a company legally obliged to do before storing personal information on a computer?
[KU]
(1 point)
Resource 1
3
The company gives a gift voucher to all clients who have paid off a loan of £8000 or more.
How can the database be used to find a list of customers who are entitled to this offer?
[PS]
(2 points)
4
What is a
computed field
in a database?
[KU]
(1 point)
5
Write down the name of a field shown above which is likely to be a computed field.
[PS]
(1 point)
Address
Amount outstanding
Postcode
Total Loan
Period of Loan (months)
Customer ID
Surname
Monthly repayment
Number of payments made
Forename
6
The database stores 100 000 records. Calculate the storage requirements in
Megabytes
, stating clearly any assumptions that you make.
[PS]
(3 points)
7
What validation check could be performed on the
Period of Loan
field?
[KU]
(1 point)
8
What is the name used for this type of validation check?
[KU]
(1 point)
Home
|
S1 Topics
|
S2 Topics
Computing Standard Grade
|
Info Systems Intermediate II
|
Info Systems Higher
|
Internet Safety
Log into Glow
|
School Website
|
Contact Us
Credit Homework Questions
