Hi everyone. First of all, yes this is a homework question. I've tried working it out myself but alas here I am.
Anyway. here goes.
I have these 3 entities. Passenger, Company, Payment
----------
Passenger
----------
CustomerNum(PK)
DOB(PK)
First_Name
Last_Name
Gender
Street
Zip
---------
Company
---------
CompanyNum(PK)
Name
Street
Zip
---------
Payment
---------
TransactionNum(PK)
Date(PK)
Amount
Method
Basically a passenger makes a payment. Also a company makes a payment.
But a payment can only be made by either a passenger or a company not both. How can i form that sort of relation? Is it possible?