Wk12_SQL_4ppB

Wk12_SQL_4ppB - Mul)pleTables...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
11/15/12 1 Mul)ple Tables Where do you see redundancy? What might an en)ty be? (e.g. lab test± Where do you see redundancy? What might an en)ty be? (e.g. lab test± BANK BRANCH Where do you see redundancy? What might an en)ty be? (e.g. lab test± BANK BRANCH CUSTOMER
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
11/15/12 2 Where do you see redundancy? What might an en)ty be? (e.g. lab test± BANK CUSTOMER ACCOUNT En))es Customer: Customers can have more than one account Account: Accounts can be owned by 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)Fed. We have informa-on about: Customers Accounts Branch Is anything missing? Missing Informa)on Rela)ons: 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 that holds account, customer pairs
Background image of page 2
11/15/12 3
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

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

{[ snackBarMessage ]}

Page1 / 6

Wk12_SQL_4ppB - Mul)pleTables...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online