suppose i have to create 2 tables one for Projects and other for developer.
in project table having (4 fields)
1)pid primarykey
2)pname
3)date
4)time
in devloper table having (4 fields)
1)did primary key
2)dname
3)pid forginkey
4)time
primary key can accept duplicate rows. yes
one project contains number of devloprs ok.
and also one devloper contains more then on project. ok
but one develoer can handle maltiple projects how can add in developer table for my requirement.