Exam 4: Relational Databases

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

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

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?

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 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

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

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

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

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?

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

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

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

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

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

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

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

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

How do users retrieve data stored in a database?

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

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