Learn Intermediate SQL/

...

/

Managing Computed Attributes

Managing Computed Attributes

Learn how storing derived fields in databases poses integrity and redundancy challenges.

We'll cover the following...

Challenges of storing derived fields

Derived fieldsDerived fields are attributes whose values are calculated from other fields in the database using some formula., such as SalesAmount, are generally not stored in the database because they can always be computed from the base information. Storing such fields in a database can lead to several issues such as ...