WorksheetsDatabase Design
Total questions: 25
Worksheet time: 28mins
What is a database?
A collection of software programs
A structured collection of data
A type of computer hardware
A way to browse the internet
A (a) is an organized collection of data.
Which of the following is a common Database Management System (DBMS)?
MS Excel
MS Word
MS DTP
MS Access
Electronic databases have several
(a) over manual databases.
misadventures
advanteges
What is a primary key in a database?
A special key for opening the database
A unique identifier for each record in a table
A key used to lock the database
A password to access the database
Amount outstanding
Street Address
Available
Last visit
A _______ or label usually displays data for every field of a single record.
form
table
dictionary
sheet
(a) is the number of characters allowed in each field.
A (a) key is a field where each item is unique and must have a value.
secondary
prime
Identify the primary key in the form displayed.
Address
Post Code
Contact ID
Last Name
Data in a table is usually entered using a (a) , retrieved using a query and printed using a report.
formula
pen
Identify the fields in the adjacent table:
Mickey, Last Name, Address
First Name, Last Name, 73
First Name, Last Name, Address, City, Age
Mickey, Mouse, 123 Fantasy Way, Anaheim, 73
The adjacent table has 5 (a) and 8 (b) .
files
items
A primary source is data that is collected first hand. The following are examples of primary sources:
Internet, Newspapers, books
Interviews, surveys, observation
Newspapers, surveys
Observations, books
Organize these options into the right categories of the data dictionary.
First name
Hyperlink
30
Describe contents....
A (a) or list displays data using columns (fields) and rows (records).
A table or list displays data alled ( (a) ) and rows
called ( (b) ).
files
items
A (a) database organises data into a single table.
Organizations store vast amounts of data and need to organize their data using a series of related tables. These are called (a) databases.
The adjacent table is an example of a _________ database.
Relational
Flat file
Single
Multiple
Electronic databases have several advantages over manual databases.
(a)
Electronic databases can (a) large quantities of information using storage devices such as USB, online, and backups.
Electronic databases can search and sort data (a) and accurately to obtain the required information.
With electronic databases, data is updated
without having to (a) all the data
Electronic databases can (a) (show) information in different ways using tables, forms, and reports.
