Brainscape's Knowledge GenomeTM


Top Flashcards (Certified)
All Flashcards

ADM 1340 - App Tech Business > Data info > Flashcards

Data info Flashcards

1
Q

Database

A

a collection of organized data that allows access, retrieval, and use of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Data

A

raw facts that describe the characteristics of an event or object

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Information

A

Data converted into a meaningful and useful context

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

master data management (MDM)

A

processes to integrate data from various sources and enterprise apps in order to create unified view of data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

Document Management System (DMS)

A

hardware and software to manage, archive, and purge files and other electronic documents

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

enterprise content management (ECM)

A

aimed at managing the life-cycle of information from initial publication creation all the way through archival and eventually disposal.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

Database Management System (DBMS)

A

Facilitates access to centralized data, allows data to be managed efficiently, operates logical and physical views, Solves problems of traditional files environment

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

Traditional File Environment

A

Using one application at a time to manage data, leading to data issues

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

data redundancy

A

occurs when unnecessary duplicate information exists in a database

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

data inconsistency

A

occurs when the same data element has different values

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

Program-data dependence

A

When changes in program requires changes to data accessed by program

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

Data filtering and profiling

A

Inspecting the data for errors, inconsistencies, redundancies, and incomplete information.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

Data Quality

A

the process of correcting, standardizing, and verifying the integrity of the data

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

data synchronization

A

the process of Integrating, matching, or linking data from disparate sources

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

Data enrichment

A

Enhancing data using information from internal and external data sources.

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

data maintenance

A

checking and controlling data integrity over time

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
17
Q

relational database management system

A

Data are grouped into similar collections, called tables, and the relationships between tables are formed by using a common field

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
18
Q

Rows

A

in a database table this is used for the records of different entities

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
19
Q

Fields

A

In a database columns in the table; describes a characteristic of the record

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
20
Q

Key field

A

A field in a record that uniquely identifies instances of that record so that it can be retrieved, updated, or sorted

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
21
Q

Primary Key

A

A field (or group of fields) that uniquely identifies a given entity in a table

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
22
Q

Foreign Key

A

A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
23
Q

Physical view

A

the way that data is organized, specified and stored

24
Q

Logical View

A

how data appears to end user

25
Entity
A person, place, thing, transaction, or event about which information is stored
26
Entity Class
a collection of similar entities
27
attributes/characteristics
the properties of a entity class that are displayed as different fields
28
data dictionary
an automated or manual file that stores definitions of data elements and their characteristics
29
The data dictionary used in Microsoft access is called:
Design View
30
Metadata
data about data
31
what are the three operations of a relational DBMS
Select, Join, Project
32
Master data
Consistent and uniform set of identifiers and extended attributes that describe the core entities of the enterprise such as, customer, product, employee, vendor
33
data governance
an approach to managing information across an entire organization, a formal set of business processes and policies that are designed to ensure that data are handled in a certain , well-defined fashion
34
Transaction Data
generated and captured by operating systems, describe the business's activities or transactions
35
data quality audit
a structured survey of the accuracy and level of completeness of the data in an information system
36
Data Cleansing
Software to detect and correct data that are incorrect, incomplete, improperly formatted, or redundant. Enforces consistency among different sets of data from separate information systems
37
What are the stored data Formats?
Atomic Data, Binary Large Objects
38
Atomic Data
Data stored at their lowest level of granularity
39
binary large object (BLOB)
Large chunks of data stored as a single entity, because they cannot be handled in smaller chunks
40
relationship
a connection, association, or involvement between entities
41
degrees of relationships
Unary, Binary, Ternary
42
Cardinality
The maximum number of times an instance of one entity can be associated with an instance in the related entity
43
Connectivity
the classification of the relationship between entities
44
types of connectivity
One-to-one, one-to-many, and many-to-many
45
Business Rules
precise descriptions of policies, procedures, or principles in any organization that stores and uses data to generate information
46
Normalization
the process of removing redundant information from your table in order to improve storage efficiency, data integrity, and scalability. this process usually involves splitting existing tables into multiple ones
47
Form
A database object that simplifies the process of entering, editing, and displaying data from a table or query.
48
Report
A database object that presents information in a format that is easy to read and print.
49
Query
a set of instructions used to get data from one or more tables, from other queries or from a combination of the two, used to answer a specified question
50
parameter query
Query that prompts for input whenever it is used
51
select query
The most basic type of Access query that creates subsets of data, displayed in Datasheet view, that can be used to answer specific questions or to supply data to other database objects.
52
Criterion Query
a query that operates similar to a formula
53
Enterprise DBMS
process large organizational and workgroup databases
54
Personal DBMS
designed for smaller, simpler database applications
55
Data Warehouse
A copy of transaction data, designed for querying and reporting. a repository of historical data that are organized by subject to support decision makers in the organization
56
Data Mart
A low-cost, scaled-down version of a data warehouse that is designed for the end-user needs in a strategic business unit (SBU) or a department.

ADM 1340 - App Tech Business (5 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2025 Bold Learning Solutions. Terms and Conditions