Posted by : Nurulaprn Sabtu, 03 Agustus 2019


Buat contoh salah satu jenis integritas data , Integritas Domain yang  berbeda dengan file catatan INTEGRITAS DATA

Create table buku

(idbuku smallint unsigned not null,

tahunTerbit year not null,

Judul varchar (40) not null default ‘Kosong’);

create domain nilai numerik(3,2)

constraint value-test check (value >=0.00)

Leave a Reply

Subscribe to Posts | Subscribe to Comments

- Copyright © Coretan Mahasiswi - Blogger Templates - Powered by Blogger - Designed by Johanes Djogan -