MISY 5300 ACTUAL EXAM PAPER 2026
QUESTIONS WITH ANSWERS GRADED A+
●● User views.
Answer: The specific data needed by a person or process for a particular
task
●● One-to-Many Relationship.
Answer: Means one record in the table on the "one side of the
relationship can be linked or related to many records in the table on the
"many" side of the relationship
●● Alternate Key (AK).
Answer: Is a field that contains unique data for each record in the table
but is not used as the primary key field for security or other reasons
●● Secondary Key.
Answer: Represents a field or combination of fields that may not be
unique, but is commonly used for retrieval and this should be indexed
●● Cardinality.
Answer: The uniqueness of data values contained in a single field
, ●● Cartesian Join.
Answer: When two tables in a query have no instructions about how to
connect their records, each record in one table connects with each record
in the other table
●● Composite Entity.
Answer: In the ERM, the middle entity. An entity in the entity-
relationship model used to implement a many-to-many relationship
●● Crow's Foot notation.
Answer: Uses a symbol on the side of the "many" entity that resembles a
crow's foot. In crow's foot notation, specific attributes for each entity are
not listed within each entity rectangle
●● Database Design Language (DBDL).
Answer: A relational-like language that is used to represent the result of
the database design process.
●● Entity Relationship Diagram (ERD).
Answer: Uses rectangles to represent the entities (tables) and lines to
represent the relationships between tables.
●● Entity-Relationship Model (ERM).
Answer: Uses rectangles for entities and diamonds for relationships.
QUESTIONS WITH ANSWERS GRADED A+
●● User views.
Answer: The specific data needed by a person or process for a particular
task
●● One-to-Many Relationship.
Answer: Means one record in the table on the "one side of the
relationship can be linked or related to many records in the table on the
"many" side of the relationship
●● Alternate Key (AK).
Answer: Is a field that contains unique data for each record in the table
but is not used as the primary key field for security or other reasons
●● Secondary Key.
Answer: Represents a field or combination of fields that may not be
unique, but is commonly used for retrieval and this should be indexed
●● Cardinality.
Answer: The uniqueness of data values contained in a single field
, ●● Cartesian Join.
Answer: When two tables in a query have no instructions about how to
connect their records, each record in one table connects with each record
in the other table
●● Composite Entity.
Answer: In the ERM, the middle entity. An entity in the entity-
relationship model used to implement a many-to-many relationship
●● Crow's Foot notation.
Answer: Uses a symbol on the side of the "many" entity that resembles a
crow's foot. In crow's foot notation, specific attributes for each entity are
not listed within each entity rectangle
●● Database Design Language (DBDL).
Answer: A relational-like language that is used to represent the result of
the database design process.
●● Entity Relationship Diagram (ERD).
Answer: Uses rectangles to represent the entities (tables) and lines to
represent the relationships between tables.
●● Entity-Relationship Model (ERM).
Answer: Uses rectangles for entities and diamonds for relationships.
