Font size
WorksheetsQuiz 3
Total questions: 20
Worksheet time: 15mins
A uniquely identifiable object of an entity type
Entity Set
Entity Type
Entity Occurrence
Entity
(a) is a thing or object in our environment that we want to keep track of.
To construct an ERM we need entity, attribute and (a) .
This is the example of __________ relationship.
binary
tertiary
recursive
quarternary
Age is the example of __________ attribute.
derived
simple
multivalue
composite
These are the examples of composite attributes EXCEPT
salary
address
name
matrics no
Which are the examples of multivalued attributes?
phone number
account number
age
Which relationship is INCORRECT?
1:M
M:N
1:1
M:1
State the participation for B
(a)
State cardinality for C
(a)
(a) where a model represents a relationship between entity types, but pathway between certain entity occurrences is ambiguous
Pathway that does not exist between certain entity occurrence is one of the problems in ER Modeling. This statement is referring to which trap?
(a)
Superclass/subclass relationship is __________ relationship.
1:1
1:M
M:N
Specialization is also called as
superclass
subclass
Generalization is also called as _______
superclass
subclass
Given example:
When you are a staff, you can be either normal staff, supervisor or manager.
This example referring to which participation constraint? mandatory or optional?
(a)
Given example:
When you are a staff, you can be either supervisor or manager. However, supervisor and manager cannot be overlapped.
This example referring to which disjoint constraint? AND or OR?
(a)
Entity should be in _______________ shape
rectangular
triangle
square
circle
The set of allowable values for one or more attribute is called as
attribute
entity
attribute domain
entity occurrences
An entity type that is existence dependent on some other entity is called as
weak entity
strong entity
