Tables:
Account
id(pk) client_id(foreignkey to Client) balance created_date enabled
Client
id(pk) name gender birthday
TradeRecord
id(pk) account_id(foreignkey to Account) sales_man(foreignkey to Employee) amount date
Employee
id(pk) employee_id name gender joined_date
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment