Information Management (BRIEF)

Question 1

Focuses on how the database structure will be used to store and manage end-user data.

Answer 1

Database Design

Question 2

The first step in designing a database.

Answer 2

Data Modelling

Question 3

Is relatively simple representation, usually graphical, of more complex real-world data structures.

Answer 3

Data Model

Question 4

Basic building blocks for data model.

Answer 4

Entity, Attribute, and Relationship

Question 5

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

Answer 5

Entity

Question 6

It is a characteristic of an entity.

Answer 6

Attribute

Question 7

It describes an association among entities.

Answer 7

Relationship

Question 8

Three types of relationships.

Answer 8

One-to-one (1:1)
One-to-many (1:M)
Many-to-many (M:M)

Question 9

• Developed in the 1960s.
• Represented by an upside-down tree.
• Equivalent of a file system’s record type.

Answer 9

Hierarchical Model

Question 10

• Created to represent complex data relationships.

Answer 10

Network Model

Question 11

It is the conceptual organization of the entire database as viewed by the database administrator.

Answer 11

Schema

Question 12

It defines the portion of the database by the application programs that actually produce the desired information.

Answer 12

Subschema

Question 13

It defines the environment in which data can be managed.

Answer 13

Data Manipulation Language (DML)

Question 14

It allows the database administrator to define the schema components.

Answer 14

Data Definition Language (DDL)

Question 15

• Introduced in 1976 by Peter Chen.
• Became popular because it complemented the relational data model concepts.
• Combined with relational data model.

Answer 15

Entity Relationship Model

Question 16

• Both data and its relationships are contained in a single structure.
• Said to be a semantic data model because it indicates meaning.

Answer 16

Object-Oriented Model

Question 17

A metalanguage used to represent and manipulate data elements.

Answer 17

Extensible Markup Language (XML)

Question 18

Emerging Data Models

Answer 18

Big Data and NoSQL

Question 19

Refers to a movement to find a new and better ways to manage large amounts of web and sensor-generated data and derive business insight from it, while simultaneously providing high performance scalability at a reasonable cost.

Answer 19

Big Data

Question 20

Refers to the amounts of data being stored.

Answer 20

Volume

Question 21

Refers not only to the sped with which data grows but also to the need to process this data quickly in order to generate information and insight.

Answer 21

Velocity

Question 22

Refers to the fact that the data being collected comes in multiple different data formats.

Answer 22

Variety

Question 23

• A large-scale distributed database system that stores structured and unstructured data in efficient ways.
• Amazon, Facebook, YouTube, and Google Maps uses this database.

Answer 23

NoSQL