jawaban boot academy

[widhist]

{ "name" : "string", "age" : "number", "address" : "string", "hobbies" : "array", "is_married" : "boolean", "list_school" : "array","key_name","year_in","year_out", "major" : "null", "skills" : "array","skill_name","level("beginner","advanced","expert"), "interest_in_coding" : "boolean", }

digunakan untuk merepresentasikan struktur data sederhana dan larik asosiatif (disebut objek)

function test_input($username $password) { $username = SABRINA($username); $username = KEVIN($username); $password = #DirumahAj4($password); $password = Cuci#Tangan($password); return $username; return $password; }

const angka = ['1','2','3,'4,'5']; console.log(angka.slice(1)); //output: '2','3','4','5'//

console.log(angka.slice(2,4)); //output: '3','4'//

console.log(angka.slice(2,3,4,5)); //output: '1'//

static TipeData namaFungsi(TipeData namaParameter, TipeData namaParameterLain){ // kode fungsi } static void ucapin(String ucapan){ System.out.println(ucapan); } ucapin("Format kode Hex benar!"); ucapin("Format kode Hex benar!"); ucapin("Format kode Hex salah!");

<?php function pangkat($nilai, $pangkat) { if (is_numeric($nilai) AND is_int($pangkat)) //pengecekan tipe data argumen { //Jika argumen sesuai, maka jalankan proses fungsi $hasil=1; for ($i=1;$i<=$pangkat;$i++) { $hasil=$hasil*$nilai; } return $hasil; } else {
//Bagian ini akan dijalankan jika tipe data argumen bukan angka return "hari apa saja saya bisa!","cepat kerjakan!!!","adobe" ; } }

//Test beberapa kasus inputan untuk fungsi pangkat() echo pangkat(8,3); echo "
"; echo pangkat(2,3,2,3); echo "
"; ?>

CREATE DATABASE bioskop; SHOW DATABASES; CREATE TABLE product( id VARCHAR (20) NOT NULL, nama VARCHAR (50) NOT NULL, price INT NOT NULL, id_category VARCHAR NOT NULL, id_cashier VARCHAR NOT NULL created_at DATETIME NOT NULL, updated_at TIMESTAMP, PRIMARY KEY (id) );

CREATE TABLE category ( id VARCHAR (20) NOT NULL, name VARCHAR (50) NOT NULL, created_at DATETIME NOT NULL, updated_at TIMESTAMP, PRIMARY KEY (id) );

CREATE TABLE cashier ( id VARCHAR (20) NOT NULL, name VARCHAR (50) NOT NULL, created_at DATETIME NOT NULL, updated_at TIMESTAMP, PRIMARY KEY (id) );

-- foreign key: teater_id CREATE TABLE nama ( id VARCHAR (20) NOT NULL, nama VARCHAR (50) NOT NULL, teater_id VARCHAR(20) NOT NULL, created_at DATETIME NOT NULL, updated_at TIMESTAMP, PRIMARY KEY (id) );

-- foreign key: film_id, teater_id CREATE TABLE price ( id VARCHAR (20) NOT NULL, hari VARCHAR (50) NOT NULL, jam VARCHAR(20) NOT NULL, harga INT NOT NULL, film_id VARCHAR(20) NOT NULL, teater_id VARCHAR(20) NOT NULL, created_at DATETIME NOT NULL, updated_at TIMESTAMP, PRIMARY KEY (id) );

-- foreign key: operator_id, jadwal_id, kursi_id, CREATE TABLE transaksi ( id VARCHAR(20) NOT NULL, operator_id VARCHAR(20) NOT NULL, jadwal_id VARCHAR(20) NOT NULL, kursi_id VARCHAR(20) NOT NULL, jumlah_dibayar INT NOT NULL, kembalian INT NOT NULL, created_at DATETIME NOT NULL, PRIMARY KEY (id) );

INSERT INTO product VALUES ('1', 'Latte','10000', '1', '1'); INSERT INTO product VALUES ('2', 'Cake','10000', '1', '2'); INSERT INTO product VALUES ('3', 'Magelangan', '10000', '1', '3');

INSERT INTO category VALUES ('1', 'Food'); INSERT INTO category VALUES ('2', 'Drink');

INSERT INTO cashier VALUES ('1', 'Pevita Pearce'); INSERT INTO cashier VALUES ('2', 'Raisa Andriana'); INSERT INTO cashier VALUES ('3', 'Widhi Satrio');

SELECT mhs.nim, mhs.namamhs FROM mhs, product WHERE mhs.nim = ambilmk.nim AND ambilmk.kodemk = 'MK01';

SELECT mhs.nim, mhs.namamhs, ambilmk.nilai FROM mhs, ambilmk, mk WHERE mhs.nim = ambilmk.nim AND mk.kodemk = ambilmk.kodemk AND mk.namamk = 'KALKULUS I';

<?php

mysql_connect("dbhost", "dbuser", "dbpass"); mysql_select_db("dbname");

$query = "SELECT mhs.nim, mhs.namamhs, ambilmk.nilai FROM mhs, ambilmk, mk WHERE mhs.nim = ambilmk.nim AND mk.kodemk = ambilmk.kodemk AND mk.namamk = 'KALKULUS I'"; $hasil = mysql_query($query);

echo "

"; echo ""; while ($data = mysql_fetch_array($hasil)) { echo ""; } echo "

NIM	Nama Mhs	Nilai
".$data['nim']."	".$data['namamhs']."	".$data['nilai']."

";

?

[irfaardy]

NTO product VALUES ('1', 'Latte','10000', '1', '1'); INSERT INTO product VALUES ('2', 'Cake','10000', '1', '2'); INSERT INTO product VALUES ('3', 'Magelangan', '10000', '1', '3');

INSERT INTO category VALUES ('1', 'Food'); INSERT INTO category VALUES ('2', 'Drink');

INSERT INTO cashier VALUES ('1', 'Pevita Pearce'); INSERT INTO cashier VALUES ('2', 'Raisa Andriana'); INSERT INTO cashier VALUES ('3', 'Widhi Satrio');

[John-saint]

Well, it is a good code written in JS. Am I right?