NEW
Font size
S
M
L
XL
WorksheetsERD DATABASE
Total questions: 15
Worksheet time: 8mins
Name
Class
Date
1.
What entity type is used in the given diagram?
a)
STUDENT
b)
DOCTOR
c)
EMPLOYEE
d)
COURSE
2.
Which attribute is the MULTI-VALUED ATTRIBUTE?
a)
EmpID
b)
Degree
c)
Age
d)
Address
3.
Which attribute is the COMPOSITE ATTRIBUTE?
a)
Degree
b)
Age
c)
Salary
d)
Address
4.
Which attribute is the DERIVED ATTRIBUTE?
a)
EmpID
b)
Age
c)
Name
d)
Degree
5.
Which attribute is the KEY IDENTIFIER or the PRIMARY KEY?
a)
EmpID
b)
Degree
c)
Name
d)
Birthday
6.
This symbol indicates _____ relationship.
a)
one or many
b)
zero or many
c)
zero or one
d)
many to many
7.
This symbol indicates _____ relationship.
a)
zero or one
zero or one
zero or one
b)
zero or many
c)
one or many
d)
many to many
8.
_________is a person, place, object, event or concept in the user environment about which company wishes to maintain the data
a)
attribute
b)
entity
c)
relationship
d)
none of these
9.
Each entity is described by __________.
a)
entity
b)
relationship
c)
none of these
d)
attribute
10.
This key uniquely identifies each record in an entity.
a)
Primary Key or Key Identifier
b)
Foreign Key
c)
Secondary Key
d)
Composite Key
11.
Diamond shape is symbol for ?
a)
Entity
b)
Cardinality
c)
Relationship
d)
Atribut
12.
This shape is symbol for ?
a)
Atribut
b)
Relationship
c)
Entity
d)
Cardinality
13.
For ERD this shape describe for ?
a)
Cardinality
b)
Relationship
c)
Attribute
d)
Entity
14.
If you were collecting and storing information about your music collection, an album would be considered a(n) _____.
a)
Relation
b)
Entity
c)
Instance
d)
Attribute
15.
The entity relationship set is represented in E-R diagram as
a)
Double diamonds
b)
Undivided rectangles
c)
Dashed lines
d)
Diamond
Reset
