INSY 3304 LATEST 2026 EXAM QUESTIONS AND ANSWERS
GRADED A+
✔✔The practical significance of taking the logical view of a database is that it serves as
a reminder of the simple file concept of data storage. - ✔✔True
✔✔To simplify the conceptual design, most higher-order relationships are decomposed
into appropriate equivalent __ relationships whenever possible. - ✔✔binary
✔✔The Crow's Foot notation is less implementation-oriented than the Chen notation. -
✔✔False
✔✔In the original Chen notation, each attribute is represented by an oval with the
attribute name connected to an entity rectangle with a line. - ✔✔True
✔✔When using the Crow's Foot notation, the associative entity is indicated by __
relationship lines between the parents and the associative entity. - ✔✔solid
✔✔A(n) __ is an orderly arrangement used to logically access rows in a table. -
✔✔index
✔✔In Chen notation, there is no way to represent cardinality. - ✔✔False
✔✔The decision to store __ attributes in database tables depends on the processing
requirements and the constraints placed on a particular application. - ✔✔derived
✔✔The __ is actually a system-created database whose tables store the
user/designercreated database characteristics and contents. - ✔✔system catalog
✔✔____ are especially useful when you are trying to determine what values in related
tables cause referential integrity problems. - ✔✔Outer joins
✔✔To implement a small database, a database designer must know the "1" and the "M"
sides of each relationship and whether the relationships are mandatory or optional. -
✔✔True
✔✔In the entity relationship diagram (ERD), cardinality is indicated using the __
notation, where max is the maximum number of associated entities and min represents
the minimum number of associated entities. - ✔✔(min, max)
✔✔Character data can contain any character or symbol intended for mathematical
manipulation. - ✔✔False
, ✔✔The first step in building an entity-relationship diagram (ERO) is __ - ✔✔creating a
detailed narrative of the organization's description of operations
✔✔Relationships between entities always operate in one direction. - ✔✔False
✔✔A(n) __ is the set of possible values for a given attribute. - ✔✔domain
✔✔Each table ____ represents an attribute. - ✔✔column
✔✔______ , also known as RESTRICT, yields values for all rows found in a table that
satisfy a given condition. - ✔✔SELECT
✔✔Database designers determine the data and information that yield the required
understanding of the entire business. - ✔✔False
✔✔A(n) ___ is the equivalent of a field in a file system. - ✔✔attribute
✔✔A verb associating two nouns in a business rule translates to a(n) __ in the data
model. - ✔✔relationship
✔✔Data is said to be verifiable if: - ✔✔the data always yields consistent results.
✔✔Which of the following is true of spreadsheet applications? - ✔✔They enhance the
user's ability to understand the data.
✔✔The relational data model was developed in the ____. - ✔✔1970s
✔✔The __ model is the end users' view of the data environment. - ✔✔external
✔✔The only way to access the data in a database is through the DBMS. - ✔✔True
✔✔In the __ model, the basic logical structure is represented as an upside-down tree. -
✔✔hierarchical
✔✔In an SQL-based relational database, each table is dependent on every other table.
- ✔✔False
✔✔A data warehouse can store data derived from many sources. - ✔✔True
✔✔_____relates to the activities that make the database execute transactions more
efficiently in terms of storage and access speed. - ✔✔Performance tuning
GRADED A+
✔✔The practical significance of taking the logical view of a database is that it serves as
a reminder of the simple file concept of data storage. - ✔✔True
✔✔To simplify the conceptual design, most higher-order relationships are decomposed
into appropriate equivalent __ relationships whenever possible. - ✔✔binary
✔✔The Crow's Foot notation is less implementation-oriented than the Chen notation. -
✔✔False
✔✔In the original Chen notation, each attribute is represented by an oval with the
attribute name connected to an entity rectangle with a line. - ✔✔True
✔✔When using the Crow's Foot notation, the associative entity is indicated by __
relationship lines between the parents and the associative entity. - ✔✔solid
✔✔A(n) __ is an orderly arrangement used to logically access rows in a table. -
✔✔index
✔✔In Chen notation, there is no way to represent cardinality. - ✔✔False
✔✔The decision to store __ attributes in database tables depends on the processing
requirements and the constraints placed on a particular application. - ✔✔derived
✔✔The __ is actually a system-created database whose tables store the
user/designercreated database characteristics and contents. - ✔✔system catalog
✔✔____ are especially useful when you are trying to determine what values in related
tables cause referential integrity problems. - ✔✔Outer joins
✔✔To implement a small database, a database designer must know the "1" and the "M"
sides of each relationship and whether the relationships are mandatory or optional. -
✔✔True
✔✔In the entity relationship diagram (ERD), cardinality is indicated using the __
notation, where max is the maximum number of associated entities and min represents
the minimum number of associated entities. - ✔✔(min, max)
✔✔Character data can contain any character or symbol intended for mathematical
manipulation. - ✔✔False
, ✔✔The first step in building an entity-relationship diagram (ERO) is __ - ✔✔creating a
detailed narrative of the organization's description of operations
✔✔Relationships between entities always operate in one direction. - ✔✔False
✔✔A(n) __ is the set of possible values for a given attribute. - ✔✔domain
✔✔Each table ____ represents an attribute. - ✔✔column
✔✔______ , also known as RESTRICT, yields values for all rows found in a table that
satisfy a given condition. - ✔✔SELECT
✔✔Database designers determine the data and information that yield the required
understanding of the entire business. - ✔✔False
✔✔A(n) ___ is the equivalent of a field in a file system. - ✔✔attribute
✔✔A verb associating two nouns in a business rule translates to a(n) __ in the data
model. - ✔✔relationship
✔✔Data is said to be verifiable if: - ✔✔the data always yields consistent results.
✔✔Which of the following is true of spreadsheet applications? - ✔✔They enhance the
user's ability to understand the data.
✔✔The relational data model was developed in the ____. - ✔✔1970s
✔✔The __ model is the end users' view of the data environment. - ✔✔external
✔✔The only way to access the data in a database is through the DBMS. - ✔✔True
✔✔In the __ model, the basic logical structure is represented as an upside-down tree. -
✔✔hierarchical
✔✔In an SQL-based relational database, each table is dependent on every other table.
- ✔✔False
✔✔A data warehouse can store data derived from many sources. - ✔✔True
✔✔_____relates to the activities that make the database execute transactions more
efficiently in terms of storage and access speed. - ✔✔Performance tuning
