ACCURATE QUESTIONS VERIFIED
◍ Structured Data. Answer: What kind of data is Information with a
high degree of organization.
◍ Unstructured Data. Answer: What kind of data is Information that
does not have structure (such as text)
◍ Binary Relationship. Answer: A relationship between two entity
types.
◍ Unary Relationship. Answer: What type of relationship is an
associate occurrence of an entity type with other occurrences of the
same entity type.
◍ Cardinality Principle. Answer: The maximum number of entities
that can be involved in a particular relationship.
◍ E-R Model
*E-R = Entity - Relationship. Answer: What is the name of the model
that diagrams entities together with their attributes and the
relationship among them.
,◍ Intersection Data. Answer: What is data that describes a many-to-
many relationship.
◍ Modality. Answer: What is a minimum number of entity
occurrences that can be involved in a relationship called
◍ One-to-one Binary Relationship. Answer: What kind of
relationship is 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: What type of relationship Involves
three different entity types.
◍ Unique identifier. Answer: What is used to uniquely identify each
record in a database table.
◍ Attribute. Answer: What is the term used to describe 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:
◍ "A salesperson may have no customers or many customers.".
Answer:
◍ Describe the ER model for "Each salesperson is authorized to sell
to at least one or many products, and each product can be sold by at
least one or many salespeople.". Answer: