- Buatlah database perpustakaan
- buatlah table pengarang,berikut struktur tablenya :
|
Field Name
|
Data Type
|
Field Size
|
Keterangan
|
|
ID_PENGARANG
|
Type
|
1
|
Primary key
|
|
PENGARANG
|
Type
|
15
|
|
|
TGL_LAHIR
|
Date/Time
|
|
|
|
KOTA
|
Text
|
15
|
|
|
PHOTO
|
OLE Object
|
|
|
3. entry/isikan data seperti berikut :
Buatlah : Table Buku
|
ID_BUKU
|
JUDUL
|
ID_PENGARANG
|
ID_PENERBIT
|
JML_BELI
|
HARGA
|
|
(Autonumber)
[Long Integer]
|
(Text)
[20]
|
[Text]
[2]
|
[Text]
[1]
|
(Number)
[Byte]
|
(Number)
[Long Integer]
|
|
1
|
Windows XP
|
01
|
B
|
13
|
6000
|
|
2
|
Visual Basic 7.0
|
02
|
A
|
5
|
100000
|
|
3
|
Linux
|
03
|
C
|
32
|
50000
|
|
4
|
Word 2002
|
04
|
B
|
15
|
65000
|
|
5
|
Delphi 6.0
|
05
|
A
|
4
|
130000
|
|
6
|
Access 2002
|
06
|
C
|
25
|
125000
|
Tidak ada komentar :
Posting Komentar