Please support our Computer Science and Software Design advertiser: Programming Forums
Views: 1137 | Replies: 1
 |
•
•
Join Date: Aug 2006
Posts: 7
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
if i want database to be in 3nf if i add round field (which round total amount) or not.
•
•
Join Date: Sep 2006
Location: Nanaimo BC Canada
Posts: 3
Reputation:
Rep Power: 0
Solved Threads: 0
Newbie Poster
There's no reason to add a field to round the total amount - you don't really want to store it in the table. What you need to do is to round the amount in the query you use to retrieve the data. That way you get the rounded value you want, and the table remains in third normal form.
•
•
•
•
Originally Posted by nazihosseinioun 
if i want database to be in 3nf if i add round field (which round total amount) or not.
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
