Member Avatar for nazihosseinioun

If I want my database to be in 3nf,if i add a field which is the sum of 20 fields or not.

  • 2 Contributors
  • 2 Replies
  • 63 Views
  • 2 Weeks Discussion Span
  • Latest Post Latest Post by nazihosseinioun
Member Avatar for billnan

Same comment here - sum the fields when you retrieve the data, but don't store the sum in the table.

If I want my database to be in 3nf,if i add a field which is the sum of 20 fields or not.

Member Avatar for nazihosseinioun

Same comment here - sum the fields when you retrieve the data, but don't store the sum in the table.

many thanks for your response.
nazi

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.