Question: 1 2 3 4 5 IH Finish attempt ... Create new table (relation) definitions (without data) by using the following normalization rules: 1- 1NF (Write

1 2 3 4 5 IH Finish attempt ... Create new table (relation) definitions (without data) by using the following normalization rules: 1- 1NF (Write only the names of tables and their related attributes) 2-2NF (Write only the names of tables and their related attributes) 3- 3NF (Write only the names of tables and their related attributes) EMPLOYEE DEPENDENT SOCIAL LAST DEPENDENT DEPENDENTDEPENDENTDATE OF ID FIRSTNAMEDEPARTMENT DATE OF SECURITY INAME NAME GENDER ID BIRTH BIRTH NUMBER 100 Ylmaz Ahmet Sales Ali 1.01.2005M 1231.01.1980 123456 Veli 1.01.2007M 2342.01.1980 123457 101 Kaya Mehmet Production Aye 1.01.2005F 3453.01.1980 123458 Fatma 1.01.2007 F 4564.01.1980 123459 Ouz 1.01.2005M 5675.01.1980 123460 102 Aslan Haluk Production mer 6786.01.1980 123461 1.01.2007M Sales Hurit 1.01.2005M 123462 7897.01.1980 103Kaplan Hamdi 9018.01.1980 104 Kurt 123463 Necati mer 1.01.2007M MIS
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
