Hello brilliants
I come as a refugee from relationships struggle with DB !! i literally watched hours and hours of videos and read a lot and still can't control it ! so i will say what i need to do !!!
i'm building a complete DB ! however i went through forms , codes , macros and many things i still want to jump back to the starting point and checkout the relationships so....
Database has :
part 1:
Employees : containing ( different titles) (different direct managers ) ( different security pass levels depending on the titles they have )
each Employee has this : >> Title , direct manager , security level (numbers 1~7)
part 2 :
Each Employee has Holiday record !!
holidays main table has the type of holiday and how many days based on , table of requested holidays vs table of accepted holiday
Employee > Holidays > type & days of the holidays acquired
part 3 :
Each employee is doing work on : >>
cases & files
part 4 :
cases and files are handled by junior team then : escalated or not to Senior team
i'm gonna commit suicide after writing that coz probably it's too complicated to think about it
of course Employees has many info , cases files has many info but they are not required to be linked just data
HELP PLEASE !
I come as a refugee from relationships struggle with DB !! i literally watched hours and hours of videos and read a lot and still can't control it ! so i will say what i need to do !!!
i'm building a complete DB ! however i went through forms , codes , macros and many things i still want to jump back to the starting point and checkout the relationships so....
Database has :
part 1:
Employees : containing ( different titles) (different direct managers ) ( different security pass levels depending on the titles they have )
each Employee has this : >> Title , direct manager , security level (numbers 1~7)
part 2 :
Each Employee has Holiday record !!
holidays main table has the type of holiday and how many days based on , table of requested holidays vs table of accepted holiday
Employee > Holidays > type & days of the holidays acquired
part 3 :
Each employee is doing work on : >>
cases & files
part 4 :
cases and files are handled by junior team then : escalated or not to Senior team
i'm gonna commit suicide after writing that coz probably it's too complicated to think about it
of course Employees has many info , cases files has many info but they are not required to be linked just data
HELP PLEASE !