I need help with normalization

  • Thread starter Thread starter Charles W. Stricklin
  • Start date Start date
C

Charles W. Stricklin

My database classes were nearly a decade ago and I was never very good
with normalization to begin with. I could use some help with this:

I am writing a db to keep track of automated teller machines: what
version of software they use, what hardware they use, the last time they
were serviced, where they're located, etc.

We deal with multiple banks and credit unions. Most of these financial
institutions have several locations. Each of these locations have at
least one ATM, sometimes several for the larger/busier branches.

As I understand things, the ATM records will have many-to-one
relationship with the locations record , and the locations records with
also have a many-to-one relationship with the financial institution
record. Am I incorrect?
 
Sounds correct to me.



My database classes were nearly a decade ago and I was never very good
with normalization to begin with. I could use some help with this:

I am writing a db to keep track of automated teller machines: what
version of software they use, what hardware they use, the last time they
were serviced, where they're located, etc.

We deal with multiple banks and credit unions. Most of these financial
institutions have several locations. Each of these locations have at
least one ATM, sometimes several for the larger/busier branches.

As I understand things, the ATM records will have many-to-one
relationship with the locations record , and the locations records with
also have a many-to-one relationship with the financial institution
record. Am I incorrect?


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Charles,
As I understand things, the ATM records will have many-to-one
relationship with the locations record , and the locations records with
also have a many-to-one relationship with the financial institution
record. Am I incorrect?

You're not incorrect.
My database classes were nearly a decade ago and I was never very good
with normalization to begin with. I could use some help with this:

Well, you seem to be doing good so far as I can tell.
I tell ya, normalization is overrated... :-)

Immanuel Sibero
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top