CIS 360 MIDTERM PREP QUESTIONS WITH VERIFIED
ANSWERS
Who or what determines what data gets stored in a database? - Answers - Organization
Goals
Relationships go both ways between entities - this means they are what? - Answers -
bidirectional
Each ____ in your business rules translate into entities, attributes or crap? - Answers -
noun
Each ____ in your business reules translate into relationships? - Answers - verb
A created entity used to link natural entities together is a what? - Answers - Associative
Entity
The attribute(s) selected to uniquely represent each entity instance is a ____ key -
Answers - primary
T or F. A primary key can be null - Answers - FALSE
T or F. A foreign key can be null - Answers - TRUE
T or F. Our goal is to completely eliminate redundancy - Answers - FALSE
What is data about data? - Answers - Metadata
Data relationships, like those stored in data dictionary, are used to enforce what? -
Answers - Data Integrity
_____ are raw facts, while __________ is the result of processing to reveal meaning -
Answers - Data, Information
Which of the following is NOT a basic building block for a data model? - Answers -
Characteristic
Which of the following is an example of a relationship? - Answers - M:N
The conceptual organization of the entire database, the logical and pyshical structure in
written form rather than graphical, is th ______? - Answers - Schema
ANSWERS
Who or what determines what data gets stored in a database? - Answers - Organization
Goals
Relationships go both ways between entities - this means they are what? - Answers -
bidirectional
Each ____ in your business rules translate into entities, attributes or crap? - Answers -
noun
Each ____ in your business reules translate into relationships? - Answers - verb
A created entity used to link natural entities together is a what? - Answers - Associative
Entity
The attribute(s) selected to uniquely represent each entity instance is a ____ key -
Answers - primary
T or F. A primary key can be null - Answers - FALSE
T or F. A foreign key can be null - Answers - TRUE
T or F. Our goal is to completely eliminate redundancy - Answers - FALSE
What is data about data? - Answers - Metadata
Data relationships, like those stored in data dictionary, are used to enforce what? -
Answers - Data Integrity
_____ are raw facts, while __________ is the result of processing to reveal meaning -
Answers - Data, Information
Which of the following is NOT a basic building block for a data model? - Answers -
Characteristic
Which of the following is an example of a relationship? - Answers - M:N
The conceptual organization of the entire database, the logical and pyshical structure in
written form rather than graphical, is th ______? - Answers - Schema