©Themoon EXAM SOLUTIONS
27/11/2024 11:35AM
BFOR 300 RAT 1 Exam Questions and
Answers
Entity relationship model - Answers✓✓the logical representation of an organization
Entities - Answers✓✓customers, cars , and parts are examples of?
Attributes - Answers✓✓A person's name , birthday, and social security number are all
examples of?
strong entity - Answers✓✓an entity that exists independently of other entity types
composite - Answers✓✓an attribute that can be broken down into smaller parts
one - Answers✓✓the number of entity types that participate in a Unary relationship is
degree - Answers✓✓the number of entity types that participate in a relationship is called what?
weak entity - Answers✓✓An entity type that exists dependently on other entities.
Business rules - Answers✓✓represents the language and fundamental structure of an
organization.
, ©Themoon EXAM SOLUTIONS
27/11/2024 11:35AM
They are important because they govern how data are handled and stored (can state constraints
on objects).
(E-R model) remains the mainstream approach for conceptual data modeling.
1. Relatively easy to use.
2. Widespread computer - aided software engineering tool support.
3. Belief that entities and relationships are natural modeling concepts in the real world.
*The E-R model is used as a tool for communication between database designers and end users
during the analysis phase of database development. - Answers✓✓Entity Relationship Model
(what is it/ pros of using it?)
Entity - Answers✓✓The objects of the organization.
ex. customer, product (metadata)
Entity type - Answers✓✓a collection of entities that share common properties or
characteristics.
Relationship cardinalities - Answers✓✓represents how many entities of one kind relate to how
many entities of another kind.
Entity Instance - Answers✓✓is a single occurrence of an entity type.
Strong Entity type - Answers✓✓is an type of entity that exits independently of other entity
types.
27/11/2024 11:35AM
BFOR 300 RAT 1 Exam Questions and
Answers
Entity relationship model - Answers✓✓the logical representation of an organization
Entities - Answers✓✓customers, cars , and parts are examples of?
Attributes - Answers✓✓A person's name , birthday, and social security number are all
examples of?
strong entity - Answers✓✓an entity that exists independently of other entity types
composite - Answers✓✓an attribute that can be broken down into smaller parts
one - Answers✓✓the number of entity types that participate in a Unary relationship is
degree - Answers✓✓the number of entity types that participate in a relationship is called what?
weak entity - Answers✓✓An entity type that exists dependently on other entities.
Business rules - Answers✓✓represents the language and fundamental structure of an
organization.
, ©Themoon EXAM SOLUTIONS
27/11/2024 11:35AM
They are important because they govern how data are handled and stored (can state constraints
on objects).
(E-R model) remains the mainstream approach for conceptual data modeling.
1. Relatively easy to use.
2. Widespread computer - aided software engineering tool support.
3. Belief that entities and relationships are natural modeling concepts in the real world.
*The E-R model is used as a tool for communication between database designers and end users
during the analysis phase of database development. - Answers✓✓Entity Relationship Model
(what is it/ pros of using it?)
Entity - Answers✓✓The objects of the organization.
ex. customer, product (metadata)
Entity type - Answers✓✓a collection of entities that share common properties or
characteristics.
Relationship cardinalities - Answers✓✓represents how many entities of one kind relate to how
many entities of another kind.
Entity Instance - Answers✓✓is a single occurrence of an entity type.
Strong Entity type - Answers✓✓is an type of entity that exits independently of other entity
types.
