Relational Data Set Mahasiswa Semester 2 Teknik Informatika UIN Maulana Malik Ibrahim Malang Tahun 2022 Mata Kuliah kewarganegaraan Kelas A

Dosen Pengampu : Prof. Dr. Suhartono, M.Kom

Lembaga : Universitas Islam Negeri Maulana Malik Ibrahim Malang

Jurusan : Teknik Informatika

Fakultas : Sains dan Teknologi

library("tidyverse")

## Warning: package 'tidyverse' was built under R version 4.1.3

## -- Attaching packages --------------------------------------- tidyverse 1.3.1 --

## v ggplot2 3.3.5     v purrr   0.3.4
## v tibble  3.1.6     v dplyr   1.0.8
## v tidyr   1.2.0     v stringr 1.4.0
## v readr   2.1.2     v forcats 0.5.1

## Warning: package 'ggplot2' was built under R version 4.1.3

## Warning: package 'tibble' was built under R version 4.1.2

## Warning: package 'tidyr' was built under R version 4.1.3

## Warning: package 'readr' was built under R version 4.1.3

## Warning: package 'purrr' was built under R version 4.1.3

## Warning: package 'dplyr' was built under R version 4.1.3

## Warning: package 'forcats' was built under R version 4.1.3

## -- Conflicts ------------------------------------------ tidyverse_conflicts() --
## x dplyr::filter() masks stats::filter()
## x dplyr::lag()    masks stats::lag()

Tabel Data NIM dan Nama Mahasiswa

Mahasiswa <- data.frame(
  NIM = c(210605110009, 210605110015, 210605110017, 210605110019, 210605110022, 210605110025, 210605110028, 210605110036, 210605110041, 210605110042, 210605110043, 210605110044, 210605110046, 210605110067, 210605110070, 210605110074, 210605110080, 210605110081, 210605110089, 210605110091, 210605110093, 210605110099, 210605110100, 210605110101, 210605110103, 210605110104, 210605110117, 210605110124, 210605110126, 210605110128, 210605110131, 210605110168), "Nama Mahasiswa" = c("Heny Rimadana","Najah Muchsin Sanin","Muizzul Azizah Oktavianing","Fauzil Hidayatullah","Noviansyah Maulana Ramadhan","Daurin Nabilatul Munna","Moh Tazkia Ikhsanul Ma arif","Hamzah Faizal Asyhari","Rizqy Alfajri","Hajratul Aswad","Arvin Azaria Munsyi","Fitria Susanti","Farid Ahmad Saaduddin","Muhammad Haris Fahrul Rozzy","Muhammad Addi Rizza Rahman","Nurhisam Ari Kusnaini","Aji Prabowo Pamungkas","Dinindriya Izzatinisa","Aliffikri Hadini","Dika Afladhia Napiri","Ilham Romadhon Ali Umri","Muhammad Haikal Akbar At Taufieqy","Arneizha Biktarinanda","Maulana Hilmi Arkan","Amalia Amriadi","Moch. Hasbi Ashidqy","Shasy Kirana","Sayyidah Meutia Zahra","Muhammad Haqqul Hakim","Furkon Aziz Aini","Moh.Dawud","Ibni Akbar Habibi"), stringsAsFactors = FALSE)
Mahasiswa

##             NIM                    Nama.Mahasiswa
## 1  210605110009                     Heny Rimadana
## 2  210605110015               Najah Muchsin Sanin
## 3  210605110017        Muizzul Azizah Oktavianing
## 4  210605110019               Fauzil Hidayatullah
## 5  210605110022       Noviansyah Maulana Ramadhan
## 6  210605110025            Daurin Nabilatul Munna
## 7  210605110028       Moh Tazkia Ikhsanul Ma arif
## 8  210605110036             Hamzah Faizal Asyhari
## 9  210605110041                     Rizqy Alfajri
## 10 210605110042                    Hajratul Aswad
## 11 210605110043               Arvin Azaria Munsyi
## 12 210605110044                    Fitria Susanti
## 13 210605110046             Farid Ahmad Saaduddin
## 14 210605110067       Muhammad Haris Fahrul Rozzy
## 15 210605110070        Muhammad Addi Rizza Rahman
## 16 210605110074             Nurhisam Ari Kusnaini
## 17 210605110080             Aji Prabowo Pamungkas
## 18 210605110081             Dinindriya Izzatinisa
## 19 210605110089                  Aliffikri Hadini
## 20 210605110091              Dika Afladhia Napiri
## 21 210605110093           Ilham Romadhon Ali Umri
## 22 210605110099 Muhammad Haikal Akbar At Taufieqy
## 23 210605110100             Arneizha Biktarinanda
## 24 210605110101               Maulana Hilmi Arkan
## 25 210605110103                    Amalia Amriadi
## 26 210605110104               Moch. Hasbi Ashidqy
## 27 210605110117                      Shasy Kirana
## 28 210605110124             Sayyidah Meutia Zahra
## 29 210605110126             Muhammad Haqqul Hakim
## 30 210605110128                  Furkon Aziz Aini
## 31 210605110131                         Moh.Dawud
## 32 210605110168                 Ibni Akbar Habibi

Tabel Data Gender

gender <- data.frame(
  NIM = c(210605110009, 210605110015, 210605110017, 210605110019, 210605110022, 210605110025, 210605110028, 210605110036, 210605110041, 210605110042, 210605110043, 210605110044, 210605110046, 210605110067, 210605110070, 210605110074, 210605110080, 210605110081, 210605110089, 210605110091, 210605110093, 210605110099, 210605110100, 210605110101, 210605110103, 210605110104, 210605110117, 210605110124, 210605110126, 210605110128, 210605110131, 210605110168),gender = c("Putri","Putri","Putri","Putra","Putra","Putri","Putra","Putra","Putra","Putri","Putra","Putri","Putra","Putra","Putra","Putra","Putra","Putri","Putra","Putra","Putra","Putra","Putri","Putra","Putri","Putra","Putri","Putri","Putra","Putra","Putra","Putra"), stringsAsFactors = FALSE)
gender

##             NIM gender
## 1  210605110009  Putri
## 2  210605110015  Putri
## 3  210605110017  Putri
## 4  210605110019  Putra
## 5  210605110022  Putra
## 6  210605110025  Putri
## 7  210605110028  Putra
## 8  210605110036  Putra
## 9  210605110041  Putra
## 10 210605110042  Putri
## 11 210605110043  Putra
## 12 210605110044  Putri
## 13 210605110046  Putra
## 14 210605110067  Putra
## 15 210605110070  Putra
## 16 210605110074  Putra
## 17 210605110080  Putra
## 18 210605110081  Putri
## 19 210605110089  Putra
## 20 210605110091  Putra
## 21 210605110093  Putra
## 22 210605110099  Putra
## 23 210605110100  Putri
## 24 210605110101  Putra
## 25 210605110103  Putri
## 26 210605110104  Putra
## 27 210605110117  Putri
## 28 210605110124  Putri
## 29 210605110126  Putra
## 30 210605110128  Putra
## 31 210605110131  Putra
## 32 210605110168  Putra

library(dplyr)
mahasiswagenap1 <- merge( x = Mahasiswa,y=gender,by='NIM',all = TRUE)
mahasiswagenap1

##             NIM                    Nama.Mahasiswa gender
## 1  210605110009                     Heny Rimadana  Putri
## 2  210605110015               Najah Muchsin Sanin  Putri
## 3  210605110017        Muizzul Azizah Oktavianing  Putri
## 4  210605110019               Fauzil Hidayatullah  Putra
## 5  210605110022       Noviansyah Maulana Ramadhan  Putra
## 6  210605110025            Daurin Nabilatul Munna  Putri
## 7  210605110028       Moh Tazkia Ikhsanul Ma arif  Putra
## 8  210605110036             Hamzah Faizal Asyhari  Putra
## 9  210605110041                     Rizqy Alfajri  Putra
## 10 210605110042                    Hajratul Aswad  Putri
## 11 210605110043               Arvin Azaria Munsyi  Putra
## 12 210605110044                    Fitria Susanti  Putri
## 13 210605110046             Farid Ahmad Saaduddin  Putra
## 14 210605110067       Muhammad Haris Fahrul Rozzy  Putra
## 15 210605110070        Muhammad Addi Rizza Rahman  Putra
## 16 210605110074             Nurhisam Ari Kusnaini  Putra
## 17 210605110080             Aji Prabowo Pamungkas  Putra
## 18 210605110081             Dinindriya Izzatinisa  Putri
## 19 210605110089                  Aliffikri Hadini  Putra
## 20 210605110091              Dika Afladhia Napiri  Putra
## 21 210605110093           Ilham Romadhon Ali Umri  Putra
## 22 210605110099 Muhammad Haikal Akbar At Taufieqy  Putra
## 23 210605110100             Arneizha Biktarinanda  Putri
## 24 210605110101               Maulana Hilmi Arkan  Putra
## 25 210605110103                    Amalia Amriadi  Putri
## 26 210605110104               Moch. Hasbi Ashidqy  Putra
## 27 210605110117                      Shasy Kirana  Putri
## 28 210605110124             Sayyidah Meutia Zahra  Putri
## 29 210605110126             Muhammad Haqqul Hakim  Putra
## 30 210605110128                  Furkon Aziz Aini  Putra
## 31 210605110131                         Moh.Dawud  Putra
## 32 210605110168                 Ibni Akbar Habibi  Putra

tempat <- data.frame(NIM = c(210605110009, 210605110015, 210605110017, 210605110019, 210605110022, 210605110025, 210605110028, 210605110036, 210605110041, 210605110042, 210605110043, 210605110044, 210605110046, 210605110067, 210605110070, 210605110074, 210605110080, 210605110081, 210605110089, 210605110091, 210605110093, 210605110099, 210605110100, 210605110101, 210605110103, 210605110104, 210605110117, 210605110124, 210605110126, 210605110128, 210605110131, 210605110168),tempat = c("Kalimantan selatan","Mekkah","Probolinggo","Lombok","Bekasi","Kediri","Kediri","Malang","Riau","NTB","Sampang","Bangkalan","Lamongan","Malang","Blitar","Sidoarjo","Sidoarjo","Malang","Kendari","Riau","Pamekasan","Jakarta","Pacitan","Blora","NTB","Probolinggo","Pasuruan","Tanggerang","Pasuruan","Banyuwangi","Sidoarjo","Bogor"),stringsAsFactors = FALSE)
tempat

##             NIM             tempat
## 1  210605110009 Kalimantan selatan
## 2  210605110015             Mekkah
## 3  210605110017        Probolinggo
## 4  210605110019             Lombok
## 5  210605110022             Bekasi
## 6  210605110025             Kediri
## 7  210605110028             Kediri
## 8  210605110036             Malang
## 9  210605110041               Riau
## 10 210605110042                NTB
## 11 210605110043            Sampang
## 12 210605110044          Bangkalan
## 13 210605110046           Lamongan
## 14 210605110067             Malang
## 15 210605110070             Blitar
## 16 210605110074           Sidoarjo
## 17 210605110080           Sidoarjo
## 18 210605110081             Malang
## 19 210605110089            Kendari
## 20 210605110091               Riau
## 21 210605110093          Pamekasan
## 22 210605110099            Jakarta
## 23 210605110100            Pacitan
## 24 210605110101              Blora
## 25 210605110103                NTB
## 26 210605110104        Probolinggo
## 27 210605110117           Pasuruan
## 28 210605110124         Tanggerang
## 29 210605110126           Pasuruan
## 30 210605110128         Banyuwangi
## 31 210605110131           Sidoarjo
## 32 210605110168              Bogor

library(dplyr)
mahasiswagenap2 <- merge(
  x = mahasiswagenap1,
  y = tempat,by='NIM',
  all = TRUE
  )
mahasiswagenap2

##             NIM                    Nama.Mahasiswa gender             tempat
## 1  210605110009                     Heny Rimadana  Putri Kalimantan selatan
## 2  210605110015               Najah Muchsin Sanin  Putri             Mekkah
## 3  210605110017        Muizzul Azizah Oktavianing  Putri        Probolinggo
## 4  210605110019               Fauzil Hidayatullah  Putra             Lombok
## 5  210605110022       Noviansyah Maulana Ramadhan  Putra             Bekasi
## 6  210605110025            Daurin Nabilatul Munna  Putri             Kediri
## 7  210605110028       Moh Tazkia Ikhsanul Ma arif  Putra             Kediri
## 8  210605110036             Hamzah Faizal Asyhari  Putra             Malang
## 9  210605110041                     Rizqy Alfajri  Putra               Riau
## 10 210605110042                    Hajratul Aswad  Putri                NTB
## 11 210605110043               Arvin Azaria Munsyi  Putra            Sampang
## 12 210605110044                    Fitria Susanti  Putri          Bangkalan
## 13 210605110046             Farid Ahmad Saaduddin  Putra           Lamongan
## 14 210605110067       Muhammad Haris Fahrul Rozzy  Putra             Malang
## 15 210605110070        Muhammad Addi Rizza Rahman  Putra             Blitar
## 16 210605110074             Nurhisam Ari Kusnaini  Putra           Sidoarjo
## 17 210605110080             Aji Prabowo Pamungkas  Putra           Sidoarjo
## 18 210605110081             Dinindriya Izzatinisa  Putri             Malang
## 19 210605110089                  Aliffikri Hadini  Putra            Kendari
## 20 210605110091              Dika Afladhia Napiri  Putra               Riau
## 21 210605110093           Ilham Romadhon Ali Umri  Putra          Pamekasan
## 22 210605110099 Muhammad Haikal Akbar At Taufieqy  Putra            Jakarta
## 23 210605110100             Arneizha Biktarinanda  Putri            Pacitan
## 24 210605110101               Maulana Hilmi Arkan  Putra              Blora
## 25 210605110103                    Amalia Amriadi  Putri                NTB
## 26 210605110104               Moch. Hasbi Ashidqy  Putra        Probolinggo
## 27 210605110117                      Shasy Kirana  Putri           Pasuruan
## 28 210605110124             Sayyidah Meutia Zahra  Putri         Tanggerang
## 29 210605110126             Muhammad Haqqul Hakim  Putra           Pasuruan
## 30 210605110128                  Furkon Aziz Aini  Putra         Banyuwangi
## 31 210605110131                         Moh.Dawud  Putra           Sidoarjo
## 32 210605110168                 Ibni Akbar Habibi  Putra              Bogor

Tabel Data Jumlah Kelompok

jumlah <- data.frame(NIM = c(210605110009, 210605110015, 210605110017, 210605110019, 210605110022, 210605110025, 210605110028, 210605110036, 210605110041, 210605110042, 210605110043, 210605110044, 210605110046, 210605110067, 210605110070, 210605110074, 210605110080, 210605110081, 210605110089, 210605110091, 210605110093, 210605110099, 210605110100, 210605110101, 210605110103, 210605110104, 210605110117, 210605110124, 210605110126, 210605110128, 210605110131, 210605110168), 'jumlah kelompok' = c(7,10,14,19,5,9,17,13,4,11,8,16,18,3,20,25,14,19,6,9,7,10,14,19,5,9,17,13,4,11,8,16),stringsAsFactors = FALSE)
jumlah

##             NIM jumlah.kelompok
## 1  210605110009               7
## 2  210605110015              10
## 3  210605110017              14
## 4  210605110019              19
## 5  210605110022               5
## 6  210605110025               9
## 7  210605110028              17
## 8  210605110036              13
## 9  210605110041               4
## 10 210605110042              11
## 11 210605110043               8
## 12 210605110044              16
## 13 210605110046              18
## 14 210605110067               3
## 15 210605110070              20
## 16 210605110074              25
## 17 210605110080              14
## 18 210605110081              19
## 19 210605110089               6
## 20 210605110091               9
## 21 210605110093               7
## 22 210605110099              10
## 23 210605110100              14
## 24 210605110101              19
## 25 210605110103               5
## 26 210605110104               9
## 27 210605110117              17
## 28 210605110124              13
## 29 210605110126               4
## 30 210605110128              11
## 31 210605110131               8
## 32 210605110168              16

library(dplyr)
mahasiswagenap3 <- merge(x = mahasiswagenap2,y=jumlah,by='NIM',all = TRUE)
mahasiswagenap3

##             NIM                    Nama.Mahasiswa gender             tempat
## 1  210605110009                     Heny Rimadana  Putri Kalimantan selatan
## 2  210605110015               Najah Muchsin Sanin  Putri             Mekkah
## 3  210605110017        Muizzul Azizah Oktavianing  Putri        Probolinggo
## 4  210605110019               Fauzil Hidayatullah  Putra             Lombok
## 5  210605110022       Noviansyah Maulana Ramadhan  Putra             Bekasi
## 6  210605110025            Daurin Nabilatul Munna  Putri             Kediri
## 7  210605110028       Moh Tazkia Ikhsanul Ma arif  Putra             Kediri
## 8  210605110036             Hamzah Faizal Asyhari  Putra             Malang
## 9  210605110041                     Rizqy Alfajri  Putra               Riau
## 10 210605110042                    Hajratul Aswad  Putri                NTB
## 11 210605110043               Arvin Azaria Munsyi  Putra            Sampang
## 12 210605110044                    Fitria Susanti  Putri          Bangkalan
## 13 210605110046             Farid Ahmad Saaduddin  Putra           Lamongan
## 14 210605110067       Muhammad Haris Fahrul Rozzy  Putra             Malang
## 15 210605110070        Muhammad Addi Rizza Rahman  Putra             Blitar
## 16 210605110074             Nurhisam Ari Kusnaini  Putra           Sidoarjo
## 17 210605110080             Aji Prabowo Pamungkas  Putra           Sidoarjo
## 18 210605110081             Dinindriya Izzatinisa  Putri             Malang
## 19 210605110089                  Aliffikri Hadini  Putra            Kendari
## 20 210605110091              Dika Afladhia Napiri  Putra               Riau
## 21 210605110093           Ilham Romadhon Ali Umri  Putra          Pamekasan
## 22 210605110099 Muhammad Haikal Akbar At Taufieqy  Putra            Jakarta
## 23 210605110100             Arneizha Biktarinanda  Putri            Pacitan
## 24 210605110101               Maulana Hilmi Arkan  Putra              Blora
## 25 210605110103                    Amalia Amriadi  Putri                NTB
## 26 210605110104               Moch. Hasbi Ashidqy  Putra        Probolinggo
## 27 210605110117                      Shasy Kirana  Putri           Pasuruan
## 28 210605110124             Sayyidah Meutia Zahra  Putri         Tanggerang
## 29 210605110126             Muhammad Haqqul Hakim  Putra           Pasuruan
## 30 210605110128                  Furkon Aziz Aini  Putra         Banyuwangi
## 31 210605110131                         Moh.Dawud  Putra           Sidoarjo
## 32 210605110168                 Ibni Akbar Habibi  Putra              Bogor
##    jumlah.kelompok
## 1                7
## 2               10
## 3               14
## 4               19
## 5                5
## 6                9
## 7               17
## 8               13
## 9                4
## 10              11
## 11               8
## 12              16
## 13              18
## 14               3
## 15              20
## 16              25
## 17              14
## 18              19
## 19               6
## 20               9
## 21               7
## 22              10
## 23              14
## 24              19
## 25               5
## 26               9
## 27              17
## 28              13
## 29               4
## 30              11
## 31               8
## 32              16

Data Set dengan Catatan: Key “NIM” dan Value “Gender”

Gender <- data.frame(NIM = c(210605110009, 210605110015, 210605110017, 210605110019, 210605110022, 210605110025, 210605110028, 210605110036, 210605110041, 210605110042, 210605110043, 210605110044, 210605110046, 210605110067, 210605110070, 210605110074, 210605110080, 210605110081, 210605110089, 210605110091, 210605110093, 210605110099, 210605110100, 210605110101, 210605110103, 210605110104, 210605110117, 210605110124, 210605110126, 210605110128, 210605110131, 210605110168), gender = c("Putri","Putri","Putri","Putra","Putra","Putri","Putra","Putra","Putra","Putri","Putra","Putri","Putra","Putra","Putra","Putra","Putra","Putri","Putra","Putra","Putra","Putra","Putri","Putra","Putri","Putra","Putri","Putri","Putra","Putra","Putra","Putra"),stringsAsFactors = FALSE)
Gender

##             NIM gender
## 1  210605110009  Putri
## 2  210605110015  Putri
## 3  210605110017  Putri
## 4  210605110019  Putra
## 5  210605110022  Putra
## 6  210605110025  Putri
## 7  210605110028  Putra
## 8  210605110036  Putra
## 9  210605110041  Putra
## 10 210605110042  Putri
## 11 210605110043  Putra
## 12 210605110044  Putri
## 13 210605110046  Putra
## 14 210605110067  Putra
## 15 210605110070  Putra
## 16 210605110074  Putra
## 17 210605110080  Putra
## 18 210605110081  Putri
## 19 210605110089  Putra
## 20 210605110091  Putra
## 21 210605110093  Putra
## 22 210605110099  Putra
## 23 210605110100  Putri
## 24 210605110101  Putra
## 25 210605110103  Putri
## 26 210605110104  Putra
## 27 210605110117  Putri
## 28 210605110124  Putri
## 29 210605110126  Putra
## 30 210605110128  Putra
## 31 210605110131  Putra
## 32 210605110168  Putra

Penerapan Data Set Inner Join

innerjoin <- Mahasiswa %>% inner_join(Gender, by="NIM")
innerjoin

##             NIM                    Nama.Mahasiswa gender
## 1  210605110009                     Heny Rimadana  Putri
## 2  210605110015               Najah Muchsin Sanin  Putri
## 3  210605110017        Muizzul Azizah Oktavianing  Putri
## 4  210605110019               Fauzil Hidayatullah  Putra
## 5  210605110022       Noviansyah Maulana Ramadhan  Putra
## 6  210605110025            Daurin Nabilatul Munna  Putri
## 7  210605110028       Moh Tazkia Ikhsanul Ma arif  Putra
## 8  210605110036             Hamzah Faizal Asyhari  Putra
## 9  210605110041                     Rizqy Alfajri  Putra
## 10 210605110042                    Hajratul Aswad  Putri
## 11 210605110043               Arvin Azaria Munsyi  Putra
## 12 210605110044                    Fitria Susanti  Putri
## 13 210605110046             Farid Ahmad Saaduddin  Putra
## 14 210605110067       Muhammad Haris Fahrul Rozzy  Putra
## 15 210605110070        Muhammad Addi Rizza Rahman  Putra
## 16 210605110074             Nurhisam Ari Kusnaini  Putra
## 17 210605110080             Aji Prabowo Pamungkas  Putra
## 18 210605110081             Dinindriya Izzatinisa  Putri
## 19 210605110089                  Aliffikri Hadini  Putra
## 20 210605110091              Dika Afladhia Napiri  Putra
## 21 210605110093           Ilham Romadhon Ali Umri  Putra
## 22 210605110099 Muhammad Haikal Akbar At Taufieqy  Putra
## 23 210605110100             Arneizha Biktarinanda  Putri
## 24 210605110101               Maulana Hilmi Arkan  Putra
## 25 210605110103                    Amalia Amriadi  Putri
## 26 210605110104               Moch. Hasbi Ashidqy  Putra
## 27 210605110117                      Shasy Kirana  Putri
## 28 210605110124             Sayyidah Meutia Zahra  Putri
## 29 210605110126             Muhammad Haqqul Hakim  Putra
## 30 210605110128                  Furkon Aziz Aini  Putra
## 31 210605110131                         Moh.Dawud  Putra
## 32 210605110168                 Ibni Akbar Habibi  Putra

Penerapan Data Set Outer Join

1. A left joint

leftjoin <- left_join(Mahasiswa,Gender)

## Joining, by = "NIM"

leftjoin

##             NIM                    Nama.Mahasiswa gender
## 1  210605110009                     Heny Rimadana  Putri
## 2  210605110015               Najah Muchsin Sanin  Putri
## 3  210605110017        Muizzul Azizah Oktavianing  Putri
## 4  210605110019               Fauzil Hidayatullah  Putra
## 5  210605110022       Noviansyah Maulana Ramadhan  Putra
## 6  210605110025            Daurin Nabilatul Munna  Putri
## 7  210605110028       Moh Tazkia Ikhsanul Ma arif  Putra
## 8  210605110036             Hamzah Faizal Asyhari  Putra
## 9  210605110041                     Rizqy Alfajri  Putra
## 10 210605110042                    Hajratul Aswad  Putri
## 11 210605110043               Arvin Azaria Munsyi  Putra
## 12 210605110044                    Fitria Susanti  Putri
## 13 210605110046             Farid Ahmad Saaduddin  Putra
## 14 210605110067       Muhammad Haris Fahrul Rozzy  Putra
## 15 210605110070        Muhammad Addi Rizza Rahman  Putra
## 16 210605110074             Nurhisam Ari Kusnaini  Putra
## 17 210605110080             Aji Prabowo Pamungkas  Putra
## 18 210605110081             Dinindriya Izzatinisa  Putri
## 19 210605110089                  Aliffikri Hadini  Putra
## 20 210605110091              Dika Afladhia Napiri  Putra
## 21 210605110093           Ilham Romadhon Ali Umri  Putra
## 22 210605110099 Muhammad Haikal Akbar At Taufieqy  Putra
## 23 210605110100             Arneizha Biktarinanda  Putri
## 24 210605110101               Maulana Hilmi Arkan  Putra
## 25 210605110103                    Amalia Amriadi  Putri
## 26 210605110104               Moch. Hasbi Ashidqy  Putra
## 27 210605110117                      Shasy Kirana  Putri
## 28 210605110124             Sayyidah Meutia Zahra  Putri
## 29 210605110126             Muhammad Haqqul Hakim  Putra
## 30 210605110128                  Furkon Aziz Aini  Putra
## 31 210605110131                         Moh.Dawud  Putra
## 32 210605110168                 Ibni Akbar Habibi  Putra

2. A right joint

rightjoin <- right_join(Mahasiswa,Gender)

## Joining, by = "NIM"

rightjoin

##             NIM                    Nama.Mahasiswa gender
## 1  210605110009                     Heny Rimadana  Putri
## 2  210605110015               Najah Muchsin Sanin  Putri
## 3  210605110017        Muizzul Azizah Oktavianing  Putri
## 4  210605110019               Fauzil Hidayatullah  Putra
## 5  210605110022       Noviansyah Maulana Ramadhan  Putra
## 6  210605110025            Daurin Nabilatul Munna  Putri
## 7  210605110028       Moh Tazkia Ikhsanul Ma arif  Putra
## 8  210605110036             Hamzah Faizal Asyhari  Putra
## 9  210605110041                     Rizqy Alfajri  Putra
## 10 210605110042                    Hajratul Aswad  Putri
## 11 210605110043               Arvin Azaria Munsyi  Putra
## 12 210605110044                    Fitria Susanti  Putri
## 13 210605110046             Farid Ahmad Saaduddin  Putra
## 14 210605110067       Muhammad Haris Fahrul Rozzy  Putra
## 15 210605110070        Muhammad Addi Rizza Rahman  Putra
## 16 210605110074             Nurhisam Ari Kusnaini  Putra
## 17 210605110080             Aji Prabowo Pamungkas  Putra
## 18 210605110081             Dinindriya Izzatinisa  Putri
## 19 210605110089                  Aliffikri Hadini  Putra
## 20 210605110091              Dika Afladhia Napiri  Putra
## 21 210605110093           Ilham Romadhon Ali Umri  Putra
## 22 210605110099 Muhammad Haikal Akbar At Taufieqy  Putra
## 23 210605110100             Arneizha Biktarinanda  Putri
## 24 210605110101               Maulana Hilmi Arkan  Putra
## 25 210605110103                    Amalia Amriadi  Putri
## 26 210605110104               Moch. Hasbi Ashidqy  Putra
## 27 210605110117                      Shasy Kirana  Putri
## 28 210605110124             Sayyidah Meutia Zahra  Putri
## 29 210605110126             Muhammad Haqqul Hakim  Putra
## 30 210605110128                  Furkon Aziz Aini  Putra
## 31 210605110131                         Moh.Dawud  Putra
## 32 210605110168                 Ibni Akbar Habibi  Putra

3. A full joint

fulljoin <- full_join(Mahasiswa,Gender)

## Joining, by = "NIM"

fulljoin

##             NIM                    Nama.Mahasiswa gender
## 1  210605110009                     Heny Rimadana  Putri
## 2  210605110015               Najah Muchsin Sanin  Putri
## 3  210605110017        Muizzul Azizah Oktavianing  Putri
## 4  210605110019               Fauzil Hidayatullah  Putra
## 5  210605110022       Noviansyah Maulana Ramadhan  Putra
## 6  210605110025            Daurin Nabilatul Munna  Putri
## 7  210605110028       Moh Tazkia Ikhsanul Ma arif  Putra
## 8  210605110036             Hamzah Faizal Asyhari  Putra
## 9  210605110041                     Rizqy Alfajri  Putra
## 10 210605110042                    Hajratul Aswad  Putri
## 11 210605110043               Arvin Azaria Munsyi  Putra
## 12 210605110044                    Fitria Susanti  Putri
## 13 210605110046             Farid Ahmad Saaduddin  Putra
## 14 210605110067       Muhammad Haris Fahrul Rozzy  Putra
## 15 210605110070        Muhammad Addi Rizza Rahman  Putra
## 16 210605110074             Nurhisam Ari Kusnaini  Putra
## 17 210605110080             Aji Prabowo Pamungkas  Putra
## 18 210605110081             Dinindriya Izzatinisa  Putri
## 19 210605110089                  Aliffikri Hadini  Putra
## 20 210605110091              Dika Afladhia Napiri  Putra
## 21 210605110093           Ilham Romadhon Ali Umri  Putra
## 22 210605110099 Muhammad Haikal Akbar At Taufieqy  Putra
## 23 210605110100             Arneizha Biktarinanda  Putri
## 24 210605110101               Maulana Hilmi Arkan  Putra
## 25 210605110103                    Amalia Amriadi  Putri
## 26 210605110104               Moch. Hasbi Ashidqy  Putra
## 27 210605110117                      Shasy Kirana  Putri
## 28 210605110124             Sayyidah Meutia Zahra  Putri
## 29 210605110126             Muhammad Haqqul Hakim  Putra
## 30 210605110128                  Furkon Aziz Aini  Putra
## 31 210605110131                         Moh.Dawud  Putra
## 32 210605110168                 Ibni Akbar Habibi  Putra

REFERENSI:

https://rpubs.com/suhartono-uinmaliki/relational

Relational Data Set Mahasiswa Semester 2 Teknik Informatika UIN Maulana Malik Ibrahim Malang Tahun 2022 Mata Kuliah kewarganegaraan Kelas A

Arvin Azaria Munsyi

21/3/2022

Tabel Data NIM dan Nama Mahasiswa

Tabel Data Gender

Tabel Data Jumlah Kelompok

Data Set dengan Catatan: Key “NIM” dan Value “Gender”

Penerapan Data Set Inner Join

Penerapan Data Set Outer Join

1. A left joint

2. A right joint

3. A full joint

REFERENSI: