Hello, I am working on a database design for a project that I want to attempt. Right now, I am working on just the database. I am getting a little lost on primary and foreign keys. It's been a while since I have done this. Here is my list so far. The database is going to be for a web designer project management application I want to make using C# when I learn enough to make it. any help on this part of the database design would be great.
I am thinking that the tblClients will need to be linked to all other tables. I thought this would be done from primary key to foreign key. Table payments will also need to be linked to tblClients and tblProjects. You get the idea?