Database Design 3rd normal form question
I have a database with many tables, 4 of which are these
Payment
Credit Card
Paypal
Bitcoin
Credit Card attributes:
cardID (PK)
type
number
expireDate
...
PayPal attributes:
paypalID (PK)
account
...
Bitcoin attributes:
bitcoinID (PK)
...
Payment Table attributes:
amount
...
...
cardID (FK)
paypalID (FK)
bitcoinID (FK)
A payment can only be paid by either a card/paypal/bitcoin so I am breaking 3rd normal form because if the client uses a card then I know that he didnt use paypal or bitcoin. How can I fix this so that I am not breaking 3rd normal Form.
Subject
Written By
Posted
Database Design 3rd normal form question
April 22, 2015 07:19PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.