Jawaban Uas Sbd Ganjil 2015

Oleh Era Sitanggang

15 tayangan
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