Question 1

Emma Kolb is a system analyst at a manufacturing company located in the Midwest.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the production and sales departments use database systems that are entirely separated,she recommends that they be combined.Implementation of her recommendation would benefit the company by contributing to data

Accepted Answer

A) independence. 
B) integration. 
C) redundancy. 
D) qualifications.

Question 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

Accepted Answer

A) entity integrity rule. 
B) referential integrity rule. 
C) unique primary key rule. 
D) foreign key rule.

Question 3

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?

Accepted Answer

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.

Question 4

Kitchen World is changing its inventory system 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 Kitchen World's inventory.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.

Accepted Answer

The answer of Kitchen World is changing its inventory system...

Question 5

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

Accepted Answer

A) normalization. 
B) decentralization. 
C) geometric data modeling. 
D) semantic data modeling.

Question 6

Which would not generally be considered a data dictionary output report?

Accepted Answer

A) a list of cash balances in the organization's bank accounts 
B) a list of all programs in which a data element is used 
C) a list of all synonyms for the data elements in a particular file 
D) a list of all data elements used by a particular user

Question 7

Emma Kolb is a system analyst at a manufacturing company located in the Midwest.She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements.After noting that the several key managers do not have access to the production and sales information,she recommends that they should be uploaded to the company's internal network and be made available for search.Implementation of her recommendation would benefit the company by contributing to

Accepted Answer

A) data independence. 
B) data integration. 
C) reduce data redundancy. 
D) increase data sharing.

Question 8

Which of the following is false regarding a well-structured relational database?

Accepted Answer

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.

Question 9

Mara Kay is a system analyst for a national department store.She was tasked to identify previously unknown relationships in the company's sales data that can be used in future promotions.What technique would Mara most likely use?

Accepted Answer

A) Customer auditing 
B) Customer resource management 
C) Data exploring 
D) Data mining

Question 10

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

Accepted Answer

A) the primary key. 
B) a foreign key. 
C) combined with other data fields to form a primary key. 
D) null.

Question 11

When the human resources manager wants to add a new employee to the sales department,the manager would use which language?

Accepted Answer

A) Data Manipulation Language 
B) Data Query Language 
C) Data Report Language 
D) Data Definition Language

Question 12

The ________ occurs when more than one occurrence of a specific data item in a database exists.

Accepted Answer

A) inconsistency anomaly 
B) insert anomaly 
C) delete anomaly 
D) update anomaly

Question 13

Reports produced using the data dictionary could include all of the following except a list of

Accepted Answer

A) programs where a data item is used. 
B) synonyms for the data items in a particular file. 
C) outputs where a data element is used. 
D) the schemas included in a database.

Question 14

The combination of the database,the DBMS,and the application programs that access the database through the DBMS is referred to as the

Accepted Answer

A) data warehouse. 
B) database administrator. 
C) database system. 
D) database management system.

Question 15

In a well-structured database,the constraint that ensures the consistency of the data is known as the

Accepted Answer

A) entity integrity rule. 
B) referential integrity rule. 
C) unique primary key rule. 
D) foreign key rule.

Question 16

The ________ handles the link between the way data are physically stored and each user's logical view of that data.

Accepted Answer

A) database management software (DBMS) 
B) database manager 
C) data warehouse 
D) data dictionary

Question 17

-Using the database depicted above,"Unit Price" is best described as

Accepted Answer

A) an attribute. 
B) a primary key. 
C) a foreign key. 
D) A,B,and C

Question 18

How do users retrieve data stored in a database?

Accepted Answer

A) by viewing the appropriate data tables 
B) by executing a query 
C) by performing a search 
D) by specifying the primary keys

Question 19

Abby Burke has created custom statues made out of scrap metal for over ten years.Abby has kept detailed records of every statue she has ever created.For every sale,she obtains the customer's name and address,a description of the statue,and a picture of the statue sold to the customer.Her unique style has recently attracted the attention of several celebrities.Ready to take her business to the next level,Abby has hired you to construct an accounting information system,which she wants modeled after her paper records.As you look over her records,you notice that some customer last names have different first names in different records.For example,R.Framington Farnsworth,Bob Farnsworth,and Sam Farnsworth all seem to be the same person.You explain to Abby that every customer must be identified by a unique customer number in the AIS.You are referring to the

Accepted Answer

A) entity integrity rule. 
B) referential integrity rule. 
C) update anomaly. 
D) insert anomaly.

Question 20

A set of individual user views of the database is called the

Accepted Answer

A) conceptual-level schema. 
B) internal-level schema. 
C) external-level schema. 
D) meta-schema.

Exam 4: Relational Databases