Question
I.m having a hard hard time trying to explain why this table violates first normal form (1NF). Need help please, thanks. AccountNum CustomerID AccountTyp BalanceAmt1
I.m having a hard hard time trying to explain why this table violates first normal form (1NF). Need help please, thanks.
| AccountNum | CustomerID | AccountTyp | BalanceAmt1 | BalanceAmt2 | BalanceAmt3 |
| 34109 | 105 | A | 2352.47 | 5123.31 | |
| 34134 | 113 | A | 15.95 | ||
| 34147 | 422 | A | 18549.22 | 100.00 | 1799.85 |
| 34147 | 422 | B | 15.33 | ||
| 34155 | 451 | A | 3500.00 | 1.50 | 170.44 |
| 34162 | 990 | X | 500000.00 | ||
| 35010 | 802 | X | 1908190.12 | 10.88 | |
| 37891 | 999 | Z | 7.11 |
Is the LastName attribute a good choice to be the primary key for the CUSTOMER entity? Why or why not.
How is the relationship specified between two entities?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Making Databases Work The Pragmatic Wisdom Of Michael Stonebraker
Authors: Michael L. Brodie
1st Edition
1947487167, 978-1947487161
