DBMS Exam 1: Questions With Proper Answers (100%)
1) What is redundancy? What problems are associated with redundancy?
Right Ans - Redundancy is the duplication of data or the storing of the same
data in more than one place. Redundancy wastes space b/c you're storing the
same data in multiple places. The extra space results in larger spreadsheets
that require more space in memory and on disk that take longer to save and
open. It also makes changes more cumbersome, and it makes things
inconsistent, for example, when you enter the same name three different ways
(ex: johnsons vs johnson's, or johnsons').
3) What is an entity? An attribute? Right Ans - An entity is a person, place,
object, event, or idea for which you want to store and process data. (each
entity has its own table). An attribute is a characteristic or property on an
entity. Attributes=> Also known as fields or columns in many database
systems.
4) What is a relationship? A one-to-many relationship? Right Ans - A
relationship is an association between entities. (ex: the RepNum relationships
between the Rep and Customer tables in Premiere Products). One-to-many
relationships occur when each record in TableA may have many linked
records in TableB but each record in TableB may have only one corresponding
record in TableA.
5) What is a database? Right Ans - A database is a structure that can store
information about multiple types of entities, the attributes of those entities,
and the relationships between the entities.
8) What is a DBMS? Right Ans - A Database Management System is a
program, or collection of programs, through which users interact with a
database. The actual manipulation of the underlying database is handled by
the DBMS (ex: Microsoft Access).
11) How is it possible to get more information from the same amount of data
by using a database approach as opposed to a nondatabase approach?
Right Ans - The primary goal of a computer system is to turn data (recorded
facts) into information (the knowledge gained by processing those facts.) In a
non-database, file-oriented environment, data often is partitioned into several
disjointed systems, with each system having its own collection of files. Any
1) What is redundancy? What problems are associated with redundancy?
Right Ans - Redundancy is the duplication of data or the storing of the same
data in more than one place. Redundancy wastes space b/c you're storing the
same data in multiple places. The extra space results in larger spreadsheets
that require more space in memory and on disk that take longer to save and
open. It also makes changes more cumbersome, and it makes things
inconsistent, for example, when you enter the same name three different ways
(ex: johnsons vs johnson's, or johnsons').
3) What is an entity? An attribute? Right Ans - An entity is a person, place,
object, event, or idea for which you want to store and process data. (each
entity has its own table). An attribute is a characteristic or property on an
entity. Attributes=> Also known as fields or columns in many database
systems.
4) What is a relationship? A one-to-many relationship? Right Ans - A
relationship is an association between entities. (ex: the RepNum relationships
between the Rep and Customer tables in Premiere Products). One-to-many
relationships occur when each record in TableA may have many linked
records in TableB but each record in TableB may have only one corresponding
record in TableA.
5) What is a database? Right Ans - A database is a structure that can store
information about multiple types of entities, the attributes of those entities,
and the relationships between the entities.
8) What is a DBMS? Right Ans - A Database Management System is a
program, or collection of programs, through which users interact with a
database. The actual manipulation of the underlying database is handled by
the DBMS (ex: Microsoft Access).
11) How is it possible to get more information from the same amount of data
by using a database approach as opposed to a nondatabase approach?
Right Ans - The primary goal of a computer system is to turn data (recorded
facts) into information (the knowledge gained by processing those facts.) In a
non-database, file-oriented environment, data often is partitioned into several
disjointed systems, with each system having its own collection of files. Any
