Jawaban Uas Sbd Ganjil 2015

Oleh Era Sitanggang

47,6 KB 5 tayangan 0 unduhan
 


Bagikan artikel

Transkrip Jawaban Uas Sbd Ganjil 2015

Tabel Universal Project_ID Proj01 Proj02 1st NF Project_ID Proj01 Proj01 Proj01 Proj02 Project_Name Buffalo Elephant Payment_Number P03 P06 P10 P13 Affective_Date January 2016 January 2016 January 2016 January 2016 Employee_ID Emp01 Emp02 Emp03 Emp04 Project_Name Buffalo Buffalo Buffalo Elephant Payment_Number P03 P06 P10 P13 Affective_Date January 2016 January 2016 January 2016 January 2016 Employee_ID Emp01 Emp02 Emp03 Emp04 2nd NF Functional Dependency Project_ID --> Project_Name Employee_ID --> Employee_Name, Specialization Payment_Number --> Affective_Date, Project_ID, Employee_ID, Working_Hours, Total, Cashier Table Project Project_ID Proj01 Proj02 Project_Name Buffalo Elephant Table Employees Employee_ID Emp01 Emp02 Emp03 Emp04 Employee_Name Heru Subagyo Andi Ardiansyah Bagus Prasetyo Tejo Kumoro Table Payment Payment_Number P03 P06 P10 P13 Affective_Date January 2016 January 2016 January 2016 January 2016 Specialization Database Engineer Programmer Programmer Database Engineer Project_ID Proj01 Proj01 Proj01 Proj02 Employee_ID Emp01 Emp02 Emp03 Emp04 Working_Hours 30 50 40 20 3rd NF Transitive Dependency Specialization -->Charge_Hour Project_ID Proj01 Proj02 Project_Name Buffalo Elephant Table Employees Employee_ID Emp01 Emp02 Emp03 Emp04 Employee_Name Heru Subagyo Andi Ardiansyah Bagus Prasetyo Tejo Kumoro Table Payment Payment_Number P03 P06 P10 P13 Affective_Date January 2016 January 2016 January 2016 January 2016 Table ChargeSpecialization Specialization Charge_Hour Database Engineer IDR 300.000 Programmer IDR 200.000 Specialization Database Engineer Programmer Programmer Database Engineer Project_ID Proj01 Proj01 Proj01 Proj02 Employee_ID Emp01 Emp02 Emp03 Emp04 Working_Hours 30 50 40 20 Employee_Name Heru Subagyo Andi Ardiansyah Bagus Prasetyo Tejo Kumoro Specialization Database Engineer Programmer Programmer Database Engineer Working_Hours 30 IDR 50 IDR 40 IDR 20 IDR Total 9.000.000 10.000.000 8.000.000 6.000.000 Cashier Ciptono Ciptono Ciptono Ciptono Employee_Name Heru Subagyo Andi Ardiansyah Bagus Prasetyo Tejo Kumoro Specialization Database Engineer Programmer Programmer Database Engineer Working_Hours 30 IDR 50 IDR 40 IDR 20 IDR Total 9.000.000 10.000.000 8.000.000 6.000.000 Cashier Ciptono Ciptono Ciptono Ciptono IDR IDR IDR IDR Total 9.000.000 10.000.000 8.000.000 6.000.000 Cashier Ciptono Ciptono Ciptono Ciptono Cashier Ciptono Ciptono Ciptono Ciptono

Judul: Jawaban Uas Sbd Ganjil 2015

Oleh: Era Sitanggang


Ikuti kami