Information Management

You are a DBMS and you need to look up the required data component structures and relationships, thus relieving programmers from having to code such complex relationships in each program. Which of the options below would you use?

• 
  

  An encoded sample

• 
  

  data dictionary

• 
  

  Performance tuning

• 
  

  An encrypted bit

 The movement to find new and better ways to manage large amounts of web- and sensor-generated data and derive business insight from it, while simultaneously providing high performance and scalability at a reasonable cost is referred to as "_____."

• 
  

  Big Data

• 
  

  Hadoop

• 
  

  Internet of Things

• 
  

  NoSQL

Business rules use simple language to establish definitions of entities, attributes, relationships, and constraints. For instance, a business rule establishing that entities can have multiple attributes, and that each available attribute may be associated with only one entity, might be stated as "An employee may be assigned multiple devices" and "Each device may be assigned to only one employee". Classify the relationship between EMPLOYEES and DEVICES in this example using shorthand notation.

• 1..1

• M:N

• 1:M

• *..*

One of the reasons we need database is because they are the best ways to store and manage ___.

• knowledge

• data

• information

• tracking

 Unstructured data is data that exists in its __?

• Original (raw) state

• Original (refined) state

• Original (altered) state

• Original (filtered) state

The term _____ refers to an organization of components that define and regulate the collection, storage, management, and use of data within a database environment.

• database system

• management system

• structured data

• transaction

 A _____ contains all of the attribute names and characteristics for each table in the system.

• relational schema

• database

• logical schema

• data dictionary

If a design has logical independence, it means the _____ can be changed without affecting the conceptual model.

• external schema

• 
  

  internal model

• 
  

  logical design

• 
  

  operating system

The database of a theater has a list of plays in the PLAY table and a customer's list in the CUSTOMER table. The relationship, CUSTOMER attended a PLAY, is M:N. Which of the following relations with the BRIDGE entity should be used instead?

• 1:M BRIDGE, CUSTOMER and 1:M BRIDGE, PLAY

• 1:M CUSTOMER, BRIDGE and 1:M PLAY, BRIDGE

• 1:M CUSTOMER, PLAY and 1:M PLAY, BRIDGE

• 1:M CUSTOMER, BRIDGE and 1:M BRIDGE, PLAY

 A database management system (DBMS) can be likened to__?

• A computer file

• A kitchen pantry

• A very well-organized electronic filing cabinet

• A book cabinet