Coding Hours Challenge - TimeOff App DB Modelling

Stepwise Solution.txt

Step 1:    Identifying Entities:

Staff
Admin
Leave


Step 2:    Identifying Attributes and Define Attributes Data types:

Staff: staff_id(int), first_name(string), last_name(string), email(string), organization(string), designation(string), 
        department(string), manager(string), phone(string), dob(date), gender(string), country(string), city(string), state(string)
     
Admin: admin_id(int), first_name(string), last_name(string), email(string),gender(string), designation(string), organization(string),
        phone(string)

leave:  leave_id(int), leave_type(string), 


Step 3:    Identifying Entities Relationships:

staff - leave   (1:M)
Admin - staff   (1:M)

timeOff_schema.png