Re: Database design, Keys and some other things


"Marshall Spight" <marshall.spight@xxxxxxxxx> wrote in message
news:1127788646.640736.293230@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> What's a VIN, then? Are we all imagining them? Are they somehow
> outside of the real world? Is your bank account id somehow
> Not Of This Earth? If you bank account didn't have an id,
> would it be enough to identify it just by the balance?
> "There is a bank account that is a checking account, with
> $1,000,000.00 in it." Could I then authenticate myself to
> the bank by saying, yeah, I'm the guy with the million
> dollars in the bank. If you forgot your balance, would
> that mean you lost access to your money?

A VIN, a bank account number, and an SSN are all surrogate keys. We tend
not to recognize them as such because they are created and managed by an
agency outside the control of the system we are building or designing. But
they are just as artificial as PersonId, created by our system when a "new"
person is introduced to the system.



.

Relevant Pages

  • Re: Database design, Keys and some other things
    ... Is your bank account id somehow ... If you bank account didn't have an id, ... > A VIN, a bank account number, and an SSN are all surrogate keys. ...
    (comp.databases.theory)
  • Drawings - help!
    ... bank account how can I balance this bank account ... I am struggling to find the way to record these drawings ... the actual transactions do not show in the bank account ...
    (uk.business.accountancy)
  • Re: Question
    ... then is thread synchronization really needed ?? ... Review a good article on the classic joint bank account problem. ... the balance and then sets the new balance. ...
    (comp.lang.java.programmer)
  • Re: Drawings - help!
    ... > bank account how can I balance this bank account ... > I am struggling to find the way to record these drawings ... > the actual transactions do not show in the bank account ...
    (uk.business.accountancy)
  • Re: Before I make a stink with Paypal..
    ... > On 9/10 My balance is $82.14 ... > account. ... gotten the $5.11 from your other payment option. ... out of my bank account, but I can't say for sure because I had just assumed ...
    (rec.collecting.coins)