Worksheetsbasis data query
Total questions: 29
Worksheet time: 43mins
Who Are You?
saya akan mengerjakan ujian ini dengan penuh kejujuran. (tanda tangan)
I will take this exam with full honesty. (signature)
SELAMAT PAGI... (Good Morning)
say it loud !!: "PAGI... PAGI.... PAGI...."
Urutkan cara membangun basis data yang baik.
Sort how to build a good database.
Observation
Make a ERD
Make a CDM/PDM
Build Database
Test
Buatlah sebuah skema basis data untuk pengelolaan sistem informasi akademik.
Create database schema for academic information system.
CREATE databases SIAKAD;
CREATE DATABASE SIAKAD;
create databases mahasiswa;
CREATE DATABASES siakad;
Buatlah sebuah skema basis data untuk pengelolaan sistem informasi perpustakaan.
Create database schema for library information system.
CREATE databases LIBRARY;
CREATE DATABASES book;
create databases book;
CREATE DATABASE library;
Buatlah sebuah skema basis data untuk pengelolaan sistem informasi kantin.
Create database schema for canteen information system.
CREATE databases Canteen;
CREATE DATABASES canteen;
create database canteen;
CREATE DATABASES canteen;
Buatlah sebuah skema basis data untuk pengelolaan sistem informasi toko retail.
Create database schema for retail store information system.
CREATE database Store;
CREATE DATABASES store;
create databases store;
CREATE DATABASES store;
Buatlah sebuah skema basis data untuk pengelolaan sistem informasi pergudangan.
Create database schema for warehouse information system.
CREATE database WAREHOUSE;
CREATE DATABASES warehouse;
create databases warehouse;
CREATE DATABASES warehouse;
Buatlah tabel untuk menyimpan data mahasiswa.
Create table for students data.
Create table students (
nim char(10) not null;
nama varchar (50);
primary key(nim)
);
Create table students {
nim char(10) not null,
nama varchar (50),
primary key(nim)
};
Create table students (
nim char(10) not null,
nama varchar (50),
primary key(nim)
);
Create table students (
nim char(10) default 0,
nama varchar (50),
primary key(nim)
);
Buatlah tabel untuk menyimpan data buku.
Create table for book data.
Create table book (
id_book char(10) not null;
name varchar (50);
primary key(id_book)
);
Create table book {
id_book char(10) not null,
name varchar (50),
primary key(id_book)
};
Create table book (
id_book char(10) default 0,
name varchar (50),
primary key(id_book)
);
Create table book (
id_book char(10) not null,
name varchar (50),
primary key(id_book)
);
Buatlah tabel untuk menyimpan data produk.
Create table for product data.
Create table product (
id_product char(10) not null;
name varchar (50);
primary key(id_product)
);
Create table product {
id_product char(10) not null,
name varchar (50),
primary key(id_product)
};
Create table product (
id_product char(10) default 0,
name varchar (50),
primary key(id_product)
);
Create table product (
id_product char(10) not null,
name varchar (50),
primary key(id_product)
);
Ubahlah atribut "nim" menjadi tipe data char.
Change the attribute "nim" to the char data type.
ALTER
TABLE STUDENTS
MODIFY
COLUMN
NIM CHAR(10)
Ubahlah atribut "nama" menjadi tipe data varchar.
Change the attribute "name" to the varchar data type.
ALTER TABLE students MODIFY COLUMN name varchar(200);
ALTER TABLE students CHANGE COLUMN name varchar(200);
ALTER TABLE students CHANGE name varchar(200);
ALTER TABLE students MODIFY name varchar(200);
Hapuslah kolom nama mahasiswa.
Delete column from students name.
ALTER TABLE students DROP COLUMN name;
ALTER TABLE students DROP name;
DROP students name;
DROP TABLE students name;
Hapuslah tabel mahasiswa.
Delete table from students.
ALTER TABLE DROP students;
DROP TABLE students;
DELETE TABLE students;
DELETE students;
Hapuslah tabel produk dari skema toko.
Delete product table fom store schema.
DROP product FROM store;
DROP TABLE product FROM store;
DROP TABLE product;
DELETE TABLE product FROM store;
Hubungkan yang sesuai.
connect the appropriate words
DDL
ALTER
DML
UPDATE
DRL
SELECT
INSERT (a) STUDENTS(NIM) VALUES ('1100555');
WHO ARE WE???
say it loud "POLINEMA..."
INSERT INTO students (a) * FROM MAHASISWA
INSERT INTO STUDENTS(NIM) VALUES ('112200') (a)
UPDATE STUDENTS (a) NIM="001100" WHERE NIM="000000"
UPDATE STUDENTS SET NIM="110011" (a) NAME="DIKA" WHERE NIM="00000"
UPDATE STUDENTS SET NIM="001100" , NAMA="DIKA" WHERE NIM="0000" ......
;
,
:
-
Bersihkan isi data pada tabel students.
Clear the data from students table.
DROP students;
DROP FROM students;
DELETE FROM students;
DELETE students;
Bersihkan isi data pada tabel products.
Clear the data from products table.
DROP FROM products;
DROP products;
DELETE products;
DELETE FROM products;
Bersihkan isi data pada tabel buku.
Clear the data from books table.
DROP FROM books;
DROP books;
DELETE books;
DELETE FROM books;
Bersihkan isi data pada tabel buku dengan judul mengandung "data".
Clear the data from books table with title contain "data".
DELETE FROM books WHERE title="data";
DELETE books WHERE title like "%data%";
DELETE books WHERE title="data";
DELETE FROM books WHERE title like "%data%";
