Exam 4: Databases and DataWarehouses

What is the drawback of using Social Security Numbers (SSN) as the primary key for tables of employees, hospital patients, students, or cable TV customers?

In a university database, the student table, with student ID as a primary key, is linked to the university department table through its primary key-department ID. In the student table, department ID is a ________.

________ refers to collections of data that are so enormous in size, so varied in content, and so fast to accumulate that they are difficult to store and analyze using traditional approaches.

What are the characteristics of high-quality information?

Roman Jade, an interior decorations company, stores employee details in its employee information system. The birth date of each employee is stored along with other details, including employee names. The relationship between the employee names and employee birth dates is a ________.

Which of the following is a disadvantage of using shadow systems?

Which of the following is an early database approach that allowed flexible links to support many-to-many relationships?

Master data management has more to do with technology than people, processes, and governance.

Documentation that contains the details of each field in every table, including user-friendly descriptions of the field's meaning, is known as ________.

Which of the following is a good master data management strategy?

Kris, an IT manager at Park Infosystems, is handling four projects simultaneously. Each project has loaned and shared resources from other teams. The relationship between Kris and the project that he is working on represents a ________.

What is the main drawback of using unstructured information?

While using a word processor to create a project report, Ashley includes the subject, title, and the author's name in the report's properties. What type of information is Ashley adding to her report?

A database schema is used to ________.

In enterprise information management, data ownership issues arise because ________.

Which of the following do database developers use to avoid anomalies that result when users try to insert, edit, or delete data?

Which of the following databases resembles an organizational chart?

Define relational database. Why are relational databases a standard in most organizations?

Which of the following technologies is better equipped than relational databases to handle big data?

Retrieval is very fast through data cubes because ________.