KELOMPOK 6 :

NAMA NIM

Anky markus 32100108

Andy Setiawan 31130025

Stefanus 31130064

Steffi 31130060

Steven william 31130036

9. Jumlah Record = 7Jumlah Field = 5

10. Semua susunan data yang ada akan berubah, karena data yang ada di susun berdasarkan kotaKarena data yang berada dalam field manager_address tidak tersusun rapih

MANAGER_ADDRESSPROJECT_CODE PROJECT_MANAGER

MANAGER_PHONE

PROJECT_BID_PRICE

124 River Dr., Franklin, Tn 29185 25-5A George F. Dorts 615-227-1245 32512420,00124 River Dr., Franklin, Tn 29185 27-4Q George F. Dorts 615-227-1245 10314545,00216 Morton Rd., Stetson, FL 30155 31-7P William K. Moor 904-445-2719 56850000,00218 Clark Btvd., Nashville, TN 36362 25-2D Jane D. Grant 615-898-9909 12500000,003334 Lee Rd., GainesVille, FL 37123 21-5Z Holly B. Parker 904-338-3416 16833460,003334 Lee Rd., GainesVille, FL 37123 25-9T Holly B. Parker 904-338-3416 21563234,003334 Lee Rd., GainesVille, FL 37123 29-2D Holly B. Parker 904-338-3416 25559999,00

11. Laporan data berdasarkan NAMA_AKHIRNAMA_AKHIR

PROJECT_CODE PROJECT_MANAGER

MANAGER_PHONE

KODE_AREA KOTA KODE_POS PROJECT_BID_PRICE

Clark Blvd. 25-2D Jane D. Grant 615-898-9909 218 Nashville 36362 12500000,00Lee Rd. 21-5Z Holly B. Parker 904-338-3416 3334 Gainesville 37123 16833460,00Lee Rd. 25-9T Holly B. Parker 904-338-3416 3334 Gainesville 37123 21563234,00Lee Rd. 29-2D Holly B. Parker 904-338-3416 3334 Gainesville 37123 25559999,00Morton Rd. 31-7P William K. Moor 904-445-2719 216 Stetson 30155 56850000,00River Dr. 25-5A George F. Dorts 615-227-1245 124 Franklin 29185 32512420,00River Dr. 27-4Q George F. Dorts 615-227-1245 124 Franklin 29185 10314545,00

Laporan data berdasarkan KODE_AREA

KODE_AREA

PROJECT_CODE PROJECT_MANAGER

MANAGER_PHONE

NAMA_AKHIR KOTA KODE_POS PROJECT_BID_PRICE

124 25-5A George F. Dorts 615-227-1245 River Dr. Franklin 29185 32512420,00124 27-4Q George F. Dorts 615-227-1245 River Dr. Franklin 29185 10314545,00216 31-7P William K. Moor 904-445-2719 Morton Rd. Stetson 30155 56850000,00218 25-2D Jane D. Grant 615-898-9909 Clark Blvd. Nashville 36362 12500000,00

3334 21-5Z Holly B. Parker 904-338-3416 Lee Rd. Gainesville 37123 16833460,003334 25-9T Holly B. Parker 904-338-3416 Lee Rd. Gainesville 37123 21563234,003334 29-2D Holly B. Parker 904-338-3416 Lee Rd. Gainesville 37123 25559999,00

Laporan data berdasarkan KOTA

KOTAPROJECT_CODE PROJECT_MANAGER

MANAGER_PHONE

NAMA_AKHIR

KODE_AREA KODE_POS PROJECT_BID_PRICE

Franklin 25-5A George F. Dorts 615-227-1245 River Dr. 124 29185 32512420,00Franklin 27-4Q George F. Dorts 615-227-1245 River Dr. 124 29185 10314545,00Gainesville 21-5Z Holly B. Parker 904-338-3416 Lee Rd. 3334 37123 16833460,00 Gainesville 25-9T Holly B. Parker 904-338-3416 Lee Rd. 3334 37123 21563234,00Gainesville 29-2D Holly B. Parker 904-338-3416 Lee Rd. 3334 37123 25559999,00Nashville 25-2D Jane D. Grant 615-898-9909 Clark Blvd. 218 36362 12500000,00Stetson 31-7P William K. Moor 904-445-2719 Morton Rd. 216 30155 56850000,00

Laporan data berdasarkan KODE_POS

KODE_POSPROJECT_CODE PROJECT_MANAGER

MANAGER_PHONE

NAMA_AKHIR

KODE_AREA KOTA PROJECT_BID_PRICE

29185 25-5A George F. Dorts 615-227-1245 River Dr. 124 Franklin 32512420,0029185 27-4Q George F. Dorts 615-227-1245 River Dr. 124 Franklin 10314545,0030155 31-7P William K. Moor 904-445-2719 Morton Rd. 216 Stetson 56850000,0036362 25-2D Jane D. Grant 615-898-9909 Clark Blvd. 218 Nashville 12500000,0037123 21-5Z Holly B. Parker 904-338-3416 Lee Rd. 3334 Gainesville 16833460,0037123 25-9T Holly B. Parker 904-338-3416 Lee Rd. 3334 Gainesville 21563234,0037123 29-2D Holly B. Parker 904-338-3416 Lee Rd. 3334 Gainesville 25559999,00

12. Terdeteksi pada field PROJECT_MANAGER, menyebabkan data pada colom MANAGER_PHONE dan colom MANAGER_ADDRESS di tulis ulang.

13. EMP_NAME tidak perlu di munculkan, karena sudah ada EMP_NUM