OMIS 452: Exam 1 Questions and
Answers 100% Solved
What is stored in a database? - 🧠 ANSWER ✔✔Data, Record, Facts
How is data stored? - 🧠 ANSWER ✔✔Tables
Tables consist of... - 🧠 ANSWER ✔✔Rows (Record, Entity, Instance)
Columns (Characteristics, Attributes, Fields)
Why do we store data? - 🧠 ANSWER ✔✔To help us keep track of things
How do we uniquely identify each? For example a Row-Record-Entity-
Instance in a table - 🧠 ANSWER ✔✔By using keys
Primary, Surrogate
, What is a primary key? - 🧠 ANSWER ✔✔A candidate key selected to be the
key of relation; this key is used as a foreign key for representing
relationships. (Typically has a number)
What is a surrogate key? - 🧠 ANSWER ✔✔A unique, system-supplied
identifier used as the primary key of a relation. Its created when a row is
created, it never changes, and it is destroyed when the row is deleted. The
values of this have no meaning to the users and are hidden within forms
and reports.
How do you tie tables together? - 🧠 ANSWER ✔✔Through Relationships
using keys.
What is a relationship? - 🧠 ANSWER ✔✔An association between two
entities or rows.
What is a foreign key? - 🧠 ANSWER ✔✔An attribute that is a key of one or
more relations other than the one in which it appears. Used to represent a
relationship.
What is data? - 🧠 ANSWER ✔✔The values stored in a database. (Raw
facts, figures, names, dates)
Answers 100% Solved
What is stored in a database? - 🧠 ANSWER ✔✔Data, Record, Facts
How is data stored? - 🧠 ANSWER ✔✔Tables
Tables consist of... - 🧠 ANSWER ✔✔Rows (Record, Entity, Instance)
Columns (Characteristics, Attributes, Fields)
Why do we store data? - 🧠 ANSWER ✔✔To help us keep track of things
How do we uniquely identify each? For example a Row-Record-Entity-
Instance in a table - 🧠 ANSWER ✔✔By using keys
Primary, Surrogate
, What is a primary key? - 🧠 ANSWER ✔✔A candidate key selected to be the
key of relation; this key is used as a foreign key for representing
relationships. (Typically has a number)
What is a surrogate key? - 🧠 ANSWER ✔✔A unique, system-supplied
identifier used as the primary key of a relation. Its created when a row is
created, it never changes, and it is destroyed when the row is deleted. The
values of this have no meaning to the users and are hidden within forms
and reports.
How do you tie tables together? - 🧠 ANSWER ✔✔Through Relationships
using keys.
What is a relationship? - 🧠 ANSWER ✔✔An association between two
entities or rows.
What is a foreign key? - 🧠 ANSWER ✔✔An attribute that is a key of one or
more relations other than the one in which it appears. Used to represent a
relationship.
What is data? - 🧠 ANSWER ✔✔The values stored in a database. (Raw
facts, figures, names, dates)
