Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pradeepshraddha
Starting Member
8 Posts |
 Posted - 2007-01-18 : 11:02:19
|
| Hello, I'm working on Employee database. I have two tables -Employee TableEmpIDFirstNameLastNamePhotURLMgrIdPositionCellNumberWExtensionEmailDeptIDDepartments tableDeptIDNameHeadEmpIdI'm thinking to create one more table "JOB".Right now, existing employee database is not easy to maintain. For example, if top label employee left the company, what will happens to other employees who reports to him? Kind of situation..Please help me out here ..Thanks.. |
|
|
LoztInSpace
Aged Yak Warrior
940 Posts |
Posted - 2007-01-18 : 19:30:57
|
| Happy to help but I can't work out what you are trying to accomplish or what the problem is. |
 |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-01-19 : 06:15:42
|
| Separate out roles from employees - this gives you far more flexibility, and more closely reflects reality. Have a look at Len Silverston's "Universal Data Model Resource Kit" for some very well thought through examples of this kind of modelling [url]http://www.amazon.com/Data-Model-Resource-Book-Vol/dp/0471380237[/url]Mark |
|
|
|
|
|
|
Database design help..