Id Pegawai Nama Pegawai Id Proyek
EM01 Syaiful PR01
EM01 Syaiful PR03
EM10 Heni PR01
EM10 Heni PR02
EM05 Anto PR03
Id Pegawai Nama Pegawai
EM01 Syaiful
EM10 Heni
EM05 Anto
Id Proyek Nama Proyek Lokasi
PR01 Website Universitas ABC Jakarta
PR02 Instalasi Jaringan PT Makmur Bogor
PR03 Sistem Informasi Geografis Yogyakarta Yogyakarta
Id Pegawai Id Proyek Waktu (Jam)
EM01 PR01 30
EM01 PR03 30
EM10 PR01 40
EM10 PR02 30
EM05 PR03 40
Emp_ID Name Dept_Name
100 Margaret Simpson Marketing
100 Margaret Simpson Marketing
140 Alan Beeton Accounting
110 Chris Lucero Info Systems
110 Chris Lucero Info Systems
190 Lorenzo Davis Finance
150 Susan Martin Marketing
150 Susan Martin Marketing
Emp_ID Name Dept_Name
100 Margaret Simpson Marketing
140 Alan Beeton Accounting
110 Chris Lucero Info Systems
190 Lorenzo Davis Finance
150 Susan Martin Marketing
Emp_ID Course_Title Date
100 SPSS 6/19/200X
100 Surveys 10/7/200X
140 Tax Acc 12/8/200X
110 SPSS 1/12/200X
110 C++ 4/22/200X
150 SPSS 6/19/200X
150 JAVA 8/12/200X
1NF
Order_ID Order Date Customer_ID
1006 10/24/2006 2
1006 10/24/2006 2
1006 10/24/2006 2
1007 10/25/2006 6
1007 10/25/2006 6
2NF
Order_ID Order Date Ordered_Quantity
1006 10/24/2006 2
1006 10/24/2006 2
1006 10/24/2006 1
1007 10/25/2006 4
1007 10/25/2006 3
Customer_ID Customer_Name Customer_Address
2 Value Furniture Plano, TX
6 Furniture Gallery Boulder, CO
Product_ID Product_Description Product_Finish
7 Dining Table Natural Ash
5 Writer's Desk Cherry
4 Entertainment Center Natural Maple
11 4-Dr Dresser Oak
Nama Proyek Lokasi Waktu (Jam)
Website Universitas ABC Jakarta 30
Sistem Informasi Geografis Yogyakarta Yogyakarta 30
Website Universitas ABC Jakarta 40
Instalasi Jaringan PT Makmur Bogor 30
Sistem Informasi Geografis Yogyakarta Yogyakarta 40
Salary Course_Title Date
48000 SPSS 6/19/200X
48000 Surveys 10/7/200X
52000 Tax Acc 12/8/200X
43000 SPSS 1/12/200X
43000 C++ 4/22/200X
55000
42000 SPSS 6/19/200X
42000 JAVA 8/12/200X
Salary
48000
52000
43000
55000
42000
Customer_Name Customer_Address Product_ID Product_Description
Value Furniture Plano, TX 7 Dining Table
Value Furniture Plano, TX 5 Writer's Desk
Value Furniture Plano, TX 4 Entertainment Center
Furniture Gallery Boulder, CO 11 4-Dr Dresser
Furniture Gallery Boulder, CO 4 Entertainment Center
Product_ID Customer_ID
7 2
5 2
4 2
11 6
3 6
Unit_Price
800.00
325.00
650.00
500.00
Product_Finish Unit_Price Ordered_Quantity
Natural Ash 800.00 2
Cherry 325.00 2
Natural Maple 650.00 1
Oak 500.00 4
Natural Maple 650.00 3