1
LIS3784 Exam 1 Questions with Answers
(100% Correct Answers)
What should be done before designing a database? Answer: Normalization
What must be done to improve the efficiency of a database design? Answer:
Denormalization
Decision support systems Answer: Data warehouse
What is an entity that can exist apart from other entities? Answer: Existent
independent entity. (Strong)
What has a primary key that is partly or totally derived from the parent entity?
Answer: Existent dependent entity. (Weak)
What is it when one or more optional relationships can exist. Answer:
Optionality
Minimum of one cardinality Answer: Mandatory participation
What does two parallel lines represent in an ERD? Answer: Cardinality of (1,1)
A relationship with a single entity Aka. recursive relationship. Answer: Unary
Relationship
What is the most common relationship? Answer: Binary Relationship
Primary key of parent entities must go into ____________ Answer: Associative
entity Aka: Composite entity
What language is used for create, drop, and alter commands? Answer: Data
Definition Language (DDL)
What is a graphical tool used in database design? Answer: Entity Relational
Model
What model allows for inheritance? Answer: Object Oriented Model
, 2
Global view of the database as viewed by the organization? Answer:
Conceptual Model
What is a logically connected set of one or more fields? Answer: Record. Aka:
row or tuple
What is a collection of related records? Answer: File
What is a character or group of characters that has a specific meaning? Answer:
Field
What will allow the database to perform more efficiently also to store data
more efficiently? Answer: Performance tuning
What are unique values? Answer: Primary keys must be unique
What is security compliance? Answer: A SSN is unique, so perfect for a
primary key, but it is not used because of security purposes.
What is it called when no there is no natural primary key available? Answer:
Surrogate Primary Key
What is needed to have a relationship in the relational model with the primary
key? Answer: Foreign Key
Where do you put the foreign key in a 1:1 relationship? Answer: Put it in the
table with the fewer number of null values.
What are changes in values over time? Answer: Time varying data
What are multiple relationships between multiple entities that are not required?
Answer: Redundant relationships
What are the different clauses in the select statement? Answer: Select
From
Where
LIS3784 Exam 1 Questions with Answers
(100% Correct Answers)
What should be done before designing a database? Answer: Normalization
What must be done to improve the efficiency of a database design? Answer:
Denormalization
Decision support systems Answer: Data warehouse
What is an entity that can exist apart from other entities? Answer: Existent
independent entity. (Strong)
What has a primary key that is partly or totally derived from the parent entity?
Answer: Existent dependent entity. (Weak)
What is it when one or more optional relationships can exist. Answer:
Optionality
Minimum of one cardinality Answer: Mandatory participation
What does two parallel lines represent in an ERD? Answer: Cardinality of (1,1)
A relationship with a single entity Aka. recursive relationship. Answer: Unary
Relationship
What is the most common relationship? Answer: Binary Relationship
Primary key of parent entities must go into ____________ Answer: Associative
entity Aka: Composite entity
What language is used for create, drop, and alter commands? Answer: Data
Definition Language (DDL)
What is a graphical tool used in database design? Answer: Entity Relational
Model
What model allows for inheritance? Answer: Object Oriented Model
, 2
Global view of the database as viewed by the organization? Answer:
Conceptual Model
What is a logically connected set of one or more fields? Answer: Record. Aka:
row or tuple
What is a collection of related records? Answer: File
What is a character or group of characters that has a specific meaning? Answer:
Field
What will allow the database to perform more efficiently also to store data
more efficiently? Answer: Performance tuning
What are unique values? Answer: Primary keys must be unique
What is security compliance? Answer: A SSN is unique, so perfect for a
primary key, but it is not used because of security purposes.
What is it called when no there is no natural primary key available? Answer:
Surrogate Primary Key
What is needed to have a relationship in the relational model with the primary
key? Answer: Foreign Key
Where do you put the foreign key in a 1:1 relationship? Answer: Put it in the
table with the fewer number of null values.
What are changes in values over time? Answer: Time varying data
What are multiple relationships between multiple entities that are not required?
Answer: Redundant relationships
What are the different clauses in the select statement? Answer: Select
From
Where
