MIS 301 EXAM 1 STUDY GUIDE
Table (Entity) - Answers - collection of fields that describe a person, place, object,
event, or idea.
Field (Attribute) - Answers - single characteristic or attribute of a person, place, object,
event, or idea. Each field contains one entry of data, NOT information.
Field Value - Answers - specific value, or content, of a field; only one entry can be made
per field
Record - Answers - a collection of fields in a table, typically aligned in a row of a table in
Datasheet View.
DataType - Answers - portion, in Design View, that allows you to determine what type of
data can only be entered into a field, when in Datasheet View. For example, a Number
DataType can only contain numbers, nothing else. Short Text can contain 255
characters, which can be anything you type on the keyboard.. Date/Time can only
contain either dates or times within the field.
Primary key - Answers - a field, or a collection of fields, whose values uniquely identify
each record in a table; no two records can contain the same value for the primary key
field. They are nonrepeating, typically numerical, but are now becoming more
alphanumerical.
Foreign key - Answers - a primary key from one table that appears on another table as
a regular field; the purpose of placing the same field in another table is to create a
relationship between the two tables which allows us to create queries and answer
specific business questions. Foreign keys can repeat.
Referential Integrity - Answers - - the process, during the creation of Relationships
between tables, where the DBMS checks to make sure that every Foreign key (FK) has
a matching Primary key (PK). If a FK appears without a matching PK, there can be
potential data entry mismatch, or even potential for someone to create a fake account in
which to process transactions without a company being aware of it.
Database Management System (DBMS) - Answers - - a software program that lets you
create databases and then manipulate data in them. Most databases today are called
relational databases. The DBMS inside of Access is called the Jet Engine.
Silos - Answers - refers to different departments not physically communicating but
communicate electronically through info systems.
Data - Answers - row names, numbers, values, dates, no initial meaning
Table (Entity) - Answers - collection of fields that describe a person, place, object,
event, or idea.
Field (Attribute) - Answers - single characteristic or attribute of a person, place, object,
event, or idea. Each field contains one entry of data, NOT information.
Field Value - Answers - specific value, or content, of a field; only one entry can be made
per field
Record - Answers - a collection of fields in a table, typically aligned in a row of a table in
Datasheet View.
DataType - Answers - portion, in Design View, that allows you to determine what type of
data can only be entered into a field, when in Datasheet View. For example, a Number
DataType can only contain numbers, nothing else. Short Text can contain 255
characters, which can be anything you type on the keyboard.. Date/Time can only
contain either dates or times within the field.
Primary key - Answers - a field, or a collection of fields, whose values uniquely identify
each record in a table; no two records can contain the same value for the primary key
field. They are nonrepeating, typically numerical, but are now becoming more
alphanumerical.
Foreign key - Answers - a primary key from one table that appears on another table as
a regular field; the purpose of placing the same field in another table is to create a
relationship between the two tables which allows us to create queries and answer
specific business questions. Foreign keys can repeat.
Referential Integrity - Answers - - the process, during the creation of Relationships
between tables, where the DBMS checks to make sure that every Foreign key (FK) has
a matching Primary key (PK). If a FK appears without a matching PK, there can be
potential data entry mismatch, or even potential for someone to create a fake account in
which to process transactions without a company being aware of it.
Database Management System (DBMS) - Answers - - a software program that lets you
create databases and then manipulate data in them. Most databases today are called
relational databases. The DBMS inside of Access is called the Jet Engine.
Silos - Answers - refers to different departments not physically communicating but
communicate electronically through info systems.
Data - Answers - row names, numbers, values, dates, no initial meaning
