DATABASE MANAGEMENT FINAL EXAM
Record - Answers - Each row in a database is also known as a record
e-commerce database application - Answers - An online drugstore such as
Drugstore.com is an example of a(n)
data & relationships - Answers - A database stores
True - Answers - T/F: The relational model was first proposed in 1970 by E.F. Codd at
IBM
Single-User database application - Answers - A sales contact manager used by a
salesperson is an example of a(n)
Microsoft Access - Answers - Which of the following database systems is not enterprise-
class?
-Oracle Database
-IBM DB2
-Microsoft SQL Server
-Microsoft Access
True - Answers - T/F: Twitter and Facebook use NoSQL databases
A database system is typically defined as its four components - Answers - users,
database applications, the DBMS and the databases
Data and relationships among the data - Answers - A database consists of integrated
tables, which store
Structured Query Language (SQL) - Answers - The industry standard supported by all
major DBMSs that allows tables to be joined together is called
XML Web services - Answers - allow database processing to be shared across the
Internet
Database Management System - Answers - A program whose job is to create, process
and administer databases is called a
Ture - Answers - T/F: The description of a database's structure that is stored within the
database itself is called the metadata
False - Answers - T/F: In an enterprise-class database system, business users interact
directly with the DBMS, which directly accesses the database data
, Database Administrator (DBA) - Answers - A ___ is the person in charge of an
organization's database
True - Answers - All database applications send and receive database data by sending
SQL statements to the DBMS
Normalization - Answers - Database professionals use a set of principles called ___ to
guide and assess database design
File Managers - Answers - The predecessors of database processing were ___
Applications - Answers - computer programs used directly by users
Data - Answers - recorded facts and figures
Information - Answers - knowledge derived from data
one and only one theme - Answers - In general, each relation should have
candidate key - Answers - A determinant that determines all the other columns in a
relation is a
column - Answers - An attribute is also known as a
all non-key attributes are determined by the entire primary key - Answers - A relation is
in second normal form (2NF) if and only if it is in 1NF and
insertion anomaly - Answers - Having to enter facts about two entities when we want to
enter facts about only one is an example of
Then it is true that A→ B and A → C - Answers - Given the functional dependency A →
(B, C)
True - Answers - T/F: The essence of normalization is taking a relation that is not in
BCNF and breaking it into multiple relations such that each one is in BCNF.
there are no non-key attributes determined by another non-key attribute - Answers - A
relation is in third normal form (3NF) if and only if it is in 2NF and
surrogate key - Answers - An artificial column added to a relation to serve as the
primary key
deletion anomaly - Answers - the removal of facts about one entity results in the
unintentional loss of data about another entity
Record - Answers - Each row in a database is also known as a record
e-commerce database application - Answers - An online drugstore such as
Drugstore.com is an example of a(n)
data & relationships - Answers - A database stores
True - Answers - T/F: The relational model was first proposed in 1970 by E.F. Codd at
IBM
Single-User database application - Answers - A sales contact manager used by a
salesperson is an example of a(n)
Microsoft Access - Answers - Which of the following database systems is not enterprise-
class?
-Oracle Database
-IBM DB2
-Microsoft SQL Server
-Microsoft Access
True - Answers - T/F: Twitter and Facebook use NoSQL databases
A database system is typically defined as its four components - Answers - users,
database applications, the DBMS and the databases
Data and relationships among the data - Answers - A database consists of integrated
tables, which store
Structured Query Language (SQL) - Answers - The industry standard supported by all
major DBMSs that allows tables to be joined together is called
XML Web services - Answers - allow database processing to be shared across the
Internet
Database Management System - Answers - A program whose job is to create, process
and administer databases is called a
Ture - Answers - T/F: The description of a database's structure that is stored within the
database itself is called the metadata
False - Answers - T/F: In an enterprise-class database system, business users interact
directly with the DBMS, which directly accesses the database data
, Database Administrator (DBA) - Answers - A ___ is the person in charge of an
organization's database
True - Answers - All database applications send and receive database data by sending
SQL statements to the DBMS
Normalization - Answers - Database professionals use a set of principles called ___ to
guide and assess database design
File Managers - Answers - The predecessors of database processing were ___
Applications - Answers - computer programs used directly by users
Data - Answers - recorded facts and figures
Information - Answers - knowledge derived from data
one and only one theme - Answers - In general, each relation should have
candidate key - Answers - A determinant that determines all the other columns in a
relation is a
column - Answers - An attribute is also known as a
all non-key attributes are determined by the entire primary key - Answers - A relation is
in second normal form (2NF) if and only if it is in 1NF and
insertion anomaly - Answers - Having to enter facts about two entities when we want to
enter facts about only one is an example of
Then it is true that A→ B and A → C - Answers - Given the functional dependency A →
(B, C)
True - Answers - T/F: The essence of normalization is taking a relation that is not in
BCNF and breaking it into multiple relations such that each one is in BCNF.
there are no non-key attributes determined by another non-key attribute - Answers - A
relation is in third normal form (3NF) if and only if it is in 2NF and
surrogate key - Answers - An artificial column added to a relation to serve as the
primary key
deletion anomaly - Answers - the removal of facts about one entity results in the
unintentional loss of data about another entity
