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 |
|
Deep123
Starting Member
8 Posts |
 Posted - 2009-05-28 : 08:01:57
|
| how to design a database for the appln. in which i have employees with designation and they have heirachies i.e in department manager,tl and executive how i will design tables for them now executive will be under tl and tl will be under manager and manger will be under ceo. |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-28 : 08:37:04
|
"tl" means Team Leader?Also, can any single Team Leader have more than 1 Manager?
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
Deep123
Starting Member
8 Posts |
Posted - 2009-05-28 : 08:51:07
|
quote:
Originally posted by Peso
"tl" means Team Leader?Also, can any single Team Leader have more than 1 Manager?
E 12°55'05.63"N 56°04'39.26"
yes even that is possible |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-28 : 08:54:38
|
Will there ever be more than four levels of hierarchy?CEO -> Manager -> Team Leader -> Executive
E 12°55'05.63"N 56°04'39.26" |
|
|
|
Deep123
Starting Member
8 Posts |
Posted - 2009-05-29 : 01:27:55
|
| yaa more than four levels are possible but till 6 |
|
|
|
|
|
|
designing a database problem