COURSE CODE / : SBET2143
KOD MATA PELAJARAN
MATA PELAJARAN/ : DATABASE SYSTEM AND MANAGEMENT/
COURSE TITLE PENGURUSAN DAN SISTEM PENGKALAN DATA
PROGRAME/ : LAND ADMINISTRATION AND
PROGRAM DEVELOPMENT /PENTADBIRAN PEMBANGUNAN
TANAH
GROUP: 5
1. PUTERI AMIRA QISTINA BINTI AZMI A23BE0374
2. NUR AININ SOFIA BINTI ROSLAN A23BE0295
3. KAUSAR BINTI RAMLI B24BE0024
4. MUHAMMAD AZROY AZZI BIN MOHD A23BE0215
DIAH
5. FAIZATUL AZWA BINTI HAIRIL HUSNI A23BE0102
1. σ Poskod = 81300 (Property)
Lot_Num Account_Num Address1 Address2 Residential Poskod
_Area
0108002 A0005002 No Jalan P1/14 Taman 81300
13079 Pulai Indah
0108004 A0010938 No Jalan P1/15 Taman 81300
13080 Pulai Indah
0108012 A0005001 No19405 Jalan P1/15 Taman 81300
Pulai Indah
2. σ Mukim = Pulai (Land Parcel)
Lot_Num Negeri Daerah Mukim Area
0108001 Johor Johor Bahru Pulai 1500000.00
0108002 Johor Johor Bahru Pulai 1000000.00
3. ∏ Ic_num, owner_name (Ownership)
IC_Num owner_Name
67091801 WAN ISMAIL
80051801 ISMAIL IBRAHIM
77120901 AHMAD NOR
80130901 ISKANDAR
4. ∏ lot_num, account_Num, poskod (Property)
Property
Lot_num Account_Num poskod
0508010 A0901110 82000
0108001 A0005001 81415
0108002 A0005002 81300
0108004 A0010938 81300
0108923 A0005001 81415
0108012 A0005001 81300
5. ∏ account_num (Ownership) U ∏ account_num (Property)
Account_num
A0901110
A0005001
A0005002
A0035071
A0010938
6. σ Area ≥ 20000 (Land Parcel)
Lot_Num Negeri Daerah Mukim Area
0108001 Johor Johor Bahru Pulai 1500000.00
0108002 Johor Johor Bahru Pulai 1000000.00
7. ∏ account_num (ownership) ∩ ∏account_num (Property)
Account Number
A0901110
A0005001
A0005002
8. ∏ account_num (Property) - ∏ account_num (Ownership)
Account number
A0035071
A0010938
9. (∏ account_num, owner_name (Ownership)) ∞ (∏ account_num, lot_num, poskod
(Property))
Account num Owner name Lot Num
A0901110 WAN ISMAIL 0508010
A0005001 ISMAIL IBRAHIM 0108001
A0005002 AHMAD NOR 0108002
10. (∏ account_num, owner_name (Ownership)) ∞
(∏ account_num, lot_num, Address1, Address2 (Property)) ∞
(∏ lot_num, area (Land Parcel))
Account_num Owner_Name Lot_Num Address1 Address2 Area
A0901110 WAN ISMAIL 0508010 Lot 050810 NULL 10900.00
A0005001 ISMAIL 0108001 No 13078 Jalan P1/14 1500000.0
A0005002 IBRAHIM 0108002 No 13079 Jalan P1/14 0
AHMAD NOR 1000000.0
0
A0035071 ISKANDAR NULL NULL NULL NULL
A0010938 NULL 0108004 No 13080 Jalan P1/15 NULL
A0005001 ISMAIL 0108923 No 13077 Jalan P1/14 NULL
IBRAHIM
A0005001 ISMAIL 0108012 No 19405 Jalan P1/15 NULL
IBRAHIM