Databases and Business Intelligence

5 cards   |   Total Attempts: 188
  

Related Topics

Cards In This Set

Front Back
Question 1
Business intelligence: Collective information that gives you the ability to make effective, important, and strategic business decisions.
Answer 1
äDatabase management system (DBMS) – helps you specify the logical requirements for a database and access and use the information in a database.
Database: Collection of information that you organize and access according to the logical structure of the information.
Answer 2
View : Allows you to see the contents of a database file, make changes, and query it to find information.
Question 3
Data dictionary: contains the logical structure for the information in a database.
Report generator : Helps you quickly define formats of reports and what information you want to see in a report.
Question 4
äForeign key: Primary key of one file that appears in another file
SQL: Standardized fourth-generation query language found in most DBMSs
Question 5
Primary key: field (or group of fields) that uniquely describes each record.
QBE tool : Helps you graphically design the answer to a question.