p2

CREATE TABLE EMPLOYEE (
EMP_NAME VARCHAR2(30),
STREET VARCHAR2(30),
CITY VARCHAR2(30)
);

• CREATE TABLE WORK (
  EMP_NAME VARCHAR2(30),
  CMP_NAME VARCHAR2(30),
  SALARY INTEGER
  );
  CREATE TABLE COMPANY (
  CMP_NAME VARCHAR2(30),
  CITY VARCHAR2(30)
  );
  CREATE TABLE MANAGER (
  EMP_NAME VARCHAR2(30),
  MAN_NAME VARCHAR2(30)
  );
  CREATE TABLE SAILORS (
  SID INTEGER;
  SNAME VARCHAR2(30),
  DAY VARCHAR2(30)
  );

CREATE TABLE BOATS (
BID INTEGER,
BNAME VARCHAR2(30),
COLOR VARCHAR2(30)
);

• CREATE TABLE CLIENT (
  CI_NO VARCHAR2(30),
  NAME VARCHAR2(30),
  CITY VARCHAR2(30),
  PINCODE INTEGER,
  STATE VARCHAR2(30),
  BALDUE INTEGER
  );
  CREATE TABLE PRODUCT (
  PR_NO VARCHAR2(30),
  DSCR VARCHAR2(30),
  PROFIT INTEGER,
  UNIT VARCHAR2(30),
  QTY INTEGER,
  RECORDER_LVL INTEGER,
  SELL_PRICE INTEGER,
  COST_PRICE INTEGER
  );
  QUERY: CREATE TABLE SALESMAN (
  SI_NO VARCHAR2(30),
  NAME VARCHAR2(30),
  ADD1 INTEGER,
  ADD2 VARCHAR2(30),
  PIN INTEGER,
  CITY VARCHAR2(30),
  STATE VARCHAR2(30),
  AMT INTEGER,
  TGT INTEGER,
  SALES INTEGER,
  REM INTEGER
  );
  CREATE TABLE SALEORDER (
  OD_NO VARCHAR2(30),
  SI_NO VARCHAR2(30),
  O_DAT INTEGER,
  SI_NO VARCHAR2(30),
  D-TYPE CHAR,
  BILL CHAR,
  D_DAT VARCHAR2(30),
  STATUS VARCHAR2(30)
  );
  CREATE TABLE SALESORDER_DETAILS (
  OD_NO VARCHAR2(30),
  PR_NO VARCHAR2(30),
  QTY_ORDER INTEGER,
  QTY_DISP VARCHAR2(30),
  RATE INTEGER
  );
  CREATE TABLE BORROW (
  LOANNO VARCHAR2(30),
  CNAME VARCHAR2(30),
  BNAME VARCHAR2(30),
  AMOUNT FLOAT
  );
  CREATE TABLE BRANCH (
  BNAME VARCHAR2(30),
  CITY VARCHAR2(30)
  );
  CREATE TABLE CUSTOMERS (
  CNAME VARCHAR2(30),
  CITY VARCHAR2(30)
  );