42
ClientRental
clientNo
propertyNo
cName
pAddress
rentStart
rentFinish
rent
ownerNo
oName
CR76
PG4
John
Kay
6
Lawrence
St, Glasgow
1-Jul-00
31-Aug-
01
350
CO40
Tina
Murphy
CR76
PG16
John
Kay
5
Novar Dr.
Glasgow
1-Sep-01
1-Sep-02
450
C093
Tony
Shaw
CR56
PG4
Aline
Stewart
6
Lawrence
St, Glasgow
1-Sep-99
10-Jun-00
350
CO40
Tina
Murphy
CR56
PG36
Aline
Stewart
2
Manor Rd,
Glasgow
10-Oct-
00
1-Dec-01
375
CO93
Tony
Shaw
CR56
PG16
Aline
Stewart
5
Novar Dr.
Glasgow
1-Nov-01
10-Aug-
03
450
CO93
Tony
Shaw
Tabel 2.2 Tabel ClientRental 1NF.
(Sumber: Connolly dan Begg, 2010, p432)
Client
clientNo
cName
CR76
John Kay
CR56
Aline Stewart
PropertyRentalOwner
clientNo
propertyNo
pAddress
rentStart
rentFinish
rent
ownerNo
oName
CR76
PG4
6
Lawrence
St, Glasgow
1-Jul-00
31-Aug-
01
350
CO40
Tina
Murphy
CR76
PG16
5
Novar Dr.
Glasgow
1-Sep-01
1-Sep-02
450
C093
Tony Shaw
CR56
PG4
6
Lawrence
St, Glasgow
1-Sep-99
10-Jun-00
350
CO40
Tina
Murphy
CR56
PG36
2
Manor Rd,
Glasgow
10-Oct-00
1-Dec-01
375
CO93
Tony Shaw
CR56
PG16
5
Novar Dr.
Glasgow
1-Nov-01
10-Aug-
03
450
CO93
Tony Shaw
Tabel 2.3 Tabel ClientRental 1NF alternatif.
(Sumber: Connolly dan Begg, 2010, p433)
2.14.3 Second Normal Form (2NF)
Menurut
Connolly
dan
Begg
(2010,
p434),
Second
Normal
Form (2NF)
dapat
berarti sebagai sebuah relasi
yang
terdapat di dalam 1NF dan setiap atribut
yang bukan
primary key full functional depedency pada primary key nya.
 |