untuk membuatnya pertama-tama masukan despendency ini di module.gradle 

compile 'com.google.android.gms:play-services:10.0.1'

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:app="http://schemas.android.com/apk/res-auto"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    tools:context="com.giviews.qrcodescanner.MainActivity">



    <Button

        android:id="@+id/scanbtn"

        android:layout_marginTop="40dp"

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:text="scan"

        android:layout_centerHorizontal="true" />



    <TextView

        android:id="@+id/result"

        android:layout_width="match_parent"

        android:layout_height="wrap_content"

        android:layout_below="@+id/scanbtn"

        android:text="RESULT"

        android:textSize="25dp"

        android:layout_marginTop="20dp"

        android:gravity="center"/>



</RelativeLayout>

package com.giviews.qrcodescanner;



import android.Manifest;

import android.content.Intent;

import android.content.pm.PackageManager;

import android.support.v4.app.ActivityCompat;

import android.support.v4.content.ContextCompat;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.view.View;

import android.widget.Button;

import android.widget.TextView;



import com.google.android.gms.vision.barcode.Barcode;



public class MainActivity extends AppCompatActivity {

    private Button scanbtn;

    private TextView result;

    public static final int REQUEST_CODE = 100;

    public static final int PERMISSION_REQUEST = 200;



    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_main);

        if (ContextCompat.checkSelfPermission(this, Manifest.permission.CAMERA) != PackageManager.PERMISSION_GRANTED) {

            ActivityCompat.requestPermissions(this, new String[]{Manifest.permission.CAMERA}, PERMISSION_REQUEST);

        }

        scanbtn = (Button) findViewById(R.id.scanbtn);

        result = (TextView) findViewById(R.id.result);

        scanbtn.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                Intent intent = new Intent(getApplicationContext(), ScanActivity.class);

                startActivityForResult(intent, REQUEST_CODE);

            }

        });

    }



    @Override

    protected void onActivityResult(int requestCode, int resultCode, Intent data) {

        if (requestCode == REQUEST_CODE && resultCode == RESULT_OK) {

            if (data != null) {

                final Barcode barcode = data.getParcelableExtra("barcode");

                result.post(new Runnable() {

                    @Override

                    public void run() {

                        result.setText(barcode.displayValue);

                    }

                });

            }

        }

    }

}

<?xml version="1.0" encoding="utf-8"?>

<RelativeLayout xmlns:android="http://schemas.android.com/apk/res/android"

    xmlns:app="http://schemas.android.com/apk/res-auto"

    xmlns:tools="http://schemas.android.com/tools"

    android:layout_width="match_parent"

    android:layout_height="match_parent"

    tools:context="com.giviews.qrcodescanner.ScanActivity">



    <SurfaceView

        android:id="@+id/cameraView"

        android:layout_width="match_parent"

        android:layout_height="match_parent" />



</RelativeLayout>

package com.giviews.qrcodescanner;



import android.*;

import android.Manifest;

import android.content.Intent;

import android.content.pm.PackageManager;

import android.support.v4.content.ContextCompat;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.util.SparseArray;

import android.view.SurfaceHolder;

import android.view.SurfaceView;

import android.widget.Toast;



import com.google.android.gms.vision.CameraSource;

import com.google.android.gms.vision.Detector;

import com.google.android.gms.vision.barcode.Barcode;

import com.google.android.gms.vision.barcode.BarcodeDetector;



import java.io.IOException;



import static com.giviews.qrcodescanner.MainActivity.REQUEST_CODE;



public class ScanActivity extends AppCompatActivity {

    SurfaceView cameraView;

    BarcodeDetector barcode;

    CameraSource cameraSource;

    SurfaceHolder holder;



    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_scan);

        cameraView = (SurfaceView) findViewById(R.id.cameraView);

        cameraView.setZOrderMediaOverlay(true);

        holder = cameraView.getHolder();

        barcode = new BarcodeDetector.Builder(this)

                .setBarcodeFormats(Barcode.QR_CODE)

                .build();

        if (!barcode.isOperational()) {

            Toast.makeText(getApplicationContext(), "Sorry couldnt setup the detector", Toast.LENGTH_LONG).show();

            this.finish();

        }



        cameraSource = new CameraSource.Builder(this, barcode)

                .setFacing(CameraSource.CAMERA_FACING_BACK)

                .setRequestedFps(24)

                .setAutoFocusEnabled(true)

                .setRequestedPreviewSize(1920,1024)

                .build();

        cameraView.getHolder().addCallback(new SurfaceHolder.Callback() {

            @Override

            public void surfaceCreated(SurfaceHolder surfaceHolder) {

                try {

                    if (ContextCompat.checkSelfPermission(ScanActivity.this, Manifest.permission.CAMERA) == PackageManager.PERMISSION_GRANTED) {

                        cameraSource.start(cameraView.getHolder());

                    }

                } catch (IOException e) {

                    e.printStackTrace();

                }

            }



            @Override

            public void surfaceChanged(SurfaceHolder surfaceHolder, int i, int i1, int i2) {



            }



            @Override

            public void surfaceDestroyed(SurfaceHolder surfaceHolder) {



            }

        });

        barcode.setProcessor(new Detector.Processor<Barcode>() {

            @Override

            public void release() {



            }



            @Override

            public void receiveDetections(Detector.Detections<Barcode> detections) {

                final SparseArray<Barcode> barcode = detections.getDetectedItems();

                if (barcode.size() > 0) {

                    Intent intent = new Intent();

                    intent.putExtra("barcode", barcode.valueAt(0));

                    setResult(RESULT_OK, intent);

                    finish();

                }

            }

        });

    }

}

<uses-permission android:name="android.permission.CAMERA" />

<meta-data

    android:name="com.google.android.gms.vision.DEPENDENCIES"

    android:value="barcode" />

jika scan berhasil

package com.giviews.giviewsmessenger;



import android.app.ProgressDialog;

import android.content.Intent;

import android.support.annotation.NonNull;

import android.support.v7.app.AppCompatActivity;

import android.os.Bundle;

import android.support.v7.widget.Toolbar;

import android.text.TextUtils;

import android.util.Log;

import android.view.View;

import android.widget.Button;

import android.widget.EditText;

import android.widget.Toast;



import com.google.android.gms.tasks.OnCompleteListener;

import com.google.android.gms.tasks.Task;

import com.google.firebase.auth.AuthResult;

import com.google.firebase.auth.FirebaseAuth;

import com.google.firebase.auth.FirebaseAuthInvalidCredentialsException;

import com.google.firebase.auth.FirebaseAuthUserCollisionException;

import com.google.firebase.auth.FirebaseAuthWeakPasswordException;

import com.google.firebase.auth.FirebaseUser;

import com.google.firebase.database.DatabaseReference;

import com.google.firebase.database.FirebaseDatabase;

import com.google.firebase.iid.FirebaseInstanceId;



import java.util.HashMap;



public class RegisterActivity extends AppCompatActivity {



    private EditText mDisplayName;

    private EditText mEmail;

    private EditText mPassword;

    private Button mCreateBtn;

    private Toolbar mToolbar;

    private ProgressDialog mProgress;



    private FirebaseAuth mAuth;

    private DatabaseReference mDatabase;



    @Override

    protected void onCreate(Bundle savedInstanceState) {

        super.onCreate(savedInstanceState);

        setContentView(R.layout.activity_register);



        mAuth = FirebaseAuth.getInstance();

        mDatabase = FirebaseDatabase.getInstance().getReference().child("Users");

        mToolbar = (Toolbar) findViewById(R.id.main_page_toolbar);

        setSupportActionBar(mToolbar);

        getSupportActionBar().setTitle("Register");

        getSupportActionBar().setDisplayHomeAsUpEnabled(true);



        mDisplayName = (EditText) findViewById(R.id.reg_name);

        mEmail = (EditText) findViewById(R.id.reg_email);

        mPassword = (EditText) findViewById(R.id.reg_password);

        mCreateBtn = (Button) findViewById(R.id.reg_create_btn);

        mProgress = new ProgressDialog(this);



        mCreateBtn.setOnClickListener(new View.OnClickListener() {

            @Override

            public void onClick(View view) {

                String displayname = mDisplayName.getText().toString().trim();

                String email = mEmail.getText().toString().trim();

                String password = mPassword.getText().toString().trim();



                if (!TextUtils.isEmpty(displayname) && !TextUtils.isEmpty(email) && !TextUtils.isEmpty(password)) {

                    mProgress.setTitle("Registering User");

                    mProgress.setMessage("Please wait while we create your account...");

                    mProgress.setCanceledOnTouchOutside(false);

                    mProgress.show();



                    register_user(displayname, email, password);

                }

            }

        });

    }



    private void register_user(final String displayname, String email, String password) {

        mAuth.createUserWithEmailAndPassword(email, password)

                .addOnCompleteListener(this, new OnCompleteListener() {

                    @Override

                    public void onComplete(@NonNull Task task) {



                        // If sign in fails, display a message to the user. If sign in succeeds

                        // the auth state listener will be notified and logic to handle the

                        // signed in user can be handled in the listener.

                        if (!task.isSuccessful()) {

                            mProgress.hide();



                            String error = "";

                            try {

                                throw task.getException();

                            } catch (FirebaseAuthWeakPasswordException e) {

                                error = "Weak Password";

                            } catch (FirebaseAuthInvalidCredentialsException e) {

                                error = "Invalid Email";

                            } catch (FirebaseAuthUserCollisionException e) {

                                error = "Existing account";

                            } catch (Exception e) {

                                error = "Unknown Error!";

                                e.printStackTrace();

                            }

                            Toast.makeText(getApplicationContext(), error, Toast.LENGTH_SHORT).show();

                        }else {

                            FirebaseUser currentUser = mAuth.getCurrentUser();

                            String uid = currentUser.getUid();



                            mDatabase = FirebaseDatabase.getInstance().getReference().child("Users").child(uid);

                            String device_token = FirebaseInstanceId.getInstance().getToken();



                            HashMap, String> userMap = new HashMap, String>();

                            userMap.put("name", displayname);

                            userMap.put("status", "Hi there, I'm using giviews");

                            userMap.put("image", "default");

                            userMap.put("thumb_image", "default");

                            userMap.put("device_token", device_token);



                            mDatabase.setValue(userMap).addOnCompleteListener(new OnCompleteListener() {

                                @Override

                                public void onComplete(@NonNull Task task) {

                                    mProgress.dismiss();

                                    Intent mainIntent = new Intent(RegisterActivity.this, MainActivity.class);

                                    mainIntent.addFlags(Intent.FLAG_ACTIVITY_NEW_TASK | Intent.FLAG_ACTIVITY_CLEAR_TASK);

                                    startActivity(mainIntent);

                                }

                            });



                        }

                    }

                });

    }

}

CREATE USER tugas_bd3_1501110039 IDENTIFIED BY stikomcki;

create view v_pasien as select * from pasien_1501110039;
create view v_dosis as select * from dosis_1501110039;
create view v_obat as select * from obat_1501110039;
create view v_detail as select * from berobat_detail_1501110039;
create view v_dokter as select * from dokter_1501110039;
create view v_berobat as select * from berobat_1501110039;
create view v_sakit as select * from sakit_1501110039;

create or replace procedure insertPasien(
kd_pasien in pasien_1501110039.kd_pasien%TYPE,
nm_pasien in pasien_1501110039.nm_pasien%TYPE,
no_ktp in pasien_1501110039.nm_pasien%TYPE,
tempat_lahir in pasien_1501110039.nm_pasien%TYPE,
tgl_lahir in pasien_1501110039.nm_pasien%TYPE,
alamat in pasien_1501110039.nm_pasien%TYPE,
kelurahan in pasien_1501110039.nm_pasien%TYPE,
kecamatan in pasien_1501110039.nm_pasien%TYPE,
wilayah in pasien_1501110039.nm_pasien%TYPE,
kode_pos in pasien_1501110039.nm_pasien%TYPE,
telp in pasien_1501110039.nm_pasien%TYPE
)
is
begin
insert into pasien_1501110039 (kd_pasien,nm_pasien,no_ktp,tempat_lahir,tgl_lahir,alamat,kelurahan,kecamatan,wilayah,kode_pos,telp)
values (kd_pasien,nm_pasien,no_ktp,tempat_lahir,tgl_lahir,alamat,kelurahan,kecamatan,wilayah,kode_pos,telp);
commit;
end;
/

create or replace procedure insertSakit(
kd_sakit in sakit_1501110039.kd_sakit%TYPE,
deskripsi_sakit in sakit_1501110039.deskripsi_sakit%TYPE)
is
begin
insert into sakit_1501110039
(kd_sakit,deskripsi_sakit)
values
(kd_sakit,deskripsi_sakit);
commit;
end;
/
 
create or replace procedure insertDokter(
kd_dokter in dokter_1501110039.kd_dokter%TYPE,
nm_dokter in dokter_1501110039.nm_dokter%TYPE)
is
begin
insert into dokter_1501110039
(kd_dokter,nm_dokter)
values
(kd_dokter,nm_dokter);
commit;
end;
/

create or replace procedure berobat(
no_berobat in berobat_1501110039.no_berobat%TYPE,
tgl_berobat in berobat_1501110039.tgl_berobat%TYPE,
kd_pasien in berobat_1501110039.kd_pasien%TYPE,
kd_sakit in berobat_1501110039.kd_sakit%TYPE,
kd_dokter in berobat_1501110039.kd_dokter%TYPE,
keterangan in berobat_1501110039.keterangan%TYPE)
is
begin
insert into berobat_1501110039
(no_berobat,tgl_berobat,kd_pasien,kd_sakit,kd_dokter,keterangan)
values
(no_berobat,tgl_berobat,kd_pasien,kd_sakit,kd_dokter,keterangan);
commit;
end;
/

create or replace procedure insertDosis(
kd_dosis in dosis_1501110039.kd_dosis%TYPE,
nm_dosis in dosis_1501110039.nm_dosis%TYPE)
is
begin
insert into dosis_1501110039
(kd_dosis,nm_dosis)
values
(kd_dosis,nm_dosis);
commit;
end;
/

create or replace procedure insertObat(
kd_obat in obat_1501110039.kd_dosis%TYPE,
nm_obat in obat_1501110039.kd_dosis%TYPE,
kd_dosis in obat_1501110039.kd_dosis%TYPE)
is
begin
insert into obat_1501110039
(kd_obat,nm_obat,kd_dosis)
values
(kd_obat,nm_obat,kd_dosis);
commit;
end;
/

create or replace procedure insertDetail(
no_berobat in berobat_detail_1501110039.no_berobat%TYPE,
kd_obat in berobat_detail_1501110039.kd_obat%TYPE)
is
begin
insert into berobat_detail_1501110039
(no_berobat,kd_obat)
values
(no_berobat,kd_obat);
commit;
end;
/

execute berobat('BR001','20012018','P001','S003','D004','rawat jalan');

execute berobat('BR002','20012018','P002','S005','D008','rawat inap');

execute insertDokter('D001','dr. Juniar, SpKj');

execute insertSakit('S001','sakit Kepala');

execute insertDosis('DS001','3x1 hari');

execute insertDosis('DS002','1/2 sendok teh');

execute insertObat('OB001','Parasetamol','DS001');

execute insertDetail('BR001','OB004');

execute insertPasien('P001','Nina N','3101099988','Tasikmalaya','090295','Kedoya','kebayoran lama','jakarta utara','DKI Jakarta','13420','98000012');

execute insertPasien('P002','Ani Doe','32051099988','Tasikmalaya','090295','Cikini','Gondangdia','jakarta Pusat','DKI Jakarta','13420','6285700291');

execute insertPasien('P003','Sena','32051099999','Tasikmalaya','090290','Dukuh Atas','Gondangdia','jakarta Pusat','DKI Jakarta','13420','628570022');

execute insertPasien('P004','Andri','32051092399','Jakarta','200678','Dukuh Atas','Gambir','jakarta Pusat','DKI Jakarta','13420','628570022');

create table history_pasien(kd_pasien char(6), nm_pasien varchar2(30), no_ktp number, tempat_lahir varchar2(30), tgl_lahir char(6), alamat varchar2(30), kelurahan varchar2(30), kecamatan varchar2(30), wilayah varchar(30), kode_pos char(6), telp number, jenis_aksi varchar(6), aksi_tgl date);

create or replace trigger tr_pasien
after insert
on pasien_1501110039
for each row
begin
insert into history_pasien values (
:NEW.kd_pasien,
:NEW.nm_pasien,
:NEW.no_ktp,
:NEW.tempat_lahir,
:NEW.tgl_lahir,
:NEW.alamat,
:NEW.kelurahan,
:NEW.kecamatan,
:NEW.wilayah,
:NEW.kode_pos,
:NEW.telp,
'AFTER',
SYSDATE
);
END;
/

create or replace trigger tr_pasien_before
before insert
on pasien_1501110039
for each row
begin
insert into history_pasien values (
:NEW.kd_pasien,
:NEW.nm_pasien,
:NEW.no_ktp,
:NEW.tempat_lahir,
:NEW.tgl_lahir,
:NEW.alamat,
:NEW.kelurahan,
:NEW.kecamatan,
:NEW.wilayah,
:NEW.kode_pos,
:NEW.telp,
'BEFORE',
SYSDATE
);
END;
/