I am a newbie on creating database... I need to create it for my recruitment web application.
My application needs to schedule screenings, exams and interviews of applicants and save result in the database..
My database schema is as follows:
My problem is I included the
applicant_id on other tables... e.g. exam, interview, exam type.
Am I violating any normalization rule? If I do, what do you recommend to improve my design?