20) Which of the following is false regarding a well-structured relational database?
A) A foreign key cannot be null.
B) A primary key cannot be null.
C) Every column in a row must be single valued.
D) All nonkey attributes in a table must describe a characteristic of the object identified by the
primary key.
4.5 Create a set of well-structured tables to store data in a relational database.
1) In a relational database, requiring that every record in a table have a unique identifier is called
the
A) entity integrity rule.
B) referential integrity rule.
C) unique primary key rule.
D) foreign key rule.
2) The database requirement that foreign keys must be null or have a value corresponding to the
value of a primary key in another table is formally called the
A) entity integrity rule.
B) referential integrity rule.
C) unique primary key rule.
D) foreign key rule.
3) In a well-structured database, the constraint that ensures the consistency of the data is known
as the
A) entity integrity rule.
B) referential integrity rule.
C) unique primary key rule.
D) foreign key rule.
4) Identify the statement below that is false with regards to basic requirements of a relational
database model.
A) Primary keys can be null.
B) Foreign keys, if not null, must have values that correspond to the value of a primary key in
another table.
C) All non-key attributes in a table should describe a characteristic about the object identified by
the primary key.
D) Every column in a row must be single-valued.
5) Identify the aspect of a well-structured database that is incorrect.
A) Data is consistent.
B) Redundancy is minimized and controlled.
C) All data is stored in one table or relation.
D) The primary key of any row in a relation cannot be null.
6) In the database design approach known as normalization, the first assumption made about data
is
A) there is no redundancy in the data.
B) the delete anomaly will not apply since all customer records will be maintained indefinitely.
C) everything is initially stored in one large table.
D) the data will not be maintained in 3NF tables.
7) The database design method in which a designer uses knowledge about business processes to
create a diagram of the elements to be included in the database is called
A) normalization.
B) decentralization.
C) geometric data modeling.
D) semantic data modeling.
8) Which of the statements below is incorrect?
A) Semantic data modeling facilitates the efficient design of databases.
B) Semantic data modeling facilitates communicating with the intended users of the system.
C) Semantic data modeling allows a database designer to use knowledge about business
processes to design the database.
D) Semantic data modeling follows the rules of normalization in the design of a database.
9) Ama Afolayan is chair of the National Owl Society, which maintains a database of all rare
owls within the United States. One table will store the name, birth date, and other characteristics
of all of the owls that have been registered. Each owl is uniquely identified by a registration
number. A second table will contain data that link each owl to its male and female parents by
means of their registration numbers. The primary key in the first table is
A) name.
B) birth date.
C) the primary key in the second table.
D) a foreign key in the second table.
10) Ama Afolayan is chair of the National Owl Society, which maintains a database of all rare
owls within the United States. One table will store the name, birth date, and other characteristics
of all of the owls that have been registered. Each owl is uniquely identified by a registration
number. A second table will contain data that link each owl to its male and female parents by
means of their registration numbers. The primary key in the second table is
A) name.
B) birth date.
C) the same as the primary key in the first table.
D) a combination of primary keys in the first table.
11) Ama Afolayan is chair of the National Owl Society, which maintains a database of all rare
owls within the United States. One table will store the name, birth date, and other characteristics
of all of the owls that have been registered. Each owl is uniquely identified by a registration
number. A second table will contain data that link each owl to its male and female parents by
means of their registration numbers. The entities described by the second table are
A) owls.
B) parental relationships.
C) registration numbers.
D) names.
12) Kekoa Konani is chairman of the Chatty Chihuahua Club, where he maintains a database of
registered purebred Chihuahuas and their breeding history. One table will store the name, birth
date, and other characteristics of all of the registered Chihuahuas. Each Chihuahua is uniquely
identified by a registration number. A second table will contain data that link each Chihuahua to
its male and female parents by means of their registration numbers. The entities described by the
first table are
A) marmosets.
B) parental relationships.
C) registration numbers.
D) names.
13) Kekoa Konani is chairman of the Chatty Chihuahua Club, where he maintains a database of
registered purebred Chihuahuas and their breeding history. One table will store the name, birth
date, and other characteristics of all of the registered Chihuahuas. Each Chihuahua is uniquely
identified by a registration number. A second table will contain data that link each Chihuahua to
its male and female parents by means of their registration numbers. The primary key in the first
table is
A) name.
B) registration number.
C) date of birth.
D) relationship number.
14) Kekoa Konani is chairman of the Chatty Chihuahua Club, where he maintains a database of
registered purebred Chihuahuas and their breeding history. One table will store the name, birth
date, and other characteristics of all of the registered Chihuahuas. Each Chihuahua is uniquely
identified by a registration number. A second table will contain data that link each Chihuahua to
its male and female parents by means of their registration numbers. The primary key in the
second table is
A) name.
B) registration number.
C) date of birth.
D) relationship number.
15) Kai Keoni has created custom statues made out of scrap metal for over ten years. He lives
above his shop in Martha’s Vinyard, Maryland. Kai is an accounting fanatic and has kept detailed
records of every statue he has ever created. For every sale, he obtains the customer’s name and
address, a description of the statue, and a picture of the statue sold to the customer. His unique
style has recently attracted the attention of several celebrities. Ready to take his business to the
next level, Kai has hired you to construct an accounting information system, which he wants
modeled after his paper records. You begin development of the relational database that will form
the core of the AIS by envisioning the record stored in a single table with a column that
represents each attribute. You then begin to break this table down into smaller tables. This
process is called
A) integration.
B) optimization.
C) minimization.
D) normalization.
16) Helen Fume is a recruiter with The Ladders in Nome, Alaska. The Ladders success is largely
attributable to its accounting information system. When a client is hired by an employer, Helen
creates a record that identifies the employment relationship. Helen follows up on placements by
surveying both employers and clients about the employment experience and then entering the
results into the AIS. Clients are uniquely identified by social security number. In records that
contain client survey data, the social security number is likely to be
A) the primary key.
B) a foreign key.
C) combined with other data fields to form a primary key.
D) null.
17) Which of the following would not be one of the well-structured tables in a well-designed
relational database used to generate this sales invoice?
A) Customer Order
B) Customer
C) Sales
D) Sales Order
18) Which of the following would not be true about the well-structured tables in a well-designed
relational database used to generate this sales invoice?
A) Quantity would be generated from the Sales table.
B) 34567 would be a primary key in the Sales table.
C) Unit Price would be generated from the Inventory table.
D) Hardware City is an example of a non-key data value in the Customer table.
19) Seacrest Bedding is changing from a file-oriented system to a relational database system.
Identify and design at least three tables that would be needed to capture data for a sales
transaction. Each table should include a primary key, three non-key attributes, and foreign keys
as necessary. Make up data values for two records within each table.
20) Which of the following elements link rows in one table to rows in another table?
A) primary keys
B) foreign keys
C) semantic keys
D) link keys
21) Suppose a relational database contained two linked tables. Which of the following items is
not necessarily present in the database?
A) two primary keys
B) two foreign keys
C) at least one column
D) one foreign key
28
22) Suppose a relational database contained two linked tables. Assuming the organization wants
the database to be normalized, which of the following items represents a problem to
normalization?
A) The database contains only one primary key.
B) The database contains two foreign keys.
C) The database contains two primary keys.
D) The database contains only one foreign key.
4.6 Perform simple queries using the Microsoft Access database.
1) Which one of the following results corresponds to the query below?
A)
B)
C)
D)
2) Which one of the following results corresponds to the query below?
A)
B)
C)
D)
3) Which one of the following results corresponds to the query below?
A)
B)
C)
D)
4) Using the database depicted below, “Date” is best described as
A) a primary key.
B) a foreign key.
C) a non-key attribute.
D) an attribute.
5) Using the database depicted below, how many primary keys are in the database?
A) 0
B) 3
C) 4
D) 5
6) Using the database depicted below, how many foreign keys are in the database?
A) 0
B) 3
C) 4
D) 5
7) Using the database depicted below, “Item #” is best described as
A) an attribute.
B) a primary key.
C) a foreign key.
D) A, B, and C
8) Using the database depicted below, “Unit Price” is best described as
A) an attribute.
B) a primary key.
C) a foreign key.
D) A, B, and C
9) Using the database depicted below, in the Sales table, “Customer #” is best described as
A) an attribute.
B) a primary key.
C) a foreign key.
D) A, B, and C
10) In the Customer table below, “Customer #” is best described as
A) an attribute.
B) a primary key.
C) a foreign key.
D) A, B, and C
11) In the Inventory table below, “Item number” is best described as
A) an attribute.
B) a primary key.
C) a foreign key.
D) A, B, and C