Database Desing for organiztion

[netdev11]

hello

i am developing my uni project organiztion management system for hr

organization hirarchy

-organization1 can have its

--org1suborg1

--org1suborg2

---org1suborg2suborg1

-organization1 can have

-suborg1

     department1

        department1 department2

-employee in organization departments

here is database so far

organaization

(orgid,orgname,parentorgid)

 

department

(departid,orgid,departname,parentdepartid)

 

 

employee

(orgid,departid,employeeid,employeename)

i want some one to tell me about his view on this design?is it according to design principles.

thankyou

[smantscheff]

No. If an employee belongs to exactly one department, there must be no reference to the organization in the employee record but only to the department.