Exam 4: Managing Information Resources with Databases

A model used for planning the organization's database that identifies what kind of information is needed, what entities will be created, and how they are related to one another is called a(n) ________.

Which of the following is the best approach while handling complex relationships, such as the data for a company where employees can be assigned to more than one project and each project can have more than one employee assigned to it?

Changes to the integrated database take less time from IT, but more from the end users.

While designing the relational database for DD-Designs, Devon Degosta wanted to add the departmental phone number to the employee ID. Why was this problematic and what was the solution?

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

What role does metadata play in relation to information?

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 do database developers use to avoid anomalies that can happen when users try to insert, edit, or delete data?

What are the ways in which information is classified in terms of structure? Explain with examples.

Which product offers voice commands sequenced like a natural conversation, as a means to access a database?

Information is structured if facts and data ________.

Which of the following is a type of intelligence gathering that uses statistical techniques to explore records in a data warehouse, hunting for hidden patterns and relationships that are undetectable in routine reports?

Which of the following is the most widely used database architecture?

What does functional dependence mean? Illustrate with an example.

Interactive voice response (IVR) is a system used to handle massive call volumes.

The separate file processing system leads to the creation of redundant information because ________.

Database architecture which has multidimensional data grouped in logical dimensions such as sales by product, city, region, and country, is called ________.