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
Q

Entity

A

A person, place, thing, transaction, or event about which information is stored

26
Q

Entity Class

A

a collection of similar entities

27
Q

attributes/characteristics

A

the properties of a entity class that are displayed as different fields

28
Q

data dictionary

A

an automated or manual file that stores definitions of data elements and their characteristics

29
Q

The data dictionary used in Microsoft access is called:

A

Design View

30
Q

Metadata

A

data about data

31
Q

what are the three operations of a relational DBMS

A

Select, Join, Project

32
Q

Master data

A

Consistent and uniform set of identifiers and extended attributes that describe the core entities of the enterprise such as, customer, product, employee, vendor

33
Q

data governance

A

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
Q

Transaction Data

A

generated and captured by operating systems, describe the business’s activities or transactions

35
Q

data quality audit

A

a structured survey of the accuracy and level of completeness of the data in an information system

36
Q

Data Cleansing

A

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
Q

What are the stored data Formats?

A

Atomic Data, Binary Large Objects

38
Q

Atomic Data

A

Data stored at their lowest level of granularity

39
Q

binary large object (BLOB)

A

Large chunks of data stored as a single entity, because they cannot be handled in smaller chunks

40
Q

relationship

A

a connection, association, or involvement between entities

41
Q

degrees of relationships

A

Unary, Binary, Ternary

42
Q

Cardinality

A

The maximum number of times an instance of one entity can be associated with an instance in the related entity

43
Q

Connectivity

A

the classification of the relationship between entities

44
Q

types of connectivity

A

One-to-one, one-to-many, and many-to-many

45
Q

Business Rules

A

precise descriptions of policies, procedures, or principles in any organization that stores and uses data to generate information

46
Q

Normalization

A

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
Q

Form

A

A database object that simplifies the process of entering, editing, and displaying data from a table or query.

48
Q

Report

A

A database object that presents information in a format that is easy to read and print.

49
Q

Query

A

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
Q

parameter query

A

Query that prompts for input whenever it is used

51
Q

select query

A

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
Q

Criterion Query

A

a query that operates similar to a formula

53
Q

Enterprise DBMS

A

process large organizational and workgroup databases

54
Q

Personal DBMS

A

designed for smaller, simpler database applications

55
Q

Data Warehouse

A

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
Q

Data Mart

A

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.