I have a doubt About Foreign Key.
There is a table having some feilds including Primary key and now
there is another two tables that also having primary keys.
Here i want to give a foreign key relationship with the two tables to the one column of the main table.
Main table name is "rocket" columns(id (Primary key),rid (Foreign key),name,amount)
remaining tables names "store" ,'department'
'Store' columns(id (P),name,place)
"Department" columns(id (P),name,area)
Here in "rocket" table rid (F) is the foreign key from "store" &"Department" - id's is it possible to give this type as foreign key.