Loading

Problem in designing table

ila

Hi

        I am doing a project.. In that i need to design table.. I have to consider employee id and account type.. The problem is one employee can have any no of account type.. Now i need to enter same employee name repeatedly for which they belong to.. Is there any other way?

       I dont know how to design table for that..

       Can anybody help me?

With regards,

Ila

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Dipa Ahuja16y ago
Accepted answer
Create three table

1. emloyee(primary key),
2. account_master and(primary key)
3. account_details(foreign key)

empyee table primary key field "EMPID" and in account_Detail contain foreign key "EMPID"

account master has primary key "AccID" and account_Detail contain foreign key "AccID"
Sagar Kumar16y ago
Create Emp,Acc Table.
Create one more table EmpAcc.
which contains EmpId,AccTypeId i think this is the best way.