Home Search Sitemap Contact Bookmark

Free Dissertations - I.T. Dissertations

The Following Data Has Been Entered Into The Shivani Claims Service Database ...

The following data has been entered into the Shivani Claims Service database tables as test data. It will assist in evaluating the database, especially where the user is prompted to enter codes for data retrieval.
Table ACCOUNT
Account Code
Client Code
Service Code
Date Set Up
Date Closed
Account Status
Monthly Debits/Credits
Date of Last Payment
Total Account Value

BA-BUS-03/06
BC-LC-009
BUS
22/03/2006

In arrears
£150.00
20/01/2007
£50,000.00

BA-BUS-04/04
BC-WP-001
BUS
04/04/2004

In arrears
£95.98
12/12/2006
£10,000.00

BA-BUS-08/04
BC-RS-002
BUS
29/08/2004

Up to Date
£74.26
01/03/2007
£25,000.00

BA-INS-02/02
BC-SS-007
INS
10/02/2002

Up to Date
£59.48
28/02/2007
£631.00

BA-INS-09/05
BC-SM-004
INS
19/09/2005
20/12/2006
Closed
£0.00
11/12/2006
£0.00

PA-HOM-03/04
PC-RK-001
HOM
22/03/2004

Up to Date
£125.49
15/03/2007
£75,000.00

PA-HOM-11/06
PC-JM-001
HOM
22/11/2006

Up to Date
£219.47
13/03/2007
£40,000.00

PA-INS-07/03
PC-JN-001
INS
06/07/2003
02/02/2004
Closed
£31.25
29/01/2004
£810.00

PA-MGG-03/01
PC-KC-005
MGG
24/03/2001

In arrears
£312.15
01/02/2007
£170,000.00

PA-SSB-05/06
PC-LR-002
SSB
12/05/2006
11/09/2006
Closed
£41.16
10/08/2006
£2,250.00


Table CLIENT
Client Code
Title
First Name
Middle Name/Initial
Surname
Business Name
Contact Name
Date Registered
Client Date of Birth
Company Registration No.
Address
Address
Address
Post Code
Telephone Contact
Email
Nat. Ins. No.
Client Status
Date Client Left

BC-LC-009
n/a
n/a
n/a
n/a
Langley's Clothes
Jane Little
22/03/2007

778301
18 Swiftcadd House
Joseph Rd
Mitcham
CR4 8TH
020 8467 2956
j.little@langleys.co.uk
n/a
CB


BC-RS-002
n/a
n/a
n/a
n/a
Rising Star Pharmacy
Hilary Rollers
22/09/2002

667398
78 Upfield Park Rd
Greenwich
London
SE10 9TJ
07765 398 720
hr@rising-star.co.uk
n/a
HB
20/11/2005

BC-SM-004
n/a
n/a
n/a
n/a
Sokoto Mini Mart
Ade Yekusa
10/04/2001

665402
12 Jella Rise
Kingsbury Circle
Kingsbury
NW9 8UR
07946 284 5091
sokoto-mini-mart@yahoo.co,uk
n/a
HB
10/06/2003

BC-SS-007
n/a
n/a
n/a
n/a
Sunshine Stores
Jack Omoding
22/03/2007

521894
34 Riverside Walk
Valley Rd Park Estate
Croydon
CR9 8EI
020 8 674 0287
jack@sunshine-stores.co.uk
n/a
CB


BC-WP-001
Mrs
n/a
n/a
n/a
Westbury Publishers Ltd
John Higgins
22/03/2007

551293
74 High Street
Wembley Hill Way
Wembley
HA9 8TR
020 7890 4573
westbury-publishers@btinternet.cm
n/a
CB


PC-JM-001
Mr
James

Mason
n/a
n/a
21/03/2006
27/08/1955

457 High Street
East Ham

E8 7RO
020 8967 9935
n/a
HI763901B
CC


PC-JN-001
Ms
Jane
H.


Thanks