MIS 3353 EXAM 2 QUESTIONS AND ANSWERS
What is the purpose of ERDs - Answers - ERDs act like blueprints, providing a
visualization that the client can use to confirm that their requirements have been
understood and included.
Which of the following statements accurately compares the Waterfall SDLC to Agile
database development based on the provided information? - Answers - The Waterfall
SDLC focuses heavily on documentation at each phase, whereas Agile places a higher
emphasis on working software and collaboration.
How is an entity represented in an ERD (Entity-Relationship Diagram)? - Answers - As
a rectangle
What determines whether an object/noun qualifies as an entity in a database? -
Answers - There are multiple instances of the entity's "type".
How is a relationship between two entities represented within an ERD model? -
Answers - By drawing a line between the two entities.
In an ERD, when a relationship involves three distinct entities, it is referred to as a: -
Answers - unary for 1, Binary for 2, and Ternary for 3
Which statement accurately describes primary keys in an Entity Relationship Diagram
(ERD)? - Answers - Artificial primary keys, like CustomerID, are preferred because they
ensure every record is unique, has a primary key, and remains unchanged over time.
In a one-to-many relationship within an Entity Relationship Diagram (ERD), which side
donates its primary key to establish a foreign key relationship between two entities? -
Answers - The 'one' side donates its key to the 'many' side.
Which of the following statements best describes an atomic attribute? - Answers - An
atomic attribute is indivisible, and its values are treated as a single unit, not breakable
into smaller pieces.
Which of the following best describes an associative entity and its purpose? - Answers -
An associative entity is used to resolve many-to-many relationships between two
entities by breaking it down into two one-to-many relationships.
It would make sense to consider creating a super-type/sub-type relationship when... -
Answers - An entity's instances share some, but not all, attributes.
An attribute included in the super-type... - Answers - Is inherited by each of the sub-
types.
What is the purpose of ERDs - Answers - ERDs act like blueprints, providing a
visualization that the client can use to confirm that their requirements have been
understood and included.
Which of the following statements accurately compares the Waterfall SDLC to Agile
database development based on the provided information? - Answers - The Waterfall
SDLC focuses heavily on documentation at each phase, whereas Agile places a higher
emphasis on working software and collaboration.
How is an entity represented in an ERD (Entity-Relationship Diagram)? - Answers - As
a rectangle
What determines whether an object/noun qualifies as an entity in a database? -
Answers - There are multiple instances of the entity's "type".
How is a relationship between two entities represented within an ERD model? -
Answers - By drawing a line between the two entities.
In an ERD, when a relationship involves three distinct entities, it is referred to as a: -
Answers - unary for 1, Binary for 2, and Ternary for 3
Which statement accurately describes primary keys in an Entity Relationship Diagram
(ERD)? - Answers - Artificial primary keys, like CustomerID, are preferred because they
ensure every record is unique, has a primary key, and remains unchanged over time.
In a one-to-many relationship within an Entity Relationship Diagram (ERD), which side
donates its primary key to establish a foreign key relationship between two entities? -
Answers - The 'one' side donates its key to the 'many' side.
Which of the following statements best describes an atomic attribute? - Answers - An
atomic attribute is indivisible, and its values are treated as a single unit, not breakable
into smaller pieces.
Which of the following best describes an associative entity and its purpose? - Answers -
An associative entity is used to resolve many-to-many relationships between two
entities by breaking it down into two one-to-many relationships.
It would make sense to consider creating a super-type/sub-type relationship when... -
Answers - An entity's instances share some, but not all, attributes.
An attribute included in the super-type... - Answers - Is inherited by each of the sub-
types.
