Saturday, September 24, 2011

Tugas array pada C

TUGAS
ARRAY dan FUNGSI
1.    Matriks 3 X 3
#include <stdio.h>
#include <conio.h>
main()
{
      int matriks[3][3];
      int A,B,C,i,j;
      A=3;
      B=3;
      for(i=0;i<A;i++)
         {
         for(j=0;j<B;j++)
         {
      printf("Matriks [%d,%d] : ",i+1,j+1);
      scanf("%d",&matriks[i][j]);}}
      printf("\n");
      C = 2 * A + 3 * B;
      printf("C = 2 * A + 3 * B = %d\n\n",C = 2 * A + 3 * B);     
      printf("Matriks = \n\n");
      for(i=0;i<A;i++)
         {
               for(j=0;j<B;j++)
         {
      printf("%3d",matriks[i][j]);
         }
            printf("\n");
         }
      getch ();
      return 0;
}

Tugas C++


TUGAS 1
1.    Menjumlahkan 2 buah bilangan dan mencetak hasilnya
#include<iostream.h>
#include<conio.h>
     main()
{
     clrscr ();
     int nilai1, nilai2, tambah;
     cout<<”masukan nilai 1 :  “ ;
     cin>>nilai1 ;
     cout<<”masukan nilai 2 : “ ;
     cin>>nilai2 ;
     tambah= nilai1 + nilai2 ;
     cout<<”hasil penjumlahan : “ << tambah << endl ;
     getch () ;
}

2.    Mengalikan 2 buah bilangan dan mencetak hasilnya
#include<iostream.h>
#include<conio.h>
     main()
{
     clrscr ();
     int bil1, bil2, kali ;
     cout<<”masukan bilangan 1 :  “ ;
     cin>>bil1 ;
     cout<<”masukan bilangan 2 : “ ;
     cin>>bil2 ;
     tambah= bil1* bil2 ;
     cout<<”hasil penjumlahan : “ << kali << endl ;
     getch () ;
}

Database schema hotel


       Schema hotel
       SQL>CREATE USER HOTEL IDENTIFIED BY HOTEL
          DEFAULT TABLESPACE USERS
          QUOTA UNLIMITED ON USERS;

SQL>GRANT DBA TO HOTEL;


SQL>CONNECT HOTEL/HOTEL;

SQL>CREATE TABLE HOTEL
(
HOTELNO   NUMBER(7),
HOTELNAME                    VARCHAR2(50),
CITY                                       VARCHAR2(50)
);

SQL>CREATE TABLE ROOM
(
ROOMNO                           NUMBER(7),
HOTELNO                           NUMBER(7),
TYPE                                      NUMBER(7),
PRICE                                   NUMBER(7)
);

SQL>CREATE TABLE BOOKING
(
HOTELNO                           NUMBER(7),
GUESTNO                           NUMBER(7),
DATEFROM                       DATE,
DATETO                               DATE,
ROOMNO                           NUMBER(7)
);

SQL>CREATE TABLE GUEST
 (
GUESTNO                           NUMBER(7),
GUESTNAME                    VARCHAR2(50),
GUESTADDRESS             VARCHAR2(50)                  
);

Array pada pascal

contoh program array pada pascal :

program contoh_konstan_array_char_;
uses wincrt;
var
   nilai_akhir : INTEGER;
   nilai_kehadiran,nilai_UTS,nilai_Tugas,nilai_UAS : ARRAY[1..4] OF integer;
   A,B,C,D = real;
begin
    nilai_kehadiran [1] := 50;
    nilai_UTS       [2] := 60;
    nilai_Tugas     [3] := 50;
    nilai_UAS       [4] := 60;
    begin

Wednesday, September 21, 2011

Merubah User LOGIN EBIS

[vismgr@obasvr01 ~]$ FNDCPASS apps/apps 0 y system/manager user sysadmin welcome

APPS
username : apps
password : apps

DATABASE
username : system
password : manager

User LOGIN EBIS
username : sysadmin
password : welcome