It is currently Fri May 18, 2012 3:52 pm

Database design Puzzles

Post a new topic Post a reply

Page 1 of 1 [ 1 post ]

Print view

Previous topic | Next topic

Author

Message

msafwat

Post subject: Database design Puzzles

Posted: Wed Aug 13, 2008 12:01 pm

Site Admin

Joined: Sat Aug 02, 2008 8:00 am
Posts: 147

hey everybody

I have the following puzzle

I want to make a DB design so that I can retrieve the employee name and all of his reporting chain names in one query knowing that all managers are employees
the query should be optimized as much as possible.

how can such thing be done ?

_________________

Muhammad Safwat Fuad
The Java Code Admin
Java Technical Lead.
Mobile: +2010-2942-538
Email:mtv134@yahoo.com

Top

Post a new topic Post a reply

Page 1 of 1 [ 1 post ]

Who is online

Registered users: Acoutle, Elungartlinia

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to: