Chapter 2

Question 1

What are data models?

Answer 1

Data models are simple graphical representations of complex real-world structures.

Question 2

What is the importance of data models?

Answer 2

Organizes data for various users.
Facilitate interaction among all the users.

Question 3

List the sources of business rules.

Answer 3

Company managers
Policy-makers
Department managers
Written Documentation
Direct Interviews with end-users

Question 4

What are business rules?

Answer 4

Brief and precise policies within a specific organization that stores and uses data to generate information.

Question 5

What are the types of data models? List them in ascending order.

Answer 5

Hierarchical
Network
Relational
Entity relationship
Object oriented (OO)

Question 6

Give some examples of a Relational Database.

Answer 6

DB2
Oracle
MySQL
MySQL Server

Question 7

Give some characteristics of the Relational Database.

Answer 7

It is Conceptually simple
It Supports ER Modelling

Question 8

What is the advantage of the RDBMS?

Answer 8

It can hide the complexities of the relational model from the user.

Question 9

What role does SQL play in relational databases?

Answer 9

Allows user to specify what must be done without specifying how it must be done.

Question 10

What is an Entity Relationship (ER) Model defined as?

Answer 10

It is a graphical representation of entities and their relationships in a database structure.

Question 11

What is Big Data?

Answer 11

It is managing large web data for business insights, performance, and scalability at a good cost.