busn ex. 2

Question 1

airline ticket
sales receipt
packing slip

Answer 1

transactional data

Question 2

product statistics
sales production
future growth
trends
analytical data

Answer 2

analytical data

Question 3

means immediate and up to date data

Answer 3

real-time data

Question 4

occurs when the same data elements has different values.

Answer 4

data inconsistency

Question 5

occur when a system produces incorrect or inconsistent or duplicate data

Answer 5

date integrity issues

Question 6

what are the 5 common characteristics of high -quality data

Answer 6

accurate
complete
consistent
timely
and unique

Question 7

data: is there an incorrect value in data?

Answer 7

accurate data

Question 8

data: is there a value missing

Answer 8

complete

Question 9

is aggregate or summary data in agreement with detected data?

Answer 9

consistent

Question 10

is the data current with respect to business needs

Answer 10

timely

Question 11

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

Answer 11

unique

Question 12

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

Answer 12

data governance

Question 13

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

Answer 13

database management system

Question 14

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

Answer 14

data dictionary

Question 15

data element

Answer 15

the smallest or basic unit of data

Question 16

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

Answer 16

data models

Question 17

provides detail about data

Answer 17

metadata

Question 18

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

Answer 18

relational database management system

Question 19

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

Answer 19

entity

Question 20

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

Answer 20

primary key

Question 21

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

Answer 21

data model

Question 22

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

Answer 22

foreign key

Question 23

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

Answer 23

structured query language (SQL)

Question 24

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

Answer 24

attributes

Question 25

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

Answer 25

attributes

Question 26

customer distributor and product are what to data

Answer 26

entity

Question 27

a collection of related data elements.

Answer 27

record

Question 28

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

Answer 28

data governance

Question 29

create, read, delete, update

Answer 29

data

Question 30

What refers to the extent of detail within the data?

Answer 30

data granularity

Question 31

3 business advantages of a relational database.

Answer 31

increased data security reduced data rebundancy increase data integrity

Question 32

what are the data levels

Answer 32

individual, department and enterprise

Question 33

data formats?

Answer 33

documents, presentations, spreadsheets and database

Question 34

data granularities?

Answer 34

detail, summary, aggregate

Question 35

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

Answer 35

data redundancy

Question 35

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

Answer 35

diagram

Question 36

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.

Answer 36

relational database

Question 37

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

Answer 37

entity

Question 38

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

Answer 38

attributes

Question 39

individual rows within an entity or table.

Answer 39

records

Question 40

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

Answer 40

big data

Question 41

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

Answer 41

data warehouse