2. Added Unique Into Table

3. Added Index Into Table

4. Edit Field Data Type

5. Insert Data Into Table tb_pengguna

6. Create Table tb_team

7. Create Table tb_koodinator

8. Add Constraint FOREIGN KEY

9. Insert Into Table tb_team And tb_koordinator

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 Tables

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 All Tables 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