Query Result
c. List all of the property appraisers.
Query
Query Result
List all of the lenders.
Query
…
…
Query Result
Query
d. List the lenders that lent more than $100,000.
….
NOTE: In order to get a list of lenders without duplicates the property sheet of the query needs to be
f. Which borrower requested the largest mortgage?
Notice that in the Design section on the ribbon, you must set the Return value to 1 (located in the Query
Setup group). This indicates to Access to only return the top result. See the image below for a screenshot
of this. …
….
Query Result
Query
..
…
4.11 Answer the following Multiple Choice Questions (Correct solutions bolded)
1. With respect to data warehouses, databases, and files, which of the following statement(s)
is (are) true?
a. Analyzing large amounts of data for strategic decision making is often referred to
b. Databases were developed to address the proliferation of master files, which
c. A DBMS manages and controls the interface between stored data and the
2. With respect to data warehouses, databases, and files, which of the following statement(s)
is (are) true?
a. A problem with databases is data inconsistencies as the same data is stored in two
or more master files
e. Data sharing refers to data and the programs that use them being independent of
3. With respect to data warehouses, databases, and files, which of the following statement(s)
is (are) true?
a. Cross-functional analysis refers to combining master files in to larger pools of
b. In the master file approach, data is an organizational resource used by and
c. Data warehouses complement transaction processing databases by providing
d. OLAP is using sophisticated statistical analysis to find unhypothesized
With respect to data warehouses, databases, and files, which of the following statement(s) is (are)
true?
f. The database controller (DBC) is responsible for coordinating, controlling, and
g. Since strategic decision making requires access to large amounts of historical
4. With respect to databases and files, which of the following statement(s) is (are) true?
a. There is a record in the data dictionary that describes each file in the database
5. With respect to database systems, which of the following statement(s) is (are) true?
a. A record layout shows the items stored in a file, including the type of data
stored and both the order and length of the data fields.
6. With respect to database systems, which of the following statement(s) is (are) true?
a. A subschema can prevent access to those portions of the database that do not
b. A report writer is a high-level, English-like language with powerful, easy-to-use
c. The DDL and DML should be restricted to authorized administrators and
d. DBMS software links the way data are physically stored with each user’s
7. With respect to relational databases, which of the following statement(s) is (are) true?
a. A foreign key is only found in one table; it is not allowed to be in another table
b. When data about objects of interest are stored in separate database tables, it
SUGGESTED ANSWERS TO THE CASE
4.1 As in all areas of IT, DBMSs are constantly changing and improving. Research how
businesses are using DBMSs, and write a report of your findings. Address the following issues:
1. Which popular DBMS products are based on the relational data model?
2. Which DBMS products are based on a logical model other than the relational data
model?
3. What are the relative strengths and weaknesses of the different types (relational versus
other logical models) of DBMSs
No single answer exists with this case; indeed, solutions will vary depending upon student ingenuity and
Relational DBMSs include DB2, Oracle, SQL Server and Access.
Many newer products are based on the object-oriented data model, or are a hybrid of the
Hierarchical and network DBMSs often provide performance advantages–especially in terms
of processing speed. Those advantages, however, usually come at the cost of making it much