FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Relational Databases

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 41

Multiple Choice

Review LaterAdd Note

Review Later

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.

E) A) and D)
F) All of the above

Correct Answer

verified

Show Answer

Question 42

Multiple Choice

Review LaterAdd Note

Review Later

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

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

E) B) and C)
F) All of the above

Correct Answer

verified

Show Answer

Question 43

Multiple Choice

Review LaterAdd Note

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

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

How do users retrieve data stored in a database?

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?

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

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

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

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

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

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

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

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?

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

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

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

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

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.

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