MIS Chapter 5
Which of the following is an example of a database management system?
Access
__________ is an example of a personal DBMS.
Access
A(n) ________ is a program used to create, process, and administer a database.
DBMS
From among the following, identify the open source DBMS product.
MySQL
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.
N:M
If a student is allowed to have multiple advisors and advisors are assigned to handle multiple students, it would be an example of a ________ relationship.
N:M
Many-to-many relationships are noted as _________ relationships
N:M
Which of the following is an international standard language for processing a database?
SQL
SQL stands for ___________.
Structured Query Language
Which of the following is true of N:M relationships?
They can have more than one entity on each side of the relationship.
Which of the following is not an example of a database product?
Ubuntu
When using the relational model to represent two tables, one must ________.
a a foreign key to one of the tables
The term ________ implies that either all transactions related to a traditional relational DBMS are processed or none of them are processed.
atomic
Entities in a data model have ________ that describe the characteristics of the entity.
attributes
Which of the following is the smallest data element in a database?
byte
A primary key used in a database is a ________.
column or group of columns that identifies a unique row in a table
Identify the first step in transforming a data model into a relational database design.
creating a table for each entity
The forked lines on the right side of a line on an E-R diagram that indicate a 1:N relationship between two entities are referred to as ________.
crow's feet
A ________ describes the data and relationships that will be stored in a database.
data model
An administrator should create a(n) ________ before developing a database design.
data model
Metadata are ________.
data that describes data
A ___________ is a collection of forms, reports, queries, and programs that process a database.
database application
________ is the process of converting a data model into tables, relationships, and data constraints.
database design
Identify the type of task performed by a database administrator when validating the data model to be used in a database management system.
development
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 ________.
entities
In a data model, a(n) ________ is something that a user wants to track.
entity
Which of the following is a developmental task of database administration?
evaluating an application design
The columns in a database are called ________.
fields
A database design team transforms entities into tables and expresses relationships by defining ________.
foreign keys
Columns that belong to a different table than the one in which they reside are called ________.
foreign keys
Relational databases represent relationships using ________.
foreign keys
Each entity in a database has a unique attribute called a(n) ________.
identifier
Which of the following refers to the problem that exists in database applications when two users update the same data item, but only one of those changes is recorded?
lost-update problem
________ in an E-R diagram refer to the least number of entities required in a relationship.
minimal cardinalities
Constraints on the number of entities in a relationship are called ________ cardinalities.
minimum
________ is the process of converting a poorly- structured table into two or more well-structured tables.
normalization
A(n) __________ is a column or group of columns that identifies a unique row in a table.
primary keys
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) ________.
primary keys
When you modify or delete data present in a database, you are ________.
processing the database
A ________ is a request for data from a database.
query
Brenda wants to find a particular report containing sales analysis of the second and third quarter. After accessing the DBMS, she should type in the keyword into ________ form to locate what she is looking for.
query
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.
query
The rows in a database are called ________.
records
In an E-R diagram, a line between two entities represents a(n) ________.
relationship
Browser-based applications ________.
support querying using graphics
In a relational database, a collection of similar records is a(n) __________.
table
________ 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.
users
In an E-R diagram, a(n) ________ on a line means that at least one entity type of that type is required.
vertical bar
