Results 1 to 2 of 2

Thread: query problem

  1. #1
    Join Date
    Oct 2005
    Posts
    1

    Unanswered: query problem

    Task: DB schema of a system which is currently working as follow.

    Employees:- different levels/types of user in organisation like CEO, administrator, Manager, Supervisiors, workers etc etc

    Departments
    HR, IT, Health, Accounts etc etc

    Each employee is working in multiple roles like user "ABC" is working manager as well as worker. It is also possible that manger of "ERT" dept and "SGY" can assign duty to worker "XYZ"

    1 Please design a DB schema which handles this situation in a most efficient way. Please design most suitable and best way to handle all these activites. and also poplule some data in DB and design SQL queries which gives us following results

    1.1 Show managers who are also reporting to other managers of other departments.

    1.2 Show all employees who have more than 1 managers.

    1.3 Show all employees who don't have any managers.

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Hi Idiot PHP
    what did you do during your lectures / tutorials / school classes? Have you gone back to your teacher / lecturer for any guidance, there's a real good reason for doing this, if you have attended all your classes and are not in a position to even attempt it then either the teaching was poor and they (either the teacher or institution) need to improve it urgently.

    BTW the forums generall don't assist with homework.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •