My first real effort at designing a db is underway. Is it ok to use duplicate field names in different tables or will I run into problems later? Like:
tblCustomer
FirstName
LastName
tblEmployee
FirstName
LastName
Should I use longer field names? Like:
tblCustomer
CustFirstName
CustLastName
tblEmployee
EmpFirstName
EmpLastName
TIA
Steve hope2bDev
tblCustomer
FirstName
LastName
tblEmployee
FirstName
LastName
Should I use longer field names? Like:
tblCustomer
CustFirstName
CustLastName
tblEmployee
EmpFirstName
EmpLastName
TIA
Steve hope2bDev