Addbranchinformaontotheaccounttable

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: y
more
than
one
 customer;

 –  An
account
is
in
one
branch

 •  Branch:
 

 –  Branches
can
have
many
accounts
 •  Here
are
tables
for
each
of
the
three
en))es
 we
iden)fied.
 Missing
Informa)on
 •  Rela)ons:
 Is
 anything
 missing?
 We
have

 informa-on
 about:
 Customers

 Accounts

 Branch
 
 
 –  Customers
have
accounts
 –  Accounts
are
located
in
Branches
 
 •  How
do
we
bring
this
informa)on
into
the
 database?
 –  Add
branch
informa)on
to
the
account
table
 –  Create
a
new
table
t...
View Full Document

This note was uploaded on 05/08/2013 for the course STAT 133 taught by Professor Staff during the Fall '08 term at University of California, Berkeley.

Ask a homework question - tutors are online