These are the kinds of questions that separate developers who have built systems from developers who have only followed tutorials. I’ve recently compiled many practical .NET, Angular, SQL, System ...

Real apps use multiple tables. A project belongs to a client. Foreign keys link these tables. This keeps your data clean. The database stops you from adding a project to a client who does not exist.