Praktikum - Database

Pada artikel kali ini kita akan mencoba memperaktikan materi-materi mengenai databases yang telah kita bahas pada artikel-artikel sebelumnya 

1. Create Table "tb_pengguna" dengan field : userid, nama, email, no_telp

 

2. Added Unique Into Table pada fiedl : email

3. Added Unique Into Table pada fiedl : nama, no_telp

 4. Edit Field Data Type 

5. Insert Data Into Table "tb_pengguna"

6. Create Table "tb_team" dengan fiedl : id_team, nama_team, id_koordinator

7. Create Table "tb_kooordinator" dengan fiedl : id_koordinator, nama

8. Add Constraint FOREIGN KEY untuk table tb_team & tb_koordinator dengan configurasi tambahan : UPDATE CASCADE ON DELETE CASCADE

9. Insert Into Table tb_team And tb_koordinator

10. Get Data For Each Table Created for all fields

11. Get Data For Each Table Created for some fields

12. Get Data From Tables Created Using Filter

13. Get Data From Table tb_team And tb_koordinator Using Inner Join

14. Get Data From Table tb_team And tb_koordinator Using Left Join

15. Get Data From Table tb_team And tb_koordinator Using Right Join

16. Rename Tb_pengguna To Tb_anggota

17. Add Column Team On Tb_anggota 

18. Add Relation Between Tb_anggota And Tb_team 

19. Truncate All Table 

20. Insert Data Into Table tb_koordinator at least 5 data

21. Insert Data Into Table tb_team at least 6 data with 2 data null for column id_koordinator

22. Insert Data Into Table tb_anggota at least 60 data with some of field team from tb_team and some field team with null values

23. Get Data From 3 All Table With Null Data From Table Tb_koordinator

24. Get Data From 3 All Table Without Null Data From Table Tb_koordinator 

25. Get Data only field fullname from tb_koordinator and fullname from tb_anggota without null data 

26. Get Data only field fullname from tb_koordinator and fullname from tb_anggota with null data 

27. Get Data From 3 All Table Sort By Fullname From Tb_anggota Alphabeticall

28. Count The Number Of Members Based On The Team

29. Count The Number Of Members Based On Fullname On Tb_koordinator That Has Members More Than Or Equal To 5. 

30. Create View From Data On Point 26 

31. Create Temporary Table From Data On Point 

32. Truncate Table Temporary 

33. Insert Data Into Table Temporary From View Using Query Insert Data Using Select

34. Add Column Captain Using Data Type Boolean 

35. Update Data tb_anggota For Rach Team Have 1 Captain 

36. Add Column jenis_kelamin Using Data Type Enum

 

37. Update Data tb_anggota For Column jenis_kelamin

38. Get Data From 3 All Table Sort By Fullname From Tb_anggota Alphabetically