4 0 928 KB
Tugas Kelompok ke-2 Week 4 Introduction to Data and Information Management
Disusun oleh : ELIZA VORNIA - 2602257916 CHATLEA CINTA PUTRI WIDYANTO – 2602236861 RIDA AMBAR WATI – 2602258175 ARI FIRMANSYAH – 2602240423
Program Studi Sistem Informasi Binus Online Learning UNIVERSITAS BINA NUSANTARA 2022/2023
Introduction to Data and Information Management
1. Normalisasikan ketiga faktor transaksi berikut secara lengkap!
Introduction to Data and Information Management
Jawab :
Introduction to Data and Information Management
Introduction to Data and Information Management
2. Dari hasil normalisasi yang sudah dibuat tambahkan tambahkan akun pada database dengan nama-nama geng hijau berikut ini: Geng Hijau
Akses
Joni
WW
Tedjo
RRUU
Tarjo
WWRRUUDD
Nyoman
WWUU
Ujo
WWRR
W= Write U = Update D = Delete
Jawab:
Nama/Geng Hijau
Akses W
Joni Tedjo
Write, Write -
U
D
R
-
-
-
Update, Update
-
Tarjo
Write, Write
Update, Update
Delete, Delete
Nyoman
Write, Write
Update, Update
-
Ujo
Write, Write
-
-
Read, read Read, read Read, read
Introduction to Data and Information Management
Script untuk menambahkan akun pada database: CREATE USER 'Joni'@'localhost' IDENTIFIED BY 'joni123'; GRANT INSERT ON Tokopedia.* TO 'Joni'@'localhost';
CREATE USER 'Tedjo'@'localhost' IDENTIFIED BY 'Tedjo123'; GRANT SELECT, UPDATE ON Tokopedia.* TO 'Tedjo'@'localhost';
CREATE USER 'Tarjo'@'localhost' IDENTIFIED BY 'Tarjo123'; GRANT INSERT, SELECT, UPDATE, DELETE ON Tokopedia.* TO 'Tarjo'@'localhost';
Introduction to Data and Information Management
CREATE USER 'Nyoman'@'localhost' IDENTIFIED BY 'Nyoman123'; GRANT INSERT, UPDATE ON Tokopedia.* TO 'Nyoman'@'localhost';
CREATE USER 'Ujo'@'localhost' IDENTIFIED BY 'Ujo123'; GRANT INSERT, SELECT ON Tokopedia.* TO 'Ujo'@'localhost';
Introduction to Data and Information Management