All Questions
1 question
4
votes
1
answer
20k
views
When deciding a Primary Key, can I use Date part of a DateTime field
I'm designing a payroll system I have designed a database with several tables and this question is related to following tables
EMPLOYEE (Employee_ID [pk], Name,... etc)
LOCATION (Location_ID [pk], ...