OMIS 452: Quiz 1 Questions and Answers 100% Solved
Save
3
Practice questions for this set
Learn 1 /7 Study with Learn
(1) Knowledge derived from data, (2) Data presented in a meaningful context, (3) data
processed by summing, ordering, averaging, grouping, comparing, or other similar
operations.
Choose an answer
1 What is stored in a database? 2 Why not just use a spreadsheet?
How do we uniquely identify each? For
3 example a Row-Record-Entity-Instance in 4 What is information?
a table
, Don't know?
Terms in this set (26)
What is stored in a database? Data, Record, Facts
How is data stored? Tables
Rows (Record, Entity, Instance)
Tables consist of...
Columns (Characteristics, Attributes, Fields)
Why do we store data? To help us keep track of things
How do we uniquely identify By using keys
each? For example a Row- Primary, Surrogate
Record-Entity-Instance in a
table
A candidate key selected to be the key of relation; this key is
What is a primary key? used as a foreign key for representing relationships. (Typically
has a number)
A unique, system-supplied identifier used as the primary key of a
relation. Its created when a row is created, it never changes, and
What is a surrogate key?
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? Through Relationships using keys.
What is a relationship? An association between two entities or rows.
Save
3
Practice questions for this set
Learn 1 /7 Study with Learn
(1) Knowledge derived from data, (2) Data presented in a meaningful context, (3) data
processed by summing, ordering, averaging, grouping, comparing, or other similar
operations.
Choose an answer
1 What is stored in a database? 2 Why not just use a spreadsheet?
How do we uniquely identify each? For
3 example a Row-Record-Entity-Instance in 4 What is information?
a table
, Don't know?
Terms in this set (26)
What is stored in a database? Data, Record, Facts
How is data stored? Tables
Rows (Record, Entity, Instance)
Tables consist of...
Columns (Characteristics, Attributes, Fields)
Why do we store data? To help us keep track of things
How do we uniquely identify By using keys
each? For example a Row- Primary, Surrogate
Record-Entity-Instance in a
table
A candidate key selected to be the key of relation; this key is
What is a primary key? used as a foreign key for representing relationships. (Typically
has a number)
A unique, system-supplied identifier used as the primary key of a
relation. Its created when a row is created, it never changes, and
What is a surrogate key?
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? Through Relationships using keys.
What is a relationship? An association between two entities or rows.
