19
Untuk menghubungkan atribut-atribut dengan tipe
entitas atau hubungan, dengan menggunakan tabel di
bawah ini:
hubungan jenis (Connolly & Begg, 2010, 478)
Entity name
Attributes
Description
Data Type &
Length
Nulls
Multivalued
Staff
staffNo
Uniquely
identifies a
member of
staff
5 variable
characters
No
No
name
fName
First name
of staff
15 variable
characters
No
No
lName
Last name
of staff
15 variable
characters
No
No
Position
Job title of
member of
staff
10 variable
characters
No
No
sex
Gender of
member of
staff
1 characters
(M or F)
Yes
No
DOB
Date of
birth of
member of
staff
Date
Yes
No
PropertyForR
propertyNo
Uniquely
5 variable
No
No
 |