BADM 350 FINAL

Prof. sachdev

159 cards   |   Total Attempts: 188
  

Cards In This Set

Front Back
Application generation component
Includes tools for creating visually appealing and easy-to-use applications
Association detection
Reveals the degree to which variables are related and the nature and frequency of these relationships in the information
Attribute
Characteristics of properties of an entity class
Backward integration
Takes info entered into a given system and sends it automatically to all upstream systems and processes
Business intelligence
Information that people use to support decision making efforts
Business-critical integrity constraint
Enforces business rules vital to an organization's success and often requires more insight and knowledge than relational integrity constraints
Cluster analysis
A technique used to divide an information set into mutually exclusive groups such that members of each group are as close together as possible to one another and the dif groups are as far apart as possible
Cube
The common term for the representation of multidimensional info
Data
Raw facts that describe the characteristcs of an event
Data administration component
Provides tools for managaing the overall database environment by providing facilities for backup, recovery, security, and performance
Database
Maintains info abt various types of objects, events, people, and places (inventoy, transactions, employees, warehouses)
Database management system (DBMS)
Software through which users and application programs interact with a database
Data definition component
Helps create and maintain the data dictionary and the structure of the database
Data dictionary
A file that stores definitions of info types, identifies the primary and foreign keys, and maintains the relationships among the tables
Data manipulation component
Allows users to create, read, update, and delete info in a database