Member Avatar for Nader_ly

Hi there, and thanks first of all for hitting the link

i am a beginner in the database world, and found my self required to draw a conceptual model and an Entity Relational Diagram for a Leave Of Absence system. where the system has the following schema:

1-employee request LOA from his manager,
2- loa must approved (accept or reject)first by the manager where the emp is belong to.
3- HR officer approve the approved (accept or reject) loa request after checking if emp has enough day balance.

any help will be very appreciated !

Nader

  • 2 Contributors
  • 1 Reply
  • 142 Views
  • 1 Month Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

you can start with the following basic tables.

emp(emp_id,name,mgr,dept_no,doj,oth1,oth2,...,flag1,flag2,....);

loa(l_id,emp_id,approver_id,hr_id,apply_date,approval_date,hr_approval_date,approval_flag,hr_approval_flag);

leave(emp_id,leave_count,leave_type,leave_exp_date);

You need to link LOA and LEAVE to EMP on EMP_ID .

Edited by debasisdas because: n/a
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.