Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE DATABASE sbdl;
- USE sbdl;
- CREATE TABLE buku (kd_buku VARCHAR (5) PRIMARY KEY,
- judul_buku VARCHAR (50) NOT NULL,
- kd_pengarang VARCHAR (5) NOT NULL,
- kd_terbit VARCHAR (5) NOT NULL,
- Jumlah INT (11) NOT NULL);
- CREATE TABLE pengarang (kd_pengarang VARCHAR(5) PRIMARY KEY,
- pengarang VARCHAR (50) NOT NULL,
- Alamat VARCHAR (100) NOT NULL);
- INSERT INTO buku VALUES
- ('21', 'Kalkulus','10','1',10),
- ('22', 'Metode Numerik', 'Il', '2',20),
- ('23','Sistem Basis Data','12','3',40),
- ('24', 'Pengantar Teknologi Informasi','12','3', 41);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement