Can a table have two foreign keys?

Question

I have the following tables (Primary key in bold. Foreign key in Italic)

Customer table

• ID---Name---Balance---Account_Name---Account_Type

Account Category table

• Account_Type----Balance

Customer Detail table

• Account_Name---First_Name----Last_Name---Address

Can I have two foreign keys in the Customer table and how can I implement this in MySQL?

---

Updated

I am developing a web based accounting system for a final project.

Account Category

Account Type--------------Balance

Assets
Liabilities
Equity
Expenses
Income

Asset

• Asset_ID-----Asset Name----Balance----Account Type

Receivable

• Receivable_ID-----Receivable Name-------Address--------Tel-----Asset_ID----Account Type

Receivable Account

• Transaction_ID----Description----Amount--- Balance----Receivable_ID----Asset_ID---Account Type

I drew the ER(Entity relationship) diagram using a software and when I specify the relationship it automatically added the multiple foreign keys as shown above. Is the design not sound enough?

Answer 1

create table Table1 (   id varchar(2),   name varchar(2),   PRIMARY KEY (id) )   Create table Table1_Addr (   addid varchar(2),   Address varchar(2),   PRIMARY KEY (addid) )  Create table Table1_sal (   salid varchar(2),`enter code here`   addid varchar(2),   id varchar(2),   PRIMARY KEY (salid),   index(addid),   index(id),   FOREIGN KEY (addid) REFERENCES Table1_Addr(addid),   FOREIGN KEY (id) REFERENCES Table1(id) )