I have normalized my table from 0NF to 2NF (hopefully correct).

normalization process

How do I now go from 2NF to 3NF?

Also, ResponseToTransactionId is a recursive foreign key that will contain NULL values a lot of the time. Is this bad design?

  • I'd put Transaction Method in its own table.
    – John K. N.
    Feb 11 '20 at 15:34
  • @Johnakahot2use why? to avoid typos?
    – user644361
    Feb 11 '20 at 18:03

If ResponseToTransactionId is always NULL for items marked 'REQUEST', and contains the 'REQUEST' items ID where the status is 'ALLOW' then It means that from an application point of view you should always be able to locate which records are linked by this field.

And if NULL then you know there is no link.

It is a bit unusual to do it this way, but it should be fine

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.