if i want database to be in 3nf if i add round field (which round total amount) or not.
nazihosseinioun
0
Newbie Poster
billnan
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.
if i want database to be in 3nf if i add round field (which round total amount) or not.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.