Study Guides (380,000)
CA (150,000)
(4)
BMK211 (6)

BMK211 Study Guide - Sql, Tuple, Text Mining


Department
Marketing
Course Code
BMK211
Professor
Adam James

This preview shows half of the first page. to view the full 3 pages of the document.
Attribute, 178- Each characteristic or quality describing a particular entity is called an
attribute
Bit, 178- represents the smallest unit of data a computer can handle
Byte, 178- A group of bits, represents a single character, which can be a letter, number, or
another symbol
Data administration, 195- is responsible for the specific policies and procedures through
which data can be managed as an organizational resource.
Data cleansing, 196- also known as data scrubbing, consists of activities for detecting and
correcting data in a database that are incorrect, incomplete, improperly formatted, or redundant
Data definition, 184- DBMS have a data definition capability to specify the structure of the
content of the database
Data dictionary, 185- an automated or manual file that stores definitions of data elements
and their characteristics
Data governance, 195- used to describe many of these activities. Data governance, which is
promoted by IBM, deals with the policies and processes for managing the available, usability,
integrity, and security of the data employed in an enterprise
Data inconsistency, 179- in which the same attribute may have different values
Data manipulation language, 185- used to add, change, delete, and retrieve the data in the
database
Data mart, 190- is a subset of the data warehouse in which a summarized or highly focused
portion of the organization’s data is put in a separate database for a specific population of users
Data mining, 191- is more discovery driven. Provides insights into corporate data that cannot
be obtained with OLAP by finding hidden patterns and relationships in large databases and
inferring rules from them to predict future behaviour
Data quality audit, 196- a structured survey of the accuracy and level of completeness of
the data in an information system
Data redundancy, 179- is the presence of duplicate data in multiple data files so that the
same data are stored in more than one place or location
Data warehouse, 189- is a database that stores current and historical data of potential
interest to decision makers throughout the company. The dat originate in many core operational
transaction systems, such as systems for sales, customer accounts, and manufacturing, and
may include data from Web site transactions
Database, 178- A group of related files makes up a database
Database (rigorous definition), 181- a more rigorous definition of a database is a collection
of data organized to serve many applications efficiently be centralizing the data and managing
redundant data.
Database administration, 195- is responsible for the specific policies and procedures
through which data can be managed as an organizational resource
Database management system (DBMS), 181- software that permits an organization to
centralize data, manage them efficiently, and provide access to the stored data by application
programs
Database server, 194- In a client/server environment, the DBMS resides on a dedicated
computer called a database server
Entity, 178- is a person, place, thing, or event about which we store and maintain information
Entity-relationship diagram, 187- This diagram illustrates the relationships among the
entities SUPPLIER, PART, LINE_ITEM, and ORDER
Field, 178- A grouping of characters into a word, a group of words, or a complete number is
called a field
File, 178- a group of records of the same type is called a file
Foreign key, 183- When the field Supplier_Number appears in the PART table, it is called a
foreign key and is essentially a lookup field to look up data about the supplier of a specific part
You're Reading a Preview

Unlock to view full version