MIS 301 Chapter 5
relational database model - correct answer ✔is based on the concept of two-
dimensional tables and is usually designed with a number of related tables
with each of these tables contains records (listed in rows) and attributes (listed
in columns).
data model - correct answer ✔a diagram that represents entities in the
database and their relationships
entity - correct answer ✔a person, place, thing, or event (e.g., customer, an
employee, or a product).
instance of an entity - correct answer ✔refers to each row (or record) in a
relational table, which is a specific, unique representation of the entity.
attribute - correct answer ✔each characteristic or quality of a particular entity
primary key - correct answer ✔a field in a database that uniquely identify
each record so that it can be retrieved, updated, and sorted.
secondary key - correct answer ✔a field that has some identifying
information, but typically does not identify the record with complete accuracy
and therefore cannot serve at the Primary Key.
foreign key - correct answer ✔a field (or group of fields) in one table that
uniquely identifies a row of another table. It is used to establish and enforce a
link between two tables.
, bit - correct answer ✔represents the smallest unit of data a computer can
process and it consists only of a 0 or a 1
byte - correct answer ✔A group of eight bits represents a single character
(letter, number, or symbol).
field - correct answer ✔A column of data containing a logical grouping of
characters into a word, a small group of words (e.g., last name, social security
number, etc.).
record - correct answer ✔A logical grouping of related fields in a row (e.g.,
student's name, the courses taken, the date, and the grade).
data file - correct answer ✔logical grouping of related records is called a data
file or a table similar in appearance to a speadsheet in Excel consisting of
multiple columns and multiple rows
database - correct answer ✔logical grouping of related data files (aka
database tables).
database management system (DBMS) - correct answer ✔a set of programs
that provide users with tools to create and manage a database.
data security - correct answer ✔Because data are "put in one place" in
databases, there is a risk of losing a lot of data at one time. Therefore,
databases must have extremely high security measures in place to minimize
mistakes and deter attacks
data integrity - correct answer ✔Data meet certain constraints; for example,
there are no alphabetic characters in a Social Security number field.
relational database model - correct answer ✔is based on the concept of two-
dimensional tables and is usually designed with a number of related tables
with each of these tables contains records (listed in rows) and attributes (listed
in columns).
data model - correct answer ✔a diagram that represents entities in the
database and their relationships
entity - correct answer ✔a person, place, thing, or event (e.g., customer, an
employee, or a product).
instance of an entity - correct answer ✔refers to each row (or record) in a
relational table, which is a specific, unique representation of the entity.
attribute - correct answer ✔each characteristic or quality of a particular entity
primary key - correct answer ✔a field in a database that uniquely identify
each record so that it can be retrieved, updated, and sorted.
secondary key - correct answer ✔a field that has some identifying
information, but typically does not identify the record with complete accuracy
and therefore cannot serve at the Primary Key.
foreign key - correct answer ✔a field (or group of fields) in one table that
uniquely identifies a row of another table. It is used to establish and enforce a
link between two tables.
, bit - correct answer ✔represents the smallest unit of data a computer can
process and it consists only of a 0 or a 1
byte - correct answer ✔A group of eight bits represents a single character
(letter, number, or symbol).
field - correct answer ✔A column of data containing a logical grouping of
characters into a word, a small group of words (e.g., last name, social security
number, etc.).
record - correct answer ✔A logical grouping of related fields in a row (e.g.,
student's name, the courses taken, the date, and the grade).
data file - correct answer ✔logical grouping of related records is called a data
file or a table similar in appearance to a speadsheet in Excel consisting of
multiple columns and multiple rows
database - correct answer ✔logical grouping of related data files (aka
database tables).
database management system (DBMS) - correct answer ✔a set of programs
that provide users with tools to create and manage a database.
data security - correct answer ✔Because data are "put in one place" in
databases, there is a risk of losing a lot of data at one time. Therefore,
databases must have extremely high security measures in place to minimize
mistakes and deter attacks
data integrity - correct answer ✔Data meet certain constraints; for example,
there are no alphabetic characters in a Social Security number field.
