Normalization%20ex%20IST459

Normalization%20ex%20IST459 - 12/05/11 IST459...

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

View Full Document Right Arrow Icon

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

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

Unformatted text preview: 12/05/11 IST459 mafudge@syr.edu 1NF: An Example SalesID PhoneNum BaseSalary Product1 Price1 Comm1 QtySold1 Product2 Price2 Comm2 QtySold2 Product3 Price3 Comm3 QtySold3 Smith 555-1234 $5,000 Software 100 $ 7% 35Hardware 2,000 $ 3% 6Accessories 15 $ 10% 86 Doe 555-3405 $7,500 Software 100 $ 7% 32Hardware 2,000 $ 3% 8Accessories 15 $ 10% 70 Jones 555-9876 $6,000 Software 100 $ 7% 42Hardware 2,000 $ 3% 4Accessories 15 $ 10% 66 Salesperson 12/05/11 IST459 mafudge@syr.edu 1NF: An Example SalesID PhoneNum BaseSalary Product1 Price1 Comm1 QtySold1 Product2 Price2 Comm2 QtySold2 Product3 Price3 Comm3 QtySold3 Smith 555-1234 $5,000 Software 100 $ 7% 35Hardware 2,000 $ 3% 6Accessories 15 $ 10% 86 Doe 555-3405 $7,500 Software 100 $ 7% 32Hardware 2,000 $ 3% 8Accessories 15 $ 10% 70 Jones 555-9876 $6,000 Software 100 $ 7% 42Hardware 2,000 $ 3% 4Accessories 15 $ 10% 66 Salesperson 1NF SalesID PhoneNum BaseSalary Smith 555-1234 $5,000 Doe 555-3405 $7,500 Jones 555-9876 $6,000 Salesperson 1:M SalesID...
View Full Document

Page1 / 4

Normalization%20ex%20IST459 - 12/05/11 IST459...

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

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