BFOR 300 RAT 1 NEW EXAM WITH COMPLETE
SOLUTIONS 100% VERIFIED
Entity relationship model - ANSWER the logical representation of an organization
Entities - ANSWER customers, cars , and parts are examples of?
Attributes - ANSWER A person's name , birthday, and social security number are all
examples of?
strong entity - ANSWER an entity that exists independently of other entity types
composite - ANSWER an attribute that can be broken down into smaller parts
one - ANSWER the number of entity types that participate in a Unary relationship is
degree - ANSWER the number of entity types that participate in a relationship is called
what?
weak entity - ANSWER An entity type that exists dependently on other entities.
Business rules - ANSWER represents the language and fundamental structure of an
organization.
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. - ANSWER Entity
Relationship Model (what is it/ pros of using it?)
Entity - ANSWER The objects of the organization.
ex. customer, product (metadata)
Entity type - ANSWER a collection of entities that share common properties or
characteristics.
Relationship cardinalities - ANSWER represents how many entities of one kind relate to
how many entities of another kind.
Entity Instance - ANSWER is a single occurrence of an entity type.
Strong Entity type - ANSWER is an type of entity that exits independently of other entity
types.
ex. student, employee, automobile and course.
-has its own unique identifier
Weak Entity type - ANSWER is an entity type whose existence depends on some other
entity type.
SOLUTIONS 100% VERIFIED
Entity relationship model - ANSWER the logical representation of an organization
Entities - ANSWER customers, cars , and parts are examples of?
Attributes - ANSWER A person's name , birthday, and social security number are all
examples of?
strong entity - ANSWER an entity that exists independently of other entity types
composite - ANSWER an attribute that can be broken down into smaller parts
one - ANSWER the number of entity types that participate in a Unary relationship is
degree - ANSWER the number of entity types that participate in a relationship is called
what?
weak entity - ANSWER An entity type that exists dependently on other entities.
Business rules - ANSWER represents the language and fundamental structure of an
organization.
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. - ANSWER Entity
Relationship Model (what is it/ pros of using it?)
Entity - ANSWER The objects of the organization.
ex. customer, product (metadata)
Entity type - ANSWER a collection of entities that share common properties or
characteristics.
Relationship cardinalities - ANSWER represents how many entities of one kind relate to
how many entities of another kind.
Entity Instance - ANSWER is a single occurrence of an entity type.
Strong Entity type - ANSWER is an type of entity that exits independently of other entity
types.
ex. student, employee, automobile and course.
-has its own unique identifier
Weak Entity type - ANSWER is an entity type whose existence depends on some other
entity type.
