MIS 309 Chapter 5 Exam Questions and
Answers
/. ________ are the final judges as to what data the database should contain and how
the records in that database should be related to one another. - Answer-✅users
/.________ forms are used to read, insert, modify, and delete data. - Answer-✅data
entry
/.________ is an example of a personal DBMS. - Answer-✅Access
/.________ is the process of converting a data model into tables, relationships, and data
constraints. - Answer-✅Database design
/.________ is the process of converting a poorly- structured table into two or more well-
structured tables. - Answer-✅Normalization
/.) Constraints on the number of entities in a relationship are called ________
cardinalities. - Answer-✅minimum
/.A ________ describes the data and relationships that will be stored in a database. -
Answer-✅data model
/.A ________ is a collection of forms, reports, queries, and programs that process a
database. - Answer-✅database application
/.A ________ is a request for data from a database. - Answer-✅query
/.A data integrity problem will occur only if ________. - Answer-✅data are duplicated
/.A data model is a ________. - Answer-✅logical representation of database data
/.A database design team transforms entities into tables and expresses relationships by
defining ________. - Answer-✅foreign keys
/.A line on an E-R diagram that indicates a 1:N relationship between two entities is
referred to as ________. - Answer-✅crow's feet
, /.A primary key used in a database is a ________. - Answer-✅column or group of
columns that identifies a unique row in a table
/.A student management system allows students to have multiple majors and advisers
are assigned to handle multiple students and courses. This is an example of a(n)
________ relationship. - Answer-✅N:M
/.A(n) ________ DBMS is designed to process large organizational and workgroup
databases. - Answer-✅Enterprise
/.A(n) ________ is a program used to create, process, and administer a database. -
Answer-✅DBMS
/.A(n) ________ is a self-describing collection of integrated records. - Answer-
✅Database
/.Albert creates a relational database to store employee performance statistics. He
stores each employee's data in independent rows and creates a column named
"Employee Number" to assign unique numbers to each employee. This column is
referred to as a(n) ________. - Answer-✅primary key
/.An administrator should create a(n) ________ before developing a database design. -
Answer-✅data model
/.An organization buys a proprietary database application to be used by a small
workgroup of five people. This is an example of a(n) ________ DBMS - Answer-
✅personal
/.Brad, a project manager, wants to build a database to integrate information about
employees and tasks that they handle. Brad wants to track information such as task
name, percentage completed, and employee name. These aspects that Brad wants to
track are called ________. - Answer-✅entities
/.Brenda, the sales manager of a firm, wants to generate a particular report containing
sales analyses of the second and third quarter of the year. After accessing the DBMS,
she should type the keyword into a ________ form to obtain the information that she
wants. - Answer-✅query
/.Columns that belong to a different table than the one in which they reside are called
________. - Answer-✅foreign keys
/.Each entity in a database has a unique attribute called a(n) ________. - Answer-
✅identifier
Answers
/. ________ are the final judges as to what data the database should contain and how
the records in that database should be related to one another. - Answer-✅users
/.________ forms are used to read, insert, modify, and delete data. - Answer-✅data
entry
/.________ is an example of a personal DBMS. - Answer-✅Access
/.________ is the process of converting a data model into tables, relationships, and data
constraints. - Answer-✅Database design
/.________ is the process of converting a poorly- structured table into two or more well-
structured tables. - Answer-✅Normalization
/.) Constraints on the number of entities in a relationship are called ________
cardinalities. - Answer-✅minimum
/.A ________ describes the data and relationships that will be stored in a database. -
Answer-✅data model
/.A ________ is a collection of forms, reports, queries, and programs that process a
database. - Answer-✅database application
/.A ________ is a request for data from a database. - Answer-✅query
/.A data integrity problem will occur only if ________. - Answer-✅data are duplicated
/.A data model is a ________. - Answer-✅logical representation of database data
/.A database design team transforms entities into tables and expresses relationships by
defining ________. - Answer-✅foreign keys
/.A line on an E-R diagram that indicates a 1:N relationship between two entities is
referred to as ________. - Answer-✅crow's feet
, /.A primary key used in a database is a ________. - Answer-✅column or group of
columns that identifies a unique row in a table
/.A student management system allows students to have multiple majors and advisers
are assigned to handle multiple students and courses. This is an example of a(n)
________ relationship. - Answer-✅N:M
/.A(n) ________ DBMS is designed to process large organizational and workgroup
databases. - Answer-✅Enterprise
/.A(n) ________ is a program used to create, process, and administer a database. -
Answer-✅DBMS
/.A(n) ________ is a self-describing collection of integrated records. - Answer-
✅Database
/.Albert creates a relational database to store employee performance statistics. He
stores each employee's data in independent rows and creates a column named
"Employee Number" to assign unique numbers to each employee. This column is
referred to as a(n) ________. - Answer-✅primary key
/.An administrator should create a(n) ________ before developing a database design. -
Answer-✅data model
/.An organization buys a proprietary database application to be used by a small
workgroup of five people. This is an example of a(n) ________ DBMS - Answer-
✅personal
/.Brad, a project manager, wants to build a database to integrate information about
employees and tasks that they handle. Brad wants to track information such as task
name, percentage completed, and employee name. These aspects that Brad wants to
track are called ________. - Answer-✅entities
/.Brenda, the sales manager of a firm, wants to generate a particular report containing
sales analyses of the second and third quarter of the year. After accessing the DBMS,
she should type the keyword into a ________ form to obtain the information that she
wants. - Answer-✅query
/.Columns that belong to a different table than the one in which they reside are called
________. - Answer-✅foreign keys
/.Each entity in a database has a unique attribute called a(n) ________. - Answer-
✅identifier
