38
merupakan
sumber
informasi
untuk
tahapan
selanjutnya
yang
dinamakan
perancangan basisdata fisikal.
Hasil
akhir
dari
tahapan
ini
berupa
sebuah
kamus
data
yang
berisi
semua
atribut beserta key-nya (primary key, alternate key dan foreign key) dan ERD
keseluruhan (relasi global) dengan semua atribut key-nya.
Manager
staffNo {PK,FK}
1..1
Telephone
telNo {PK}
Supervises
0..1
0..10
IS-A
1..1
1..1
Manages
1..1
1..1
branchNo {FK}
1..3
Staff
staffNo {PK}
supervisorStaff {FK}
0..1
branchNo {FK}
1..1
Has
Branch
1..1
branchNo {PK}
mgrStaffNo {FK}
1..1
1..1
Processes
Register
0..*
Registration
clientNo {PK}
branchNo {FK}
staffNo {FK}
1..1
Agrees
1..1
Oversees
Hold
Client
1..1 clientNo {PK}
1..1
Request
Offers
0..*
0..*
Lease
leaseNo {PK}
clientNo {FK}
propertyNo {FK}
0..*
LeasedBy
1..1
0..100
PropertyForRent
propertyNo {PK}
clientNo {FK}
staffNo {FK}
branchNo {FK}
1..*
1..1
1..*
1..1
1..*
Viewing
clientNo {PK,FK}
propertyNo {PK,FK}
0..*
Takes
PlaceIn
POwn
0..1
BOwn
0..1
0..*
PrivateOwner
ownerNo {PK}
BusinessOwner
ownerNo {PK}
Advert
propertyNo {PK,FK}
newspaperName
{PK,FK}
dateAdvert {PK}
1..*
Display 1..1
Newspaper
newspaperName {PK}
Gambar 2.12 Contoh Entity Relationship Keseluruhan pada tahapan Logical
Database Design (Sumber : Connolly dan Begg, 2002, p471)
 |