IT Fundamentals Chapter 7

Which of the following is a way for programmers and others to make sense of complex business flows?

• 
  

  Microsoft Access

• 
  

  Data modeling

• 
  

  Database management system

• 
  

  Primary keys

Which of the following is found in one or more columns of data and contains a unique identifier for the row?

• 
  

  Relationship

• 
  

  Primary key

• 
  

  Attribute

• 
  

  Foreign key

Which data model focuses on high-level concepts?

• 
  

  Conceptual

• 
  

  Physical

  
  

• 
  

  Operational

• 
  

  Logical

Which data type uses historical data to make decisions in the present?

• 
  

  Analytical

• Conceptual

• Operational

  
  

• Logical

Which type of analytical data can help you make investment decisions?

• Machine

• Sensor

• Transactional

• Market

What is the general term for software that creates and manages databases?

• 
  

  MySQL

• DBMS

• Tables

• Microsoft Access

  
  

Which database object is essentially questions that we can ask the database?

• 
  

  Forms

• Queries

• Tables

• Reports

Which of the following makes it easier for users to enter data into their tables?

• Forms

• Reports

• Tables

• Queries

Which of the following DBMS programs is open source?

• 
  

  MySQL

• 
  

  Microsoft Access

• 
  

  Oracle Database

• 
  

  SQL Server

Which of the following database objects provides a summary of data?

• 
  

  Reports

• Queries

• Forms

• Tables