2221 Isys6698035 Tfba TK2-W4-S5-R0 Team3 [PDF]

Citation preview

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