Member Avatar for 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

Edited by Nick Evan because: Tried to format it with CODE tags.
  • 2 Contributors
  • 1 Reply
  • 109 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by smantscheff
Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.