Praktikum database

1. Create Table tb_pengguna : Field : Userid, Nama, Email, No_telp

2. Added Unique Into Table Field : Email

3.  Added Index Into Table field : nama, no_telp

4. Edit Field Data Type

5. Insert Data Into Table tb_pengguna

6. Create Table tb_team field : id_team, nama_team, id_koordinator

7. Create Table tb_koordinator field : 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 Alphabetically

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 26

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

39. Upload All Tables and View Created To Server Script Export Database >> Mysqldump -u<username -p<password> Database_name > Database_name.sql