RDBMS
I'm trying to build a database for my families business. Im working on the conceptual ERD but I'm struggling with some tables. Was wondering if anyone had input. Fairly new to databases, but I'm having trouble in particular with the employee and day sheet tables.
>>53842870
go away before you regret it.
>>53842870
I think I might change the 'job' table to a 'site' table as its a construction company. Multiple employees will be working on different sites and on any given day that site might have a different combination of workers.
the day sheet table would be used to generate an invoice for the client and to keep track of employee hours for pay slips.
>>53842911
How would I regret it?
>>53842920
Table for client, employee, project, hours.
>>53842870
If you can't design databases, don't. Use an ORM and design incrementally as you implement functionalities in your system, avoid Big Design Up Front
Read http://pld.cs.luc.edu/database/ER.html
What's your backend ORDBMS? Is it Postgres?