Rabu, 05 November 2014

Dreamhome Database Praktikum Komputer B

Posted by TUGAS On 18.02 0 komentar

Nama : Ade Prayogy Wicaksono
NPM  : 10314190
Kelas  : 1TA04

Dreamhome Database


Registration
Client No
Branch No
Staff No
Date-joined
CR 56
B003
SG 37
11/04/2000
CR 74
B003
SG 37
16/11/1999
CR 76
B005
SL 41
02/01/2001
CR 62
B007
SA 9
07/03/2000

Viewing
Client No
Property No
View - Date
Comment
CR 56
PA 14
24/03/2001
Too small
CR 56
PG 4
26/05/2001
-
CR 56
PG 36
28/04/2001
-
CR 62
PA 14
14/05/2001
No dining room
CR 76
PG 4
20/04/2001
Too remote

Client
Client No
F Name
L Name
Telephone No
Pref Type
Max Rent
CR 56
Aline
Steward
0141-848-1825
Flat
350
CR 62
Mary
Tregear
0122-419-6720
Flat
600
CR 74
Mike
Ritchie
0147-539-2178
Home
750
CR 76
John
Ray
0807-774-5632
Flat
425

Client
Private Owner
F Name
L Name
Address
Telephone No
CO 40
Tina
Murphy
63 Well St. Glasgow G42
0141-943-1728
CO 46
Joe
Leogh
2 Fergus Dr. Aberdieen AB275X
0122-486-1212
CO 87
Carol
Farrel
6 Achray St. Glasgow G329DX
0141-357-7419
CO 93
Tony
Shaw
11 Park PI. Glasgow G40QR
0141-225-7025

Property For Rent
Property No
Street
City
Post Code
Type
Rooms
Rent
Owner No
Staff No
Branch No
PA 14
16 Holhead
Abeerdeen
AB7550
Home
6
650
CO 46
SA 9
B007
PG 4
6 Lawrence St.
Glasgow
Gll 9QX
Flat
3
350
CO 40
-
B003
PG 16
5 Novar Dr.
Glasgow
G129AX
Flat
4
450
CO 93
SG 14
B003
PG 21
18 Dale Rd.
Glasgow
G12
Home
5
600
CO 87
SG 37
B003
PG 36
2 Manor Rd.
Glasgow
G32 4QX
Flat
3
375
CO 93
SG 37
B003
PL 94
6 Argxllst
Condon
NW 2
Flat
4
400
CO 87
SL 41
B005

Branch
Branch No
Street
City
Post Code
B002
56 Clover Dr.
London
NW10 6EU
B003
163 Main St.
Glasgow
GII 9QX
B004
32 Monse Rd.
Bristol
BS99 QNZ
B005
22 Deer Rd.
London
SWI 4EH
B007
16 Arg yll St.
Abeerdeen
AB2 354


Staff
Staff No
F Name
L Name
Position
Sex
POB
Salary
Branch No
SA 9
Marry
Howe
Assistant
F
01/10/1945
30000
B005
SG 14
David
Ford
Supervisor
M
10/11/1960
12000
B003
SG 37
Ann
Buch
Assistant
F
24/03/1958
18000
B003
SG 5
Susan
Brand
Manager
F
19/02/1970
9000
B007
SL 21
John
White
Manager
M
03/06/1940
24000
B003
SL 41
Julie
Lee
Assistant
F
13/06/1965
9000
B005

0 komentar:

Posting Komentar