Lecture 2

Question 1

Data analytics typology

Answer 1

descriptive analytics, diagnostic analytics, predictive analytics, prescriptive analytics

Question 2

descriptive analytics

Answer 2

tell me what happened

Question 3

diagnostic analytics

Answer 3

why something happened

Question 4

predictive analytics

Answer 4

what is likely to happen

Question 5

prescriptive analytics

Answer 5

what my options are? what should i do?

Question 6

entity

Answer 6

a person, place, thing or event about which data will be collected and stored

Question 7

table

Answer 7

a set of data elements using a model of vertical columns and horizontal row

Question 8

attribute

Answer 8

characteristics of an entity

Question 9

relationship

Answer 9

describe an association among entities

Question 10

types of relationships

Answer 10

one to many (1:M)
many to many (M:N or ..)
One to one (1:1 or 1..1)

Question 11

Constraints

Answer 11

A restriction placed on the data

Question 12

ER model notations

Answer 12

Chen notation, crows foot notation and UML

Question 13

data anomalies

Answer 13

Update anomalies, insertion anomalies, deletion anomalies

Question 14

Normalization

Answer 14

Process for evaluating and correcting table structures to minimize data redundancies, thereby reducing the likelihood of data anomalies

Question 15

primary key

Answer 15

an attribute or combination of attributes that uniquely identifies any given row

Question 16

foreign key

Answer 16

Used to link two tables together

- a field in one table that refers to the primary key in another table

Question 17

Advantages of data analytics

Answer 17

accurate predictions

• identifications of new markets
• operational optimization
• improved decision making
• fault and fraud detection
• actionable intelligence
• scientific discoveries