FOUNDATIONS FINAL EXAM 2026
QUESTIONS WITH ANSWERS GRADED A+
COMPLETE SOLUTIONS
●● Hashed Files.
Answer: A file that has been encrypted for security purposes.
●● Heap File.
Answer: An unsorted set of records.
●● Information.
Answer: The transformation of raw data into useful facts.
●● Punch Card.
Answer: A card that is perforated and can hold commands or data.
●● Structured Data.
Answer: Information with a high degree of organization.
●● Unstructured Data.
,Answer: Information that does not have structure (such as text)
●● Binary Relationship.
Answer: A relationship between two entity types.
●● Unary Relationship.
Answer: An associate occurrence of an entity type with other
occurrences of the same entity type.
●● Cardinality.
Answer: The maximum number of entities that can be involved in a
particular relationship.
●● E-R Model
*E-R = Entity - Relationship.
Answer: Diagram of entities together with their attributes and the
relationship among them.
●● Intersection Data.
Answer: It is data that describes a many-to-many relationship.
●● Modality.
, Answer: It is a minimum number of entity occurrences that can be
involved in a relationship.
●● One-to-one Binary Relationship.
Answer: It means that a single occurrence of one entity type can be
associated with a single occurrence of the other entity type and vice
versa.
●● Ternary Relationship.
Answer: Involves three different entity types.
●● Unique identifier.
Answer: It is used to uniquely identify each record in a database table.
●● Attribute.
Answer: A property, characteristic, or fact that we know about an entity.
●● "A salesperson works in one office."
What is the name of this relationship?.
Answer: One-to-one binary relationship
●● "A salesperson sells to many customers."