3nf database

•

What is DaniWeb IT Discussion Community?

You're currently browsing the Computer Science and Software Design section within the Software Development category of DaniWeb, a massive community of 397,803 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,502 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our Computer Science and Software Design advertiser:

Thread Tools Display Modes

Views: 1030 | Replies: 1

•

Join Date: Aug 2006

Posts: 7

Reputation: nazihosseinioun is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

nazihosseinioun nazihosseinioun is offline

Offline

Newbie Poster

3nf database

Sep 2nd, 2006

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: billnan is an unknown quantity at this point

Rep Power: 0

Solved Threads: 0

billnan

Offline

Newbie Poster

Re: 3nf database

Sep 14th, 2006

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