Chapter 2

Question 1

3 Vs

Answer 1

Volume: amount of data
Variety: numbers of type of data
Velocity: speed of data access

Question 2

American National Standards Institute (ANSI)

Answer 2

The Institute oversees the creation, promulgation and use of thousands of norms and guidelines. Defined a framework for data modeling based on degrees of abstraction in the early 1970’s

Question 3

Attrbiute

Answer 3

A characteristic of an entity

Question 4

Business rule

Answer 4

Description of a policy, procedure, or principle within a specific organization

Question 5

Conceptual model

Answer 5

Global view of the entire database as viewed by the entire organization

Question 6

Conceptual schema

Answer 6

Basis for the identification of the high-level description of the main data objects. ER model most widely used

Question 7

Connectivity

Answer 7

Labels relationship types in an ER model

Question 8

Entity

Answer 8

A person, place, or thing that is collected data on

Question 9

Entity instance

Answer 9

Each row in a relational table

Question 10

Entity relationship (ER) model

Answer 10

Graphical model which represents entities and their relationship

Question 11

Entity relationship diagram (ERD)

Answer 11

ER models displaying database components

Question 12

Entity set

Answer 12

A collection of like entities

Question 13

Extended relational data model (ERDM)

Answer 13

Adds many OO model features to relational database structure such as encapsulation, inheritance, and extensible data types

Question 14

External schema

Answer 14

A specific representation of an external view

Question 15

External model

Answer 15

The end user’s view of the data environment

Question 16

Hadoop

Answer 16

Open source, Java-based programming framework that supports the processing and storage of extremely large data sets in a distributed computing environment

Question 17

Hierarchical model

Answer 17

Developed to manage large amounts of data for complex manufacturing projects.

Question 18

Internal model

Answer 18

Representation of the database as seen by the DBMS

Question 19

Internal schema

Answer 19

Depicts a specific representation of an internal model

Question 20

Logical design

Answer 20

The task of creating a conceptual design that could b implemented in any DBMS

Question 21

Logical independence

Answer 21

Being able to change the internal model without affecting the conceptual model

Question 22

Object-oriented data model (OODM)

Answer 22

Both the data and relationships are contained in a single structure called an object

Question 23

Semantic data model

Answer 23

A model which describes the meaning of its instances

Question 24

Network model

Answer 24

user perceives the network database as a collection of record in 1:M relationships

Question 25

Schema

Answer 25

conceptual organization of the entire database as viewed by the database administrator

Question 26

Subschema

Answer 26

Portion of the database seen by the application programs that actually produce the desired information from the data contained withing the database

Question 27

Relation

Answer 27

Matrix composed if intersecting rows and columns. Commonly called a table

Question 28

Tuple

Answer 28

Each row in a relation

Question 29

Unified Modeling Language (UML)

Answer 29

language based on OO concepts that describes a set of diagrams and symbols that can be used to graphically model a system