Tugas 2
by prouthon.soul on Nov.19, 2008, under SQL SERVER
- Cari jenis-jenis beserta uraian tentang tipe data di SQL Server.
- Buat database di bawah ini :
Nama database : db_pabrik
Table 1 : tb_golongan
|
Field |
Type Data |
|
Id_golongan -> PK |
Int |
|
Nama |
Char (30) |
|
Jenis |
Int |
|
Salary |
Float |
|
Jns_salary |
Int |
|
Tunjangan |
Int |
Table 2 : tb_karyawan
|
Field |
Type Data |
|
Nik -> PK |
Char (30) |
|
Id_golongan -> FK |
Int |
|
Nama |
Char (30) |
|
Alamat |
Char (30) |
|
Tlp |
Char (15) |
|
Status_karyawan |
Int |
Table 3 : tb_gaji
|
Field |
Type Data |
|
Nik -> FK |
Char (30) |
|
Bulan |
Char (15) |
|
Tahun |
Char (4) |
|
Saving |
Int |
Ket : PK = Primary Key
FK = Foreign Key
Tugas ditulis di kertas Folio, untuk pembuatan database beserta tablenya buat melalui Query Analyzer kemudian tulis scriptnya di kertas.
Terakhir pengumpulan pada saat pertemuan berikutnya
Thanks.. keep study J
1 Comment for this entry
Leave a Reply
Ranking
November 29th, 2008 on 9:46 pm
Hi there I like your post “Tugas 2″ so well that I like to ask you whether I should translate into German and linking back. Greetings Engel