segi3

# apple script to quickly create calendar events cause im not feeling like upgrading from big sur atm

# usage
# meeting in 5 => will create event with summary meeting in 5 minutes from current datetime
# meeting at 16.00 => will create event with summary meeting at 16.00
# meeting on 23/08/2023 at 16.00 => will create event with summary meeting on that date and time

# preferably don't use at, in, or on for summary text

display dialog "Create Calendar Event" default answer "" buttons {"Cancel", "Add Event"} default button 2

segi3

const product_ngrok_url = 'http://237d-180-243-3-100.ngrok.io'
const order_ngrok_url = 'http://9c67-180-243-3-100.ngrok.io'

function get_api_response(url) {
  var options = {
    'method' : 'post',
    'headers' : {
      'authorization': 'Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJlbWFpbCI6InJhZmkudHdvQGVtYWlsLmNvbSIsIm5hbWUiOiJyYWZpIHR3byIsImlhdCI6MTYzMTM0NzI1NX0.PwsyRHP-UWguC4Py222zTRF4gV7bQ_6BX5YiC8BO8Lw'
     }
  }

segi3

CREATE TABLE PELANGGAN ( 
P_NO            CHAR(5), 
P_NAMA          VARCHAR(60), 
P_JENISKEL      CHAR(1), 
P_TEMPATLAHIR   VARCHAR(30), 
P_TGLLAHIR      DATE, 
P_ALAMAT        VARCHAR(200), 
P_NOTELP        VARCHAR(15), 
P_TGLDAFTAR     DATE, 
PRIMARY KEY (P_NO) 

segi3

-- bagian praktek

-- 1
SELECT * FROM negara

-- 2
SELECT * FROM benua

-- 3

segi3

# kelompok 6
# 05111640000055 HONESTA SWANDARU
# 05111840000093 MUHAMMAD AFIF FADHLURRAHMAN
# 05111840000094 RAFI NIZAR ABIYYI


import abc

# * interface pizza
class Pizza(metaclass=abc.ABCMeta):

segi3

-- triggernya udah ada di ppt -bagian yaboi

insert into classes (COURSE_ID, CLASS_NAME) values ('C0001', 'Life coaching - Class 1');
insert into classes (COURSE_ID, CLASS_NAME) values ('C0001', 'Life coaching - Class 2');
insert into classes (COURSE_ID, CLASS_NAME) values ('C0002', 'Machine Learning w/ python - Class 1');
insert into classes (COURSE_ID, CLASS_NAME) values ('C0002', 'Machine Learning w/ python - Class 2');

segi3

/*==============================================================*/
/* Table: TEACHERS                                              */
/*==============================================================*/
create table TEACHERS
(
   TEACHER_ID           char(5) not null,
   TEACHER_NAME         varchar(128) not null,
   EMAIL                varchar(64) not null,
   PASSWORD              varchar(28) not null,

segi3

script DDL
https://livesql.oracle.com/apex/livesql/s/jtxcne8xn4u4du2xy3rvoexn3

script jawaban
https://gist.github.com/segi3/33f9a70cb04da3c05208aa8c9000b008

Rafi Nizar Abiyyi / 05111840000094
MBD B 

-- 1

segi3

1. buat folder SoalShiftSISOP20_modul2_F04/

2. buka foldernya terus open in terminal

3. run command ini dari atas urut

git init

git remote add origin https://github.com/segi3/SoalShiftSISOP20_modul2_F04

segi3

--  DDL
CREATE TABLE DataPasien (
    IDPasien        CHAR(7) NOT NULL PRIMARY KEY,
    NoKTP           CHAR(20) NOT NULL,
    NamaPasien      VARCHAR(75) NOT NULL,
    AlamatPasien    VARCHAR(100) NOT NULL,
    JenisKel        CHAR(1) NOT NULL,
    GolDarah        CHAR(2) NOT NULL,
    TglLahir        DATE,
    Telp            VARCHAR(14) NOT NULL