Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

Business Process > busn ex. 2 > Flashcards

busn ex. 2 Flashcards

ch 6.1 and 6.2

1
Q

airline ticket
sales receipt
packing slip

A

transactional data

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

product statistics
sales production
future growth
trends
analytical data

A

analytical data

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

means immediate and up to date data

A

real-time data

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

occurs when the same data elements has different values.

A

data inconsistency

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

occur when a system produces incorrect or inconsistent or duplicate data

A

date integrity issues

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

what are the 5 common characteristics of high -quality data

A

accurate
complete
consistent
timely
and unique

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

data: is there an incorrect value in data?

A

accurate data

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

data: is there a value missing

A

complete

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

is aggregate or summary data in agreement with detected data?

A

consistent

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

is the data current with respect to business needs

A

timely

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

is each transaction and event represented only once in the data?

A

unique

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

refers to the overall management of the availability, usability, integrity and security of company data

A

data governance

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

what system create, reads, updates, and deletes data in a database while controlling access and security.

A

database management system

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

complies all of the metadata about the data elements in the data model

A

data dictionary

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

data element

A

the smallest or basic unit of data

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

logical data structures that detail the relationships among data elements by using graphics or pictures

A

data models

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

provides detail about data

A

metadata

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

stores data in form of logically related two-dimentional tables.

A

relational database management system

19
Q

stores data about a person, place, or thing, transaction, or event.

A

entity

20
Q

field or group of fields that uniquely identifies a given record in a table

A

primary key

21
Q

logical data structures that detail relationships among data elements using graphics or pictures

A

data model

22
Q

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

A

foreign key

23
Q

asks users to write lines of code to answer questions against database

A

structured query language (SQL)

24
Q

known as column or fields. the data elements associated with an entity,

A

attributes

25
Q

customer name
distributor id
product price
… are what to data?

A

attributes

26
Q

customer
distributor and product are what to data

A

entity

27
Q

a collection of related data elements.

A

record

28
Q

What refers to the overall management of the availability, usability, integrity, and security of company data?

A

data governance

29
Q

create, read, delete, update

A

data

30
Q

What refers to the extent of detail within the data?

A

data granularity

31
Q
A
31
Q

3 business advantages of a relational database.

A

increased data security
reduced data rebundancy
increase data integrity

32
Q

what are the data levels

A

individual, department and enterprise

33
Q

data formats?

A

documents, presentations, spreadsheets and database

34
Q

data granularities?

A

detail, summary, aggregate

35
Q

What is the duplication of data, or the storage of the same data in multiple places?

A

data redundancy

35
Q

A(n) entity-relationship Blank______ is a technique for documenting the entities and relationships in a database environment.

A

diagram

36
Q

structured collection of data organized into tables (entities) that are related to each other based on common attributes. It allows for efficient storage, retrieval, and manipulation of data.

A

relational database

37
Q

also known as a table, represents a specific type of object or concept within the database.

A

entity

38
Q

also known as columns or fields, define the properties or characteristics of an entity.

A

attributes

39
Q

individual rows within an entity or table.

A

records

40
Q

ability to provide multidimensional analysis that allows users to gain insights into their data

A

big data

41
Q

a logical collection of data- gathered from many different operational databases.

A

data warehouse

Business Process (5 decks)

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