Unit J: Database Basics
TRUE/FALSE
1. A fixed-length field automatically adds blank spaces if the data you enter is shorter than the allocated
length.
2. Microsoft Outlook is a computer database.
3. A Rolodex is an example of an unstructured file.
4. Computer databases typically display records as rows in a table or as a form.
5. A record occurrence is sometimes called a table.
6. Relational databases are the most popular models today.
7. In a network database, data is stored in a single collection of related tables, and all of the records in a
table are of the same data type.
8. In a network database, a set contains both a parent and child node.
9. In a hierarchical database, each parent node can have only one child node.
10. Some spreadsheet software can be used to create flat database files.
11. Most database projects today are implemented with RDBMS software.
12. Microsoft Excel is an example of RDBMS software.
13. Data independence means keeping data separated from the programs that manipulate data.
14. The figure above demonstrates Static Web publishing.
15. The way you query an XML database depends on how it was created, where it is stored, and whether
you have authorization.
16. A downside to storing data in an XML document is that it is not portable.
17. XML is most often used for structured data.
18. Integer data types are whole numbers.
19. Computers store real numbers in a different format than integers.
20. A conversion routine brings data into a database.
21. An input mask specifies the format in which a field’s data should be entered.
22. Using normalization, database designers can create a clickable list for data entry.
23. The figure above is an example of a printed database report.
24. A report template is an interactive screen that walks you through data organization and presentation.
25. Data in a descending alphanumeric sort appears as 123 or ABC.
26. OLAP systems can be used to look for relationships among multiple data dimensions.
27. Simple data analysis can be used to predict future trends.
28. Entry-level DBMSs, such as Microsoft Access, typically provide tools to support data warehouses.
MULTIPLE CHOICE
1. A(n) ____ contains the smallest unit of meaningful information in a database.
a.
field
c.
variable
b.
record
d.
table
2. A(n) ____-length field expands to fit the data entered, up to a maximum number of characters.
a.
fixed
c.
maximum
b.
variable
d.
flexible
3. A record ____ is defined by the database designer and is a group of fields in the database.
a.
variable
c.
type
b.
occurrence
d.
field
4. In Microsoft Access, a record type is called a(n) ____.
a.
occurrence
c.
field name
b.
field
d.
table
5. The number of associations possible between record types is called ____.
a.
functionality
c.
entities
b.
cardinality
d.
attributes
6. A(n) ____-relationship diagram depicts the relationships between record types.
a.
entity
c.
field
b.
object
d.
attribute
7. The database shown in the above figure is an example of a(n) ____ database.
a.
network
c.
cardinal
b.
relational
d.
hierarchical
8. In the figure above, all of the relationships are classified as: ____.
a.
one–to–one
c.
one–to-many
b.
one–to-all
d.
many-to-many
9. In the figure above, the top node is the ____ node.
a.
parent
c.
root
b.
child
d.
top
10. In a network database, a(n) ____ is the rough equivalent to a child record type.
a.
root
c.
owner
b.
node
d.
member
11. When many network users are making updates simultaneously, database ____ software should be
used.
a.
distribution
c.
server
b.
client
d.
workstation
12. A(n) ____ database is stored on different computers or networks.
a.
relational
c.
server
b.
hierarchical
d.
distributed
13. In the figure above, users see a Web page that reflects their preferences, indicating that it was created
using ____ Web publishing.
a.
dynamic
c.
client
b.
static
d.
personal
14. A server-side program is another term for a(n) ____.
a.
XML document
c.
HTML document
b.
script
d.
Xform
15. Which of the following is NOT an example of a program used to create server-side programs?
a.
ASP
c.
ERD
b.
CGI
d.
PHP
16. A(n) ____ is an object in a Web page that contains fields used to collect information.
a.
tag
c.
attribute
b.
table
d.
form
17. The arrangement of fields, tables and relationships is called the database ____.
a.
layout
c.
format
b.
structure
d.
hierarchy
18. If you want to store data as one of two options, such as True or False, assign a(n) ____ data type.
a.
character
c.
logical
b.
memo
d.
BLOB
19. A field ____ rule is a specification such as a range or maximum for a field.
a.
validation
c.
normalization
b.
specification
d.
integrity
20. Which of the following is NOT an action that can ensure data integrity?
a.
Input masks
c.
Key fields
b.
Lookup routines
d.
Data cubes
21. The albums in the figure above are sorted by: ____.
a.
Album Name
c.
Artist Name
b.
Discount Price
d.
Qty in Stock
22. Which of the following is NOT a characteristic of an effective database report?
a.
Only the required information is presented.
b.
Information is delivered in a timely manner.
c.
Titles, page numbers, dates, labels, and headings should be included.
d.
Buttons or controls can help move between records.
23. A data ____ is a collection of information organized for analysis.
a.
mine
c.
cube
b.
query
d.
warehouse
24. Populating data warehouses usually requires custom ____ routines.
a.
conversion
c.
export
b.
entry
d.
analysis
25. ____ analytics focus on anticipating future probabilities and trends.
a.
Data cubing
c.
Classification
b.
Predictive
d.
OLAP
COMPLETION
1. When you register online for a class or order items from an online retailer, you are probably
interacting with a(n) ____________________.
2. A(n) ____________________ file uses a uniform format to store data for each item in the file.
3. A(n) ____________________ file is one that contains only one record type.
4. Each field has a unique field ____________________ that describes its contents.
5. Each ____________________ in a database stores data about one entity.
6. A(n) object ____________________ is any behavior that an object is capable of performing.
7. A(n) ____________________ is the association between data stored in different record types.
8. A(n) ____________________ database allows both one-to-many and many-to-many relationships.
9. DBMS stands for ______________________________.
10. Database ____________________ software allows remote computers or network workstations to
access database data.
11. Data ____________________ allows a single data management tool to be used to maintain many
different files and databases.
12. ___________________________________ is a markup language that allows field tags, data, and table
to be incorporated into a Web document.
13. ____________________ Web publishing converts database reports into HTML documents.
14. The figure above demonstrates ____________________ Web publishing
15. You should store telephone numbers, ZIP codes, and Social Security Numbers as
____________________ fields.
16. A(n) ____________________ data type is a picture or graphic.
17. A(n) ____________________ key is a field that contains data unique to a record.
18. A table’s ____________________ order is the order in which records are stored on disk.
19. Data ____________________ is the process of interpreting information to discover trends and
patterns.
20. Information used for OLAP queries can be represented as a data ____________________.
21. Data ____________________ is the method used to clarify hidden relationships.
MATCHING
Match the database term with its definition.
a.
Relational database
e.
Flat file
b.
Network database
f.
Variable-length field
c.
Hierarchical database
g.
DBMS
d.
ERD
h.
Distributed database
1. Graphic depiction of relationships between record types.
2. Difficult to maintain, create, and manipulate.
3. Like an accordion, expands to fit the data you enter.
4. The simplest database model.
5. A database stored on different computers or networks, or in different locations.
6. Software designed to manage database data.
7. Most popular database model today.
8. A structured file that contains only one record type.
Match the data type with its description or sample data.
a.
Real
e.
Text
b.
Integer
f.
Memo
c.
Date
g.
BLOB
d.
Logical
h.
Hyperlink
9. 5
10. Zip codes and names
11. Numbers that include decimal places
12. URLs
13. Variable-length comment field
14. Yes or No; True or False
15. Month, day, and year
16. An MP3 file
Match the database term with its description.
a.
Data warehouse
d.
Sorted tables
b.
Data mining
e.
Primary key
c.
OLAP System
17. A system of hardware, database software, and analytical tools.
18. A collection of information organized for analysis.
19. Examples include: SocialSecurityNumber or CustomerNumber.
20. Produce faster queries and updates.
21. Using statistical tools to extract hidden relationships.
ESSAY
1. Describe the types of databases that might work well for the following situations: an end-user who
wants to store names and addresses, and a business where many users will be making updates at the
same time.
2. Describe the differences between the following three database types: hierarchical, network, and
relational.
3. Describe different methods for entering or bringing data into a database.
ANS:
4. List some of the actions you can take to ensure the integrity of the data in your database.
5. List five tips for database designers to consider when designing data entry screens.
ANS:
