Praktikum Database

Database adalah kumpulan data yang terorganisir secara sistematis dan dapat diakses, dimanipulasi, dan dikelola oleh suatu program komputer. Database biasanya terdiri dari satu atau beberapa tabel yang saling terkait, di mana setiap tabel memiliki kolom-kolom yang merepresentasikan atribut data dan baris-baris yang merepresentasikan entitas atau objek data. Database dapat digunakan untuk menyimpan berbagai jenis data, seperti data pelanggan, data produk, data transaksi, dan sebagainya.

Di bawah ini beberapa contoh penggunaan database: 

Create Database

Create Table tb_pengguna

Added Unique Into Table

Added Index Into Table 

Edit Field Data Type

Insert Data Into Table tb_pengguna 

Create Table tb_team

Create Table tb_koordinator

Add Constraint FOREIGN KEY

Insert Into Table tb_team And tb_koordinator

Get Data For Each Table Created for all fields

Get Data For Each Table Created for some fields

Get Data From Tables Created Using Filter

Get Data From Table tb_team And tb_koordinator Using Inner Join

Get Data From Table tb_team And tb_koordinator Using Left Join

Get Data From Table tb_team And tb_koordinator Using Right Join

Rename Tb_pengguna To Tb_anggota

Add Column Team On Tb_anggota

Add Relation Between Tb_anggota And Tb_team

Truncate All Tables

Insert Data Into Table tb_koordinator

Insert Data Into Table tb_team

Insert Data Into Table tb_anggota

Get Data From All Tables With Null Data From Table Tb_koordinator

Get Data From All Tables Without Null Data From Table Tb_koordinator

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

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

Get Data From All Tables Sort By Fullname From Tb_anggota Alphabetically

Count The Number Of Members Based On The Team

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

Create View From Data On Point 26

Create Temporary Table From Data On Point 26

Truncate Table Temporary

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

Add Column Captain Using Data Type Boolean

Update Data tb_anggota For Rach Team Have 1 Captain

Add Column jenis_kelamin Using Data Type Enum

Update Data tb_anggota For Column jenis_kelamin

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