Table Creation

Q:1
Create a table Deposit with fields
AccNo      Number (8)     Primary key
Name       Character (25) Not Null
Branch     Character (20)
Amount     Number (8, 2)  Not Null
Branches can be CALICUT, COCHIN, or TRICHUR.


SQL> CREATE TABLE DEPOSIT(
  2  ACCNO NUMBER(8) PRIMARY KEY,
  3  NAME CHARACTER(25) NOT NULL,
  4  BRANCH CHARACTER(20) CHECK(BRANCH IN('CALICUT','COCHIN','TRICHUR')),
  5  AMOUNT NUMBER(8,2) NOT NULL);

Table created.