wayground logo

Free Printable Worksheets

NEW

Font size

S
M
L
XL
Worksheets

Bab 3 ERD

Total questions: 18

Worksheet time: 9mins

Name
Class
Date
1.

Kesemua di bawah merupakan komponen ERD kecuali?

a)

Atribut

b)

Entiti

c)

Kekardinalan

d)

Hubungan

2.

Bentuk entiti adalah segi empat tepat.

a)

Betul

b)

Salah

3.

Berapakah jenis atribut ?

a)

1

b)

7

c)

6

d)

4

4.

Bacaan yang manakah betul bagi gambar diatas?

a)

Guru sedang mengajar satu matapelajaran

b)

Guru hendaklah mengajar sekurang-kurangnya satu matapelajaran

c)

Guru haruslah mengajar sekurang-kurangnya satu atau lebih matapelajaran.

d)

Guru haruslah mengajar banyak matapelajaran.

5.
What entity type is used in the given diagram?
a)
STUDENT
b)
DOCTOR
c)
EMPLOYEE
d)
COURSE
6.
Which attribute is the MULTI-VALUED ATTRIBUTE?
a)
EmpID
b)
Degree
c)
Age
d)
Address
7.

Which attribute is the COMPOSITE ATTRIBUTE?

a)

Degree

b)

Age

c)

Salary

d)

Address

8.
Which attribute is the DERIVED ATTRIBUTE?
a)
EmpID
b)
Age
c)
Name
d)
Degree
9.
Which attribute is the KEY IDENTIFIER or the PRIMARY KEY?
a)
EmpID
b)
Degree
c)
Name
d)
Birthday
10.
This symbol indicates _____ relationship.
a)
one or many
b)
zero or many
c)
zero or one
d)
many to many
11.
This symbol indicates _____ relationship.
a)
zero or one
zero or one
b)
zero or many
c)
one or many
d)
many to many
12.
_________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
13.

Each entity is described by __________.

a)

entity

b)

relationship

c)

none of these

d)

attribute

14.

This key uniquely identifies each record in an entity.

a)

Primary Key or Key Identifier

b)

Foreign Key

c)

Secondary Key

d)

Composite Key

15.

Diamond shape is symbol for ?

a)

Entity

b)

Cardinality

c)

Relationship

d)

Atribut

16.

This shape is symbol for ?

a)

Atribut

b)

Relationship

c)

Entity

d)

Cardinality

17.

For ERD this shape describe for ?

a)

Cardinality

b)

Relationship

c)

Attribute

d)

Entity

18.
The entity relationship set is represented in E-R diagram as
a)
Double diamonds
b)
Undivided rectangles
c)
Dashed lines
d)
Diamond