ACCURATE ANSWERS GRADED A+
◍ 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."
What is the name of this relationship?. Answer: One-to-many binary
relationship
◍ "A salesperson is authorized to sell many products, and a product
can be sold by many salespersons."
What is the name of this relationship?. Answer: Many-to-many binary
relationship
◍ What is the positioning and meaning for Cardinality and Modality
on an E-R model?. Answer: Cardinality is the outer symbol;
represents the maximum.
Modality is the inner symbol; represents the minimum.
◍ "A salesperson works in a minimum of one and a maximum of one
office, and an office may be occupied by or assigned to a minimum of
zero and a maximum of one salesperson.". Answer: