+
Related Flashcards
Cards In This Set
| Front | Back |
 Business intelligence (BI) |
Collective information that gives you the ability to make effective, important, and strategic business decisions.it will help us to use the information to take a business decisions.
|
 Analytics |
The science of fact-based decision making (statistics).
|
 Database |
collection of information that you organize and access according to the logical structure of the information.- we store the data in the database.
|
 Relational database |
Series of logically related two-dimensional tables or files for storing information- the tables that is inside the database should be related and connected.
|
 Data dictionary |
Contains the logical structure for the information in a database.- it helps us to know the definition of the details.
|
 Primary key |
Field (or group of fields) that uniquely describes each record
|
 Foreign key |
Primary key of one file that appears in another file
|
 Integrity constraints |
Rules that help ensure the quality of information
|
 Database management system (DBMS) |
Helps you specify the logical requirements for a database and access and use the information in a database.- It is like a software we can create and records, it helps us to use the information.
|
 DBMS engine |
Accepts logical requests and converts them into the physical equivalents, and access the database and data dictionary on a storage device like MS ACCESS
|
 Physical view |
how information is physically arranged, stored, and accessed on a storage device
|
 Logical view |
How you need to arrange and access information to meet your needs
|
 Data definition subsystem |
Helps you create and maintain the data dictionary and structure of the files in a database
|
 Data manipulation subsystem |
Helps you add, change, and delete information in a database and query it to find valuable information
|
 View |
Allows you to see the contents of a database file, make changes, and query it to find information
|
