Home Start Back Next End
  
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)
Word to PDF Converter | Word to HTML Converter