DATABASE SYSTEMS DESIGN
IMPLEMENTATION AND MANAGEMENT
FINAL PAPER TESTED QUESTIONS WITH
VERIFIED ANSWERS COMPLETE STUDY
SHEET
●● What are some of the challenges of Big Data?
Answer: -Volume doesn't allow usage of conventional structures
-Expensive
-OLAP tools proved inconsistent dealing with unstructured data
●● What are some of the new technologies of Big Data?
Answer: -Hadoop
-Hadoop Distributed File System (HDFS)
-MapReduce
-NoSQL
●● American National Standards Institute(ANSI)
Answer: A group that accepted the DBTG recommendations and
augmented database standards in 1975 through its SPARC committee.
-The SPARC committee defined a framework for data modeling based
on degrees of data abstraction.
,-It defined 3 levels of data abstraction: external, conceptual, and internal.
●● Attribute
Answer: A characteristic of an entity or object. It has a name and a data
type.
-describes particular characteristics
-They are the equivalent of fields in file systems.
●● Big Data
Answer: A movement to find new and better ways to manage large
amounts of web-generated data and sensor-generated data and derive
business insight from it, while simultaneously providing high
performance and scalability at a reasonable cost.
-The term was first used in a computing framework by John Mashey, a
Silicon Graphics scientist in the 1990's.
●● Business Rule
Answer: A description of a policy, procedure, or principle within an
organization.
-Create and enforce actions within that organization's environment.
-Establish entities, relationships, and constraints.
-Misnamed because they apply to any organization, large or small -a
business, a government unit, a religious group, or a research lab - that
stores and uses data to generate information.
, -For example, a pilot cannot be on duty for more than 10 hours during a
24-hour period, or a professor may teach up to four classes during a
semester.
●● What are some of the sources of business rules?
Answer: Company managers
Policy Makers
Department managers
Written documentation
Direct interviews with end users (faster and more direct source)
●● Why is the process of identifying and documenting business rules so
essential to database design?
Answer: -It helps to standardize the company's view of data.
-It can be a communication tool between users and designers.
-It allows the designer to understand the nature, role, and scope of the
data.
-it allows the designer to understand the business processes.
-it allows the designer to develop appropriate relationship participation
rules and constraints and to create an accurate data model.
●● What do business rules set the stage for and how do they do it?
Answer: They set the stage for the proper identification of entities,
attributes, relationships, and constraints.
IMPLEMENTATION AND MANAGEMENT
FINAL PAPER TESTED QUESTIONS WITH
VERIFIED ANSWERS COMPLETE STUDY
SHEET
●● What are some of the challenges of Big Data?
Answer: -Volume doesn't allow usage of conventional structures
-Expensive
-OLAP tools proved inconsistent dealing with unstructured data
●● What are some of the new technologies of Big Data?
Answer: -Hadoop
-Hadoop Distributed File System (HDFS)
-MapReduce
-NoSQL
●● American National Standards Institute(ANSI)
Answer: A group that accepted the DBTG recommendations and
augmented database standards in 1975 through its SPARC committee.
-The SPARC committee defined a framework for data modeling based
on degrees of data abstraction.
,-It defined 3 levels of data abstraction: external, conceptual, and internal.
●● Attribute
Answer: A characteristic of an entity or object. It has a name and a data
type.
-describes particular characteristics
-They are the equivalent of fields in file systems.
●● Big Data
Answer: A movement to find new and better ways to manage large
amounts of web-generated data and sensor-generated data and derive
business insight from it, while simultaneously providing high
performance and scalability at a reasonable cost.
-The term was first used in a computing framework by John Mashey, a
Silicon Graphics scientist in the 1990's.
●● Business Rule
Answer: A description of a policy, procedure, or principle within an
organization.
-Create and enforce actions within that organization's environment.
-Establish entities, relationships, and constraints.
-Misnamed because they apply to any organization, large or small -a
business, a government unit, a religious group, or a research lab - that
stores and uses data to generate information.
, -For example, a pilot cannot be on duty for more than 10 hours during a
24-hour period, or a professor may teach up to four classes during a
semester.
●● What are some of the sources of business rules?
Answer: Company managers
Policy Makers
Department managers
Written documentation
Direct interviews with end users (faster and more direct source)
●● Why is the process of identifying and documenting business rules so
essential to database design?
Answer: -It helps to standardize the company's view of data.
-It can be a communication tool between users and designers.
-It allows the designer to understand the nature, role, and scope of the
data.
-it allows the designer to understand the business processes.
-it allows the designer to develop appropriate relationship participation
rules and constraints and to create an accurate data model.
●● What do business rules set the stage for and how do they do it?
Answer: They set the stage for the proper identification of entities,
attributes, relationships, and constraints.
