Bank Branch Details

[rs2k]

Just some advice needed here;

I'm attempting to set up a db for a small company and I'm not sure on how to set up tables for employees bank details. As the employees are geographically spread out, some have the same bank, say TSB, but they are different branches, so they will have different addresses, sort codes etc...

So, my bank table will have a bankID, Name, address etc... the bank name will be repeated many times, which I believe is not good db design practice,

Could anyone advise me on this please?

Many thanks
Colin

 

[Norie]

Colin

I don't think not having a bank table would be seriously breaking any normalization rules.

How many employees are going to use the same bank, branch etc for payment details?

 

[rs2k]

Hi Norie,

Thanks for the response, I'm still trying to get my head around access tables structures, relationships etc... (3 weeks is my record, before I bin'd it and went back toExcel)

I found this post http://www.mrexcel.com/forum/showthread.php?t=439242&highlight=multiple+addresses

Which has given me some kind of guidance,

Cheers
Colin

 

[Norie]

Colin

What sort of database are you trying to set up?

Are you trying to create something that encompasses every aspect of the business in one database?

 

[rs2k]

Norie,

In a word... yes!

Judging by the question, I shouldn't do that, should I?

Any advice would be gratefully received. The db is for a autistic centre that provides day care & overnight care. Here is a breakdown of what I have/want;

Employees - name, address, contact info & bank details to pay them.
Clients - name, address, contact info
Bookings - day bookings and overnight care (5 bed unit)

From this I will need to generate invoices. I'm guessing more will be required, so if I can get this bit working, I'm hoping any additions will be a bit easier if I follow the same structure.

All advice is welcomed,

I'm out on the road today, so wont be able to answer any questions until tomorrow evening.

Many thanks
Colin