SQL

Example:

CREATE TABLESPACE SCT_Admin DATAFILE 'sct_admin.dat' SIZE 10M ONLINE;

INITIAL EXTENT SIZE 10k

NEXT EXTENT SIZE 50k MINEXTENTS 1 MAXEXTENTS 999 PCTINCREASE 10

CREATE TABLESPACE SCT_DATA

DATAFILE 'SCT_Data.dat'

SIZE 20M DEFAULT STORAGE(

INITIAL 10K NEXT 50K

MINEXTENTS 1

MAXEXTENTS 999

PCTINCREASE 10

)

ONLINE;

CREATE TABLESPACE "SCT_DATA"

LOGGING

DATAFILE 'D:\ORACLE\ORADATA\ SCT\SCT_DATA.ora'

SIZE 20M

AUTOEXTEND ON NEXT 50K

MAXSIZE UNLIMITED

DEFAULT STORAGE(

INITIAL 10K

NEXT 50K MINEXTENTS 1

MAXEXTENTS 999

PCTINCREASE 10)

CREATE USER "DBA_SCT"

PROFILE "DEFAULT"

IDENTIFIED BY "<password>"

DEFAULT TABLESPACE "SYSTEM"

TEMPORARY TABLESPACE "TEMP"

ACCOUNT UNLOCK;

GRANT "CONNECT" TO "DBA_SCT"

WITH ADMIN OPTION;

GRANT "DBA" TO "DBA_SCT"

WITH ADMIN OPTION;

***********CREATING TABLESPACE CAR_RENTAL******************
CREATE TABLESPACE BANK_SYS
DATAFILE 'Bank_Sys.dat' SIZE 50M
DEFAULT STORAGE(
INITIAL 10K Next 50K
MINEXTENTS 1 MAXEXTENTS 999
PCTINCREASE 10
)
ONLINE;

************CREATING USER DBA_SCT*****************
CREATE USER "DBA_BANKSYS"
PROFILE "DEFAULT"
IDENTIFIED BY "sct2306"
DEFAULT TABLESPACE "SYSTEM"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;

************GRANTING PERMISSIONS TO DBA_SCT**************
GRANT "DBA" TO "DBA_BANKSYS" WITH ADMIN OPTION;

************CREATING USER SHARANAM*****************
CREATE USER "SHARANAM"
PROFILE "DEFAULT"
IDENTIFIED BY "SHARANAM"
DEFAULT TABLESPACE "BANK_SYS"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;

************GRANTING PERMISSIONS TO SHARANAM**************
GRANT CREATE TABLE TO "SHARANAM";
GRANT CREATE VIEW TO "SHARANAM";
GRANT INSERT ANY TABLE TO "SHARANAM";
GRANT SELECT ANY TABLE TO "SHARANAM";
GRANT UPDATE ANY TABLE TO "SHARANAM";
GRANT "CONNECT" TO "SHARANAM" WITH ADMIN OPTION;

************CREATING USER HANSEL*****************
CREATE USER "HANSEL"
PROFILE "DEFAULT"
IDENTIFIED BY "HANSEL"
DEFAULT TABLESPACE "BANK_SYS"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;

************GRANTING PERMISSIONS TO HANSEL**************
GRANT CREATE TABLE TO "HANSEL";
GRANT CREATE VIEW TO "HANSEL";
GRANT INSERT ANY TABLE TO "HANSEL";
GRANT SELECT ANY TABLE TO "HANSEL";
GRANT UPDATE ANY TABLE TO "HANSEL";
GRANT "CONNECT" TO "HANSEL" WITH ADMIN OPTION;

************CREATING USER IVAN*****************
CREATE USER "IVAN"
PROFILE "DEFAULT"
IDENTIFIED BY "IVAN"
DEFAULT TABLESPACE "BANK_SYS"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK;

************GRANTING PERMISSIONS TO IVAN**************
GRANT CREATE TABLE TO "IVAN";
GRANT CREATE VIEW TO "IVAN";
GRANT INSERT ANY TABLE TO "IVAN";
GRANT SELECT ANY TABLE TO "IVAN";
GRANT UPDATE ANY TABLE TO "IVAN";
GRANT "CONNECT" TO "IVAN" WITH ADMIN OPTION;

DROP TABLE TMP_FD_AMT;

DROP TABLE TRANS_DTLS;

DROP TABLE TRANS_MSTR;

DROP TABLE CNTC_DTLS;

DROP TABLE ADDR_DTLS;

DROP TABLE ACCT_FD_CUST_DTLS;

DROP TABLE NOMINEE_MSTR;

DROP TABLE FD_DTLS;

DROP TABLE FD_MSTR;

DROP TABLE FDSLAB_MSTR;

DROP TABLE ACCT_MSTR;

DROP TABLE SPRT_DOC;

DROP TABLE CUST_MSTR;

DROP TABLE EMP_MSTR;

DROP TABLE BRANCH_MSTR;

-- BRANCH_MSTR

CREATE TABLE "DBA_BANKSYS"."BRANCH_MSTR"(

"BRANCH_NO" VARCHAR2(10),

"NAME" VARCHAR2(25));

-- EMP_MSTR

CREATE TABLE "DBA_BANKSYS"."EMP_MSTR"(

"EMP_NO" VARCHAR2(10),

"BRANCH_NO" VARCHAR2(10),

"FNAME" VARCHAR2(25),

"MNAME" VARCHAR2(25),

"LNAME" VARCHAR2(25),

"DEPT" VARCHAR2(30),

"DESIG" VARCHAR2(30),

"MNGR_NO" VARCHAR2(10));

-- CUST_MSTR

CREATE TABLE "DBA_BANKSYS"."CUST_MSTR"(

"CUST_NO" VARCHAR2(10),

"FNAME" VARCHAR2(25),

"MNAME" VARCHAR2(25),

"LNAME" VARCHAR2(25),

"DOB_INC" DATE NOT NULL,

"OCCUP" VARCHAR2(25),

"PHOTOGRAPH" VARCHAR2(25),

"SIGNATURE" VARCHAR2(25),

"PANCOPY" VARCHAR2(1),

"FORM60" VARCHAR2(1));

-- SPRT_DOC

CREATE TABLE "DBA_BANKSYS"."SPRT_DOC"(

"ACCT_CODE" VARCHAR2(4),

"TYPE" VARCHAR2(40),

"DOCS" VARCHAR2(75));

-- ACCT_MSTR

CREATE TABLE "DBA_BANKSYS"."ACCT_MSTR"(

"ACCT_NO" VARCHAR2(10),

"SF_NO" VARCHAR2(10),

"LF_NO" VARCHAR2(10),

"BRANCH_NO" VARCHAR2(10),

"INTRO_CUST_NO" VARCHAR2(10),

"INTRO_ACCT_NO" VARCHAR2(10),

"INTRO_SIGN" VARCHAR2(1),

"TYPE" VARCHAR2(2),

"OPR_MODE" VARCHAR2(2),

"CUR_ACCT_TYPE" VARCHAR2(4),

"TITLE" VARCHAR2(30),

"CORP_CUST_NO" VARCHAR2(10),

"APLNDT" DATE,

"OPNDT" DATE,

"VERI_EMP_NO" VARCHAR2(10),

"VERI_SIGN" VARCHAR2(1),

"MANAGER_SIGN" VARCHAR2(1),

"CURBAL" NUMBER(8, 2) DEFAULT 0,

"STATUS" VARCHAR2(1) DEFAULT 'A');

-- FD_MSTR

CREATE TABLE "DBA_BANKSYS"."FD_MSTR"(

"FD_SER_NO" VARCHAR2(10),

"SF_NO" VARCHAR2(10),

"BRANCH_NO" VARCHAR2(10),

"INTRO_CUST_NO" VARCHAR2(10),

"INTRO_ACCT_NO" VARCHAR2(10),

"INTRO_SIGN" VARCHAR2(1),

"ACCT_NO" VARCHAR2(10),

"TITLE" VARCHAR2(30),

"CORP_CUST_NO" VARCHAR2(10),

"CORP_CNST_TYPE" VARCHAR(4),

"VERI_EMP_NO" VARCHAR2(10),

"VERI_SIGN" VARCHAR2(1),

"MANAGER_SIGN" VARCHAR2(1));

-- FDSLAB_MSTR

CREATE TABLE "DBA_BANKSYS"."FDSLAB_MSTR"(

"FDSLAB_NO" NUMBER(2),

"MINPERIOD" NUMBER(5),

"MAXPERIOD" NUMBER(5),

"INTRATE" NUMBER(5,2));

-- FD_DTLS

CREATE TABLE "DBA_BANKSYS"."FD_DTLS"(

"FD_SER_NO" VARCHAR2(10),

"FD_NO" VARCHAR2(10),

"TYPE" VARCHAR2(1),

"PAYTO_ACCTNO" VARCHAR2(10),

"PERIOD" NUMBER(5),

"OPNDT" DATE,

"DUEDT" DATE,

"AMT" NUMBER(8,2),

"DUEAMT" NUMBER(8,2),

"INTRATE" NUMBER(3),

"STATUS" VARCHAR2(1) DEFAULT 'A',

"AUTO_RENEWAL" VARCHAR2(1));

-- ACCT_FD_CUST_DTLS

CREATE TABLE "DBA_BANKSYS"."ACCT_FD_CUST_DTLS"(

"ACCT_FD_NO" VARCHAR2(10),

"CUST_NO" VARCHAR2(10));

-- NOMINEE_MSTR

CREATE TABLE "DBA_BANKSYS"."NOMINEE_MSTR"(

"NOMINEE_NO" VARCHAR2(10),

"ACCT_FD_NO" VARCHAR2(10),

"NAME" VARCHAR2(75),

"DOB" DATE,

"RELATIONSHIP" VARCHAR2(25));

-- ADDR_DTLS

CREATE TABLE "DBA_BANKSYS"."ADDR_DTLS"(

"ADDR_NO" NUMBER(6),

"CODE_NO" VARCHAR2(10),

"ADDR_TYPE" VARCHAR2(1),

"ADDR1" VARCHAR2(50),

"ADDR2" VARCHAR2(50),

"CITY" VARCHAR2(25),

"STATE" VARCHAR2(25),

"PINCODE" VARCHAR2(6));

-- CNTC_DTLS

CREATE TABLE "DBA_BANKSYS"."CNTC_DTLS"(

"ADDR_NO" NUMBER(6),

"CODE_NO" VARCHAR2(10),

"CNTC_TYPE" VARCHAR2(1),

"CNTC_DATA" VARCHAR2(75));

-- TRANS_MSTR

CREATE TABLE "DBA_BANKSYS"."TRANS_MSTR"(

"TRANS_NO" VARCHAR2(10),

"ACCT_NO" VARCHAR2(10),

"DT" DATE,

"TYPE" VARCHAR2(1),

"PARTICULAR" VARCHAR2(30),

"DR_CR" VARCHAR2(1),

"AMT" NUMBER(8,2),

"BALANCE" NUMBER(8,2));

-- TRANS_DTLS

CREATE TABLE "DBA_BANKSYS"."TRANS_DTLS"(

"TRANS_NO" VARCHAR2(10),

"INST_NO" NUMBER(6),

"INST_DT" DATE,

"PAYTO" VARCHAR2(30),

"INST_CLR_DT" DATE,

"BANK_NAME" VARCHAR2(35),

"BRANCH_NAME" VARCHAR2(25),

"PAIDFROM" VARCHAR2(10));

-- TMP_FD_AMT

CREATE TABLE "DBA_BANKSYS"."TMP_FD_AMT"(

"FD_AMT" NUMBER(6));

-- Records for BRANCH_MSTR

INSERT INTO TMP_FD_AMT (FD_AMT) VALUES(5000);

INSERT INTO TMP_FD_AMT (FD_AMT) VALUES(10000);

INSERT INTO TMP_FD_AMT (FD_AMT) VALUES(15000);

INSERT INTO TMP_FD_AMT (FD_AMT) VALUES(20000);

INSERT INTO TMP_FD_AMT (FD_AMT) VALUES(25000);

INSERT INTO TMP_FD_AMT (FD_AMT) VALUES(30000);

INSERT INTO TMP_FD_AMT (FD_AMT) VALUES(4000);

INSERT INTO TMP_FD_AMT (FD_AMT) VALUES(50000);

-- Records for BRANCH_MSTR

INSERT INTO BRANCH_MSTR (BRANCH_NO, NAME) VALUES('B1', 'Vile Parle (HO)');

INSERT INTO BRANCH_MSTR (BRANCH_NO, NAME) VALUES('B2', 'Andheri');

INSERT INTO BRANCH_MSTR (BRANCH_NO, NAME) VALUES('B3', 'Churchgate');

INSERT INTO BRANCH_MSTR (BRANCH_NO, NAME) VALUES('B4', 'Mahim');

INSERT INTO BRANCH_MSTR (BRANCH_NO, NAME) VALUES('B5', 'Borivali');

INSERT INTO BRANCH_MSTR (BRANCH_NO, NAME) VALUES('B6', 'Darya Ganj');

-- Records for EMP_MSTR

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E1', 'B1', 'Ivan', 'Nelson', 'Bayross', 'Administration', 'Managing Director', NULL);

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E2', 'B2', 'Amit', null, 'Desai', 'Loans And Financing', 'Finance Manager', NULL);

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E3', 'B3', 'Maya', 'Mahima', 'Joshi', 'Client Servicing', 'Sales Manager', NULL);

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E4', 'B1', 'Peter', 'Iyer', 'Joseph', 'Loans And Financing', 'Clerk', 'E2');

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E5', 'B4', 'Mandhar', 'Dilip', 'Dalvi', 'Marketing', 'Marketing Manager', NULL);

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E6', 'B6', 'Sonal', 'Abdul', 'Khan', 'Administration', 'Admin. Executive', 'E1');

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E7', 'B4', 'Anil', 'Ashutosh', 'Kambli', 'Marketing', 'Sales Asst.', 'E5');

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E8', 'B3', 'Seema', 'P.', 'Apte', 'Client Servicing', 'Clerk', 'E3');

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E9', 'B2', 'Vikram', 'Vilas', 'Randive', 'Marketing', 'Sales Asst.', 'E5');

INSERT INTO EMP_MSTR (EMP_NO, BRANCH_NO, FNAME, MNAME, LNAME, DEPT, DESIG, MNGR_NO)

VALUES('E10', 'B6', 'Anjali', 'Sameer', 'Pathak', 'Administration', 'HR Manager', 'E1');

-- Records for CUST_MSTR

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C1', 'Ivan', 'Nelson', 'Bayross', '25-JUN-1952', 'Self Employed',

'D:/ClntPht/C1.gif', 'D:/ClntSgnt/C1.gif', 'Y', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C2', 'Chriselle', 'Ivan', 'Bayross', '29-OCT-1982', 'Service',

'D:/ClntPht/C2.gif', 'D:/ClntSgnt/C2.gif', 'N', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C3', 'Mamta', 'Arvind', 'Muzumdar', '28-AUG-1975', 'Service',

'D:/ClntPht/C3.gif', 'D:/ClntSgnt/C3.gif', 'Y', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C4', 'Chhaya', 'Sudhakar', 'Bankar', '06-OCT-1976', 'Service',

'D:/ClntPht/C4.gif', 'D:/ClntSgnt/C4.gif', 'Y', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C5', 'Ashwini', 'Dilip', 'Joshi', '20-NOV-1978', 'Business',

'D:/ClntPht/C5.gif', 'D:/ClntSgnt/C5.gif', 'Y', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C6', 'Hansel', 'I.', 'Colaco', '01-JAN-1982', 'Service',

'D:/ClntPht/C6.gif', 'D:/ClntSgnt/C6.gif', 'N', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C7', 'Anil', 'Arun', 'Dhone', '12-OCT-1983', 'Self Employed',

'D:/ClntPht/C7.gif', 'D:/ClntSgnt/C7.gif', 'N', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C8', 'Alex', 'Austin', 'Fernandes', '30-SEP-1962', 'Executive',

'D:/ClntPht/C8.gif', 'D:/ClntSgnt/C8.gif', 'Y', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C9', 'Ashwini', 'Shankar', 'Apte', '19-APR-1979', 'Service',

'D:/ClntPht/C9.gif', 'D:/ClntSgnt/C9.gif', 'Y', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('C10', 'Namita', 'S.', 'Kanade', '10-JUN-1978', 'Self Employed',

'D:/ClntPht/C10.gif', 'D:/ClntSgnt/C10.gif', 'Y', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('O11', null, null, null, '14-NOV-1997', 'Retail Business', null, null, 'Y', 'N');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('O12', null, null, null, '23-OCT-1992', 'Information Technology', null, null, 'Y', 'N');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('O13', null, null, null, '05-FEB-1989', 'Community Welfare', null, null, 'Y', 'N');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('O14', null, null, null, '24-MAY-1980', 'Retail Business', null, null, 'N', 'Y');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('O15', null, null, null, '02-APR-2000', 'Retail Business', null, null, 'Y', 'N');

INSERT INTO CUST_MSTR (CUST_NO, FNAME, MNAME, LNAME, DOB_INC, OCCUP, PHOTOGRAPH, SIGNATURE, PANCOPY, FORM60)

VALUES('O16', null, null, null, '13-JAN-2002', 'Marketing', null, null, 'Y', 'N');

-- Records for SPRT_DOC

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('0S', 'Individuals / Savings Bank Account', 'Driving Licence / Ration Card / Passport');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('0S', 'Individuals / Savings Bank Account', 'Birth Certificate / School Leaving Certificate');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('1C', 'Propriety / Sole Trading Concerns', 'Letter From The Propriety');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('2C', 'Partnership Concerns', 'Letter From The Partners');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('2C', 'Partnership Concerns', 'Partnership Deed / Registration Certificate');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('3C', 'Hindu Undivided Family Businesses', 'Letter From The Karta');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('3C', 'Hindu Undivided Family Businesses', 'List Of Members');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('4C', 'Limited Companies', 'Copy Of Board Of Directors'' Resolution For Opening The Account');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('4C', 'Limited Companies', 'Memorandum and Articles Of Association');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('4C', 'Limited Companies', 'Certificate Of Incorporation');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('4C', 'Limited Companies', 'Certificate Of Commencement Of Business / Registration Certificate');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('5C', 'Trust Accounts', 'Trust Deed');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('5C', 'Trust Accounts', 'Resolution Of Trustees');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('5C', 'Trust Accounts', 'List Of Trusties');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('6C', 'Clubs / Societies', 'Resolution');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('6C', 'Clubs / Societies', 'Constitution And Bye-laws');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('6C', 'Clubs / Societies', 'Certificate Of Registration');

INSERT INTO SPRT_DOC (ACCT_CODE, TYPE, DOCS)

VALUES('7C', 'Legislative Bodies', 'Letter From The Authority');

-- Records for ACCT_MSTR

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB1', 'SF-0001', 'NOV03-05', 'B1', 'C1', 'SB1', 'Y', 'SB', 'SI', '0S', null, null,

'05-NOV-2003', '05-NOV-2003', 'E1', 'Y', 'Y', 500, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('CA2', 'SF-0002', 'NOV03-10', 'B2', 'C1', 'SB1', 'Y', 'CA', 'JO', '1C', 'Uttam Stores', 'O11',

'07-NOV-2003', '10-NOV-2003', 'E1', 'Y', 'Y', 3000, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB3', 'SF-0003', 'NOV03-22', 'B3', 'C4', 'SB3', 'Y', 'SB', 'SI', '0S', null, null,

'20-NOV-2003', '22-NOV-2003', 'E4', 'Y', 'Y', 500, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('CA4', 'SF-0004', 'DEC03-05', 'B5', 'C4', 'SB3', 'Y', 'CA', 'AS', '4C', 'Sun''s Pvt. Ltd.', 'O12',

'02-DEC-2003', '05-DEC-2003', 'E4', 'Y', 'Y', 12000, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB5', 'SF-0005', 'DEC03-15', 'B6', 'C1', 'SB1', 'Y', 'SB', 'JO', '0S', null, null,

'14-DEC-2003', '15-DEC-2003', 'E1', 'Y', 'Y', 500, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB6', 'SF-0006', 'DEC03-27', 'B4', 'C5', 'SB6', 'Y', 'SB', 'ES', '0S', null, null,

'27-DEC-2003', '27-DEC-2003', 'E4', 'Y', 'Y', 500, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('CA7', 'SF-0007', 'JAN04-14', 'B1', 'C8', 'CA7', 'Y', 'CA', 'AS', '6C', 'Puru Hsg. Soc', 'O13',

'14-JAN-2004', '14-JAN-2004', 'E4', 'Y', 'Y', 22000, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB8', 'SF-0008', 'JAN04-29', 'B2', 'C9', 'SB8', 'Y', 'SB', 'SI', '0S', null, null,

'27-JAN-2004', '29-JAN-2004', 'E1', 'Y', 'Y', 500, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB9', 'SF-0009', 'FEB04-05', 'B4', 'C10', 'SB9', 'Y', 'SB', 'JO', '0S', null, null,

'05-FEB-2004', '05-FEB-2004', 'E4', 'Y', 'Y', 500, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('CA10', 'SF-0010', 'FEB04-19', 'B6', 'C10', 'SB9', 'Y', 'CA', 'AS', '3C', 'Ghar Karobar', 'O14',

'19-FEB-2004', '19-FEB-2004', 'E4', 'Y', 'Y', 32000, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB11', 'SF-0011', 'MAR04-10', 'B1', 'C1', 'SB1', 'Y', 'SB', 'SI', '0S', null, null,

'05-MAR-2004', '10-MAR-2004', 'E1', 'Y', 'Y', 500, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('CA12', 'SF-0012', 'MAR04-10', 'B2', 'C1', 'SB5', 'Y', 'CA', 'JO', '1C', 'Suresh Stores', 'O15',

'07-MAR-2004', '10-MAR-2004', 'E1', 'Y', 'Y', 5000, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB13', 'SF-0013', 'MAR04-22', 'B3', 'C4', 'SB3', 'Y', 'SB', 'SI', '0S', null, null,

'20-MAR-2004', '22-MAR-2004', 'E4', 'Y', 'Y', 500, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('CA14', 'SF-0014', 'APR04-05', 'B5', 'C4', 'SB3', 'Y', 'CA', 'AS', '4C', 'Moon''s Pvt. Ltd.', 'O16',

'02-APR-2004', '05-APR-2004', 'E4', 'Y', 'Y', 10000, 'A');

INSERT INTO ACCT_MSTR (ACCT_NO, SF_NO, LF_NO, BRANCH_NO, INTRO_CUST_NO, INTRO_ACCT_NO, INTRO_SIGN, TYPE, OPR_MODE,

CUR_ACCT_TYPE, TITLE, CORP_CUST_NO, APLNDT, OPNDT, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN, CURBAL, STATUS)

VALUES('SB15', 'SF-0015', 'APR04-15', 'B6', 'C1', 'SB1', 'Y', 'SB', 'JO', '0S', null, null,

'14-APR-2004', '15-APR-2004', 'E1', 'Y', 'Y', 500, 'A');

-- Records for FD_MSTR

INSERT INTO FD_MSTR (FD_SER_NO, SF_NO, BRANCH_NO, ACCT_NO, TITLE, CORP_CUST_NO, CORP_CNST_TYPE, INTRO_CUST_NO,

INTRO_ACCT_NO, INTRO_SIGN, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN)

VALUES ('FS1', 'SF-1001', 'B2', 'CA2', 'Uttam Stores', 'O11', '1C', null, null, 'N', 'E1', 'Y', 'Y');

INSERT INTO FD_MSTR (FD_SER_NO, SF_NO, BRANCH_NO, ACCT_NO, TITLE, CORP_CUST_NO, CORP_CNST_TYPE, INTRO_CUST_NO,

INTRO_ACCT_NO, INTRO_SIGN, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN)

VALUES ('FS2', 'SF-1002', 'B5', 'CA4', 'Sun''s Pvt. Ltd.', 'C12', '4C', null, null, 'N', 'E1', 'Y', 'Y');

INSERT INTO FD_MSTR (FD_SER_NO, SF_NO, BRANCH_NO, ACCT_NO, TITLE, CORP_CUST_NO, CORP_CNST_TYPE, INTRO_CUST_NO,

INTRO_ACCT_NO, INTRO_SIGN, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN)

VALUES ('FS3', 'SF-1003', 'B1', 'CA7', 'Puru Hsg. Soc', 'O13', '6C', null, null, 'N', 'E4', 'Y', 'Y');

INSERT INTO FD_MSTR (FD_SER_NO, SF_NO, BRANCH_NO, ACCT_NO, TITLE, CORP_CUST_NO, CORP_CNST_TYPE, INTRO_CUST_NO,

INTRO_ACCT_NO, INTRO_SIGN, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN)

VALUES ('FS4', 'SF-1004', 'B6', 'CA10', 'Ghar Karobar', 'O14', '3C', null, null, 'N', 'E4', 'Y', 'Y');

INSERT INTO FD_MSTR (FD_SER_NO, SF_NO, BRANCH_NO, ACCT_NO, TITLE, CORP_CUST_NO, CORP_CNST_TYPE, INTRO_CUST_NO,

INTRO_ACCT_NO, INTRO_SIGN, VERI_EMP_NO, VERI_SIGN, MANAGER_SIGN)

VALUES ('FS5', 'SF-1005', 'B4', null, null, null, '0S', 'C7', 'SB6', 'Y', 'E4', 'Y', 'Y');

-- Record for FDSLAB_MSTR

INSERT INTO FDSLAB_MSTR (FDSLAB_NO, MINPERIOD, MAXPERIOD, INTRATE) VALUES(1, 1, 30, 5);

INSERT INTO FDSLAB_MSTR (FDSLAB_NO, MINPERIOD, MAXPERIOD, INTRATE) VALUES(2, 31, 92, 5.5);

INSERT INTO FDSLAB_MSTR (FDSLAB_NO, MINPERIOD, MAXPERIOD, INTRATE) VALUES(3, 93, 183, 6);

INSERT INTO FDSLAB_MSTR (FDSLAB_NO, MINPERIOD, MAXPERIOD, INTRATE) VALUES(4, 184, 365, 6.5);

INSERT INTO FDSLAB_MSTR (FDSLAB_NO, MINPERIOD, MAXPERIOD, INTRATE) VALUES(5, 366, 731, 7.5);

INSERT INTO FDSLAB_MSTR (FDSLAB_NO, MINPERIOD, MAXPERIOD, INTRATE) VALUES(6, 732, 1097, 8.5);

INSERT INTO FDSLAB_MSTR (FDSLAB_NO, MINPERIOD, MAXPERIOD, INTRATE) VALUES(7, 1098, 1829, 10);

-- Record for FD_DTLS

INSERT INTO FD_DTLS (FD_SER_NO, FD_NO, TYPE, PAYTO_ACCTNO, PERIOD, OPNDT, DUEDT, AMT, DUEAMT,

INTRATE, STATUS, AUTO_RENEWAL)

VALUES('FS1', 'F1', 'S', 'CA2', 365, '02-JAN-2004', '01-JAN-2005', 15000, 16050.00, 6.5, 'A', 'Y');

INSERT INTO FD_DTLS (FD_SER_NO, FD_NO, TYPE, PAYTO_ACCTNO, PERIOD, OPNDT, DUEDT, AMT, DUEAMT,

INTRATE, STATUS, AUTO_RENEWAL)

VALUES('FS1', 'F2', 'S', 'CA2', 365, '02-JAN-2004', '01-JAN-2005', 5000, 5350.00, 6.5, 'A', 'N');

INSERT INTO FD_DTLS (FD_SER_NO, FD_NO, TYPE, PAYTO_ACCTNO, PERIOD, OPNDT, DUEDT, AMT, DUEAMT,

INTRATE, STATUS, AUTO_RENEWAL)

VALUES('FS2', 'F3', 'S', 'CA4', 366, '25-MAR-2004', '25-MAR-2005', 10000, 10802.19, 7.5, 'A', 'Y');

INSERT INTO FD_DTLS (FD_SER_NO, FD_NO, TYPE, PAYTO_ACCTNO, PERIOD, OPNDT, DUEDT, AMT, DUEAMT,

INTRATE, STATUS, AUTO_RENEWAL)

VALUES('FS2', 'F4', 'S', 'CA4', 366, '15-APR-2004', '15-APR-2005', 10000, 10802.19, 7.5, 'A', 'Y');

INSERT INTO FD_DTLS (FD_SER_NO, FD_NO, TYPE, PAYTO_ACCTNO, PERIOD, OPNDT, DUEDT, AMT, DUEAMT,

INTRATE, STATUS, AUTO_RENEWAL)

VALUES('FS3', 'F5', 'S', 'CA7', 183, '24-APR-2004', '24-OCT-2006', 2000, 2060.16, 6, 'A', 'Y');

INSERT INTO FD_DTLS (FD_SER_NO, FD_NO, TYPE, PAYTO_ACCTNO, PERIOD, OPNDT, DUEDT, AMT, DUEAMT,

INTRATE, STATUS, AUTO_RENEWAL)

VALUES('FS4', 'F6', 'S', 'CA10', 732, '19-MAY-2004', '20-MAY-2006', 5000, 5902.47, 8.5, 'A', 'Y');

INSERT INTO FD_DTLS (FD_SER_NO, FD_NO, TYPE, PAYTO_ACCTNO, PERIOD, OPNDT, DUEDT, AMT, DUEAMT,

INTRATE, STATUS, AUTO_RENEWAL)

VALUES('FS5', 'F7', 'S', 'SB6', 366, '27-MAY-2004', '27-MAY-2005', 15000, 16203.30, 7.5, 'A', 'N');

-- Record for ACCT_FD_CUST_DTLS

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB1', 'C1');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA2', 'C2');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA2', 'C3');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB3', 'C4');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA4', 'C4');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA4', 'C5');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB5', 'C1');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB5', 'C4');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB6', 'C5');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB6', 'C7');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA7', 'C6');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA7', 'C8');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB8', 'C9');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB9', 'C3');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB9', 'C10');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA10', 'C10');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA10', 'C9');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB11', 'C1');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA12', 'C2');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA12', 'C3');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB13', 'C4');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA14', 'C4');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('CA14', 'C5');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB15', 'C1');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('SB15', 'C4');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS1', 'C2');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS1', 'C3');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS2', 'C4');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS2', 'C5');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS3', 'C6');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS3', 'C8');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS4', 'C10');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS4', 'C9');

INSERT INTO ACCT_FD_CUST_DTLS (ACCT_FD_NO, CUST_NO) VALUES('FS5', 'C5');

-- Record for NOMINEE_MSTR

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N1', 'CA2', 'Joseph Martin Dias', '17-SEP-1984', 'Colleague');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N2', 'CA2', 'Nilesh Sawant', '25-AUG-1987', 'Colleague');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N3', 'SB1', 'Chriselle Ivan Bayross', '25-JUN-1952', 'Daughter');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N4', 'SB3', 'Mamta Arvind Muzumdar', '28-AUG-1975', 'Friend');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N5', 'SB6', 'Preeti Suresh Shah', '12-FEB-1978', 'Friend');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N6', 'SB8', 'Rohit Rajan Sahakarkar', '30-MAY-1985', 'Relative');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N7', 'CA10', 'Namita S. Kanade', '10-JUN-1978', 'Niece');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N8', 'FS1', 'Rohit Rajan Sahakarkar', '30-MAY-1985', 'Relative');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N9', 'FS2', 'Joseph Martin Dias', '17-SEP-1984', 'Colleague');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N10', 'FS2', 'Nilesh Sawant', '25-AUG-1987', 'Colleague');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N11', 'FS3', 'Chriselle Ivan Bayross', '25-JUN-1952', 'Colleague');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N12', 'FS3', 'Mamta Arvind Muzumdar', '28-AUG-1975', 'Friend');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N13', 'FS4', 'Namita S. Kanade', '10-JUN-1978', 'Relative');

INSERT INTO NOMINEE_MSTR (NOMINEE_NO, ACCT_FD_NO, NAME, DOB, RELATIONSHIP)

VALUES('N14', 'FS5', 'Pramila P. Pius', '10-OCT-1985', 'Niece');

-- Record for ADDR_DTLS

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(1, 'B1', 'H', 'A/5, Jay Chambers,', 'Service Road, Vile Parle (East),',

'Mumbai', 'Maharashtra', '400057');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(2, 'B2', 'B', 'BSES Chambers, 10th floor,',

'Near Rly. Station, Andheri (West),', 'Mumbai', 'Maharashtra', '400058');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(3, 'B3', 'B', 'Prabhat Complex, No. 5 / 6,', 'Opp. Air India Bldg., Churchgate,',

'Mumbai', 'Maharashtra', '400004');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(4, 'B4', 'B', '23/A, Swarna Bldg., Smt. Rai Marg,',

'Eastern Express Highway, Kurla (East),', 'Mumbai', 'Maharashtra', '400045');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(5, 'B5', 'B', 'Vikas Centre, Shop 37, Near National Park,',

'Western Express Highway, Borivali (East),', 'Mumbai', 'Maharashtra', '400078');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(6, 'B6', 'B', '24/A, Mahima Plaza, First Floor,', 'Darya Ganj,',

'New Delhi', 'Delhi', '110004');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(7, 'E1', 'N', 'F-12, Diamond Palace, West Avenue,',

'North Avenue, Santacruz (West),', 'Mumbai', 'Maharashtra', '400056');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(8, 'E2', 'C', 'Desai House, Plot No. 25, P.G. Marg,',

'Near Malad Rly. Stat., Malad (West),', 'Mumbai', 'Maharashtra', '400078');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(9, 'E3', 'N', 'Room No. 56, 3rd Floor, Swamibhavan,',

'J. P. Road Junction, Andheri (East),', 'Mumbai', 'Maharashtra', '400059');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(10, 'E4', 'C', '301, Thomas Palace, Opp. Indu Child Care,',

'Yadnik Nagar, Andheri (West),', 'Mumbai', 'Maharashtra', '400058');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(11, 'E5', 'C', '456/A, Bldg. No. 4, Vahatuk Nagar,',

'Amboli, Andheri (West),', 'Mumbai', 'Maharashtra', '400058');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(12, 'E6', 'N', '201, Meena Towers, Nr. Sun Gas Agency,',

'S. V. Rd., Goregoan (West),', 'Mumbai', 'Maharashtra', '400076');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(13, 'E7', 'N', 'Patel Chawl, Rm. No. 15, B. P. Lal Marg,',

'Mahim (West),', 'Mumbai', 'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(14, 'E8', 'C', 'A - 10, Neelam, L. J. Road,', 'Mahim (East),',

'Mumbai', 'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(15, 'E9', 'N', '1/12 Bal Govindas Society, M. B. Raut Rd.,',

'Dadar (East),', 'Mumbai', 'Maharashtra', '400028');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(16, 'E10', 'C', 'Pathak Nagar, Cadal Road,', 'Mahim (West),', 'New Delhi',

'Delhi', '110016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(17, 'C1', 'C', 'F-12, Diamond Palace, West Avenue,',

'North Avenue, Santacruz (West),', 'Mumbai', 'Maharashtra', '400056');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(18, 'C2', 'C', 'F-12, Silver Stream,', 'Santacruz (East),', 'Mumbai',

'Maharashtra', '400056');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(19, 'C3', 'C', 'Magesh Prasad,', 'Saraswati Baug, Jogeshwari(E),',

'Mumbai', 'Maharashtra', '400060');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(20, 'C4', 'C', '4, Sampada,', 'Kataria Road, Mahim,', 'Mumbai',

'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(21, 'C5', 'C', '104, Vikram Apts. Bhagat Lane,', 'Shivaji Park, Mahim,',

'Mumbai', 'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(22, 'C6', 'C', '12, Radha Kunj, N.C Kelkar Road,', 'Dadar,', 'Mumbai',

'Maharashtra', '400028');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(23, 'C7', 'C', 'A/14, Shanti Society, Mogal Lane,', 'Mahim,', 'Mumbai',

'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(24, 'C8', 'C', '5, Vagdevi, Senapati Bapat Rd.,', 'Dadar,', 'Mumbai',

'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(25, 'C9', 'C', 'A-10 Nutan Vaishali,', 'Shivaji Park, Mahim,', 'Mumbai',

'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(26, 'C10', 'C', 'B-10, Makarand Society,', 'Cadal Road, Mahim,', 'Mumbai',

'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(27, 'N1', 'C', '307/E, Meena Mansion,', 'R. S. Road, Andheri (West),',

'Mumbai', 'Maharashtra', '400058');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(28, 'N2', 'C', 'Smt. Veenu Chawl, Sawant Colony Rd.,',

'Opp. Veer Road, Matunga (West),', 'Mumbai', 'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(29, 'N3', 'C', 'F-12, Silver Stream,', 'Santacruz (East),', 'Mumbai',

'Maharashtra', '400056');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(30, 'N4', 'C', 'Magesh Prasad,', 'Saraswati Baug, Jogeshwari(E),',

'Mumbai', 'Maharashtra', '400060');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(31, 'N5', 'C', 'Rita Apartment, Room No. 46, 2nd Floor,',

'J. P. Road, Andheri (East),', 'Mumbai', 'Maharashtra', '400067');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(32, 'N6', 'N', '106/A, Sunrise Apmt., Opp. Vahatuk Nagar,',

'Kevni-Pada, Jogeshwari (West),', 'Mumbai', 'Maharashtra', '400102');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(33, 'N7', 'C', 'Pathak Nagar, Cadal Road,', 'Mahim (West),', 'Mumbai',

'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(34, 'O11', 'H', 'Shop No. 4, Simon Streams,',

'V. P. Road, Andheri (West),', 'Mumbai', 'Maharashtra', '400058');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(35, 'O12', 'H', '230-E, Patel Chambers,', 'Service Road, Vile Parle (East),',

'Mumbai', 'Maharashtra', '400057');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(36, 'O13', 'H', 'G-2, Puru Hsg. Society,', 'Senapati Bapat Rd., Dadar,',

'Mumbai', 'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(37, 'O14', 'H', 'B-10, Makarand Society,', 'Cadal Road, Mahim,',

'Mumbai', 'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(38, 'N8', 'N', '106/A, Sunrise Apmt., Opp. Vahatuk Nagar,',

'Kevni-Pada, Jogeshwari (West),', 'Mumbai', 'Maharashtra', '400102');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(39, 'N9', 'C', '307/E, Meena Mansion,', 'R. S. Road, Andheri (West),',

'Mumbai', 'Maharashtra', '400058');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(40, 'N10', 'C', 'Smt. Veenu Chawl, Sawant Colony Rd.,',

'Opp. Veer Road, Matunga (West),', 'Mumbai', 'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(41, 'N11', 'C', 'F-12, Silver Stream,', 'Santacruz (East),', 'Mumbai',

'Maharashtra', '400056');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(42, 'N12', 'C', 'Magesh Prasad', 'Saraswati Baug, Jogeshwari(E),',

'Mumbai', 'Maharashtra', '400060');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(43, 'N13', 'C', 'Pathak Nagar, Cadal Road,', 'Mahim (West),', 'Mumbai',

'Maharashtra', '400016');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(44, 'N14', 'C', '405, Vahatuk Nagar, Kevni-Pada,', 'Jogeshwari (West),',

'Mumbai', 'Maharashtra', '400102');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(45, 'C6', 'N', '203/A, Prachi Apmt.,', 'Andheri (East),', 'Mumbai',

'Maharashtra', '400058');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(46, 'O15', 'H', 'Shop No. 4, Sai Compound,',

'Service Road, Vile Parle (East),', 'Mumbai', 'Maharashtra', '400057');

INSERT INTO ADDR_DTLS (ADDR_NO, CODE_NO, ADDR_TYPE, ADDR1, ADDR2, CITY, STATE, PINCODE)

VALUES(47, 'O15', 'H', 'G-4, Sagar Chambers,', 'G. P. Road, Andheri (West),',

'Mumbai', 'Maharashtra', '400058');

-- Record for CNTC_DTLS

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(1, 'B1', 'O', '26124571');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(1, 'B1', 'F', '26124533');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(1, 'B1', 'E', 'admin_vileparle@bom2.vsnl.in');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(2, 'B2', 'O', '26790014');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(2, 'B2', 'E', 'admin_andheri@bom2.vsnl.in');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(3, 'B3', 'O', '23457855');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(3, 'B3', 'E', 'admin_churchgate@bom2.vsnl.in');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(4, 'B4', 'O', '25545455');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(4, 'B4', 'E', 'admin_sion@bom2.vsnl.in');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(5, 'B5', 'O', '28175454');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(5, 'B5', 'E', 'admin_borivali@bom2.vsnl.in');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(6, 'B6', 'O', '24304545');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(6, 'B6', 'E', 'admin_matunga@bom2.vsnl.in');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(8, 'E2', 'R', '28883779');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(9, 'E3', 'R', '28377634');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(10, 'E4', 'R', '26323560');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(11, 'E5', 'R', '26793231');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(12, 'E6', 'R', '28085654');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(13, 'E7', 'R', '24442342');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(14, 'E8', 'R', '24365672');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(15, 'E9', 'R', '24327349');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(16, 'E10', 'R', '24302579');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(17, 'C1', 'R', '26405853');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(17, 'C1', 'O', '26134553');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(17, 'C1', 'O', '26134571');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(17, 'C1', 'M', '9820178955');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(18, 'C2', 'R', '26045754');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(18, 'C2', 'O', '26134571');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(19, 'C3', 'R', '28324567');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(19, 'C3', 'O', '26197654');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(20, 'C4', 'R', '24449852');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(20, 'C4', 'O', '28741370');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(21, 'C5', 'R', '24302934');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(21, 'C5', 'O', '22819964');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(22, 'C6', 'R', '24217592');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(23, 'C7', 'R', '24372247');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(24, 'C8', 'O', '26480903');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(25, 'C9', 'R', '24313408');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(25, 'C9', 'M', '9821176651');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(26, 'C10', 'R', '24362680');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(26, 'C10', 'O', '28973355');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(26, 'C10', 'M', '9820484648');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(27, 'N1', 'R', '26762154');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(28, 'N2', 'R', '24307887');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(29, 'N3', 'R', '260455754');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(30, 'N4', 'R', '28645489');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(31, 'N5', 'R', '30903564');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(32, 'N6', 'R', '26793771');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(33, 'N7', 'R', '24304455');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(34, 'O11', 'O', '26790055');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(34, 'O11', 'F', '26784409');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(35, 'O12', 'O', '26120455');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(35, 'O12', 'O', '26120456');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(35, 'O12', 'F', '26121450');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(35, 'O12', 'E', 'admin@sunpvtltd.com');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(35, 'O12', 'W', 'www.sunpvtltd.com');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(36, 'O13', 'O', '24301090');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(36, 'O13', 'O', '24301196');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(37, 'O14', 'O', '24321122');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(38, 'N8', 'R', '26793771');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(39, 'N9', 'R', '26762154');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(40, 'N10', 'R', '24307887');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(41, 'N11', 'R', '26045754');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(42, 'N12', 'R', '28645489');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(43, 'N13', 'R', '24304455');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(44, 'N14', 'R', '26790180');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(44, 'N14', 'R', '26771275');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(45, 'C6', 'R', '28274784');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(46, 'O15', 'O', '26170055');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(46, 'O15', 'F', '26174409');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(47, 'O16', 'O', '26790455');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(47, 'O16', 'F', '26781450');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(47, 'O16', 'E', 'admin@moonmltg.com');

INSERT INTO CNTC_DTLS (ADDR_NO, CODE_NO, CNTC_TYPE, CNTC_DATA) VALUES(47, 'O16', 'W', 'www.moonmltg.com');

-- Record for TRANS_MSTR

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T1', 'SB1', '05-NOV-2003', 'C', 'Initial Payment', 'D', 500, 500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T2', 'CA2', '10-NOV-2003', 'C', 'Initial Payment', 'D', 2000, 2000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T3', 'CA2', '13-NOV-2003', 'C', 'Self', 'D', 3000, 5000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T4', 'SB3', '22-NOV-2003', 'C', 'Initial Payment', 'D', 500, 500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T5', 'CA2', '10-DEC-2003', 'C', 'Self', 'W', 2000, 3000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T6', 'CA4', '05-DEC-2003', 'B', 'Initial Payment', 'D', 2000, 2000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T7', 'SB5', '15-DEC-2003', 'B', 'Initial Payment', 'D', 500, 500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T8', 'SB6', '27-DEC-2003', 'C', 'Initial Payment', 'D', 500, 500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T9', 'CA7', '14-JAN-2004', 'B', 'Initial Payment', 'D', 2000, 2000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T10', 'SB8', '29-JAN-2004', 'C', 'Initial Payment', 'D', 500, 500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T11', 'SB9', '05-FEB-2004', 'C', 'Initial Payment', 'D', 500, 500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T12', 'SB9', '15-FEB-2004', 'B', 'CLR-204907', 'D', 3000, 3500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T13', 'SB9', '17-FEB-2004', 'C', 'Self', 'W', 2500, 1000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T14', 'CA10', '19-FEB-2004', 'B', 'Initial Payment', 'D', 2000, 2000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T15', 'SB9', '05-APR-2004', 'B', 'CLR-204908', 'D', 3000, 4000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T16', 'SB9', '27-APR-2004', 'C', 'Self', 'W', 2500, 1500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T17', 'SB1', '05-NOV-2003', 'C', 'Initial Payment', 'D', 500, 500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T18', 'CA2', '10-NOv-2003', 'C', 'Initial Payment', 'D', 2000, 2000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T19', 'SB3', '22-NOV-2003', 'C', 'Initial Payment', 'D', 500, 500);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T20', 'CA4', '05-DEC-2003', 'B', 'Initial Payment', 'D', 2000, 2000);

INSERT INTO TRANS_MSTR (TRANS_NO, ACCT_NO, DT, TYPE, PARTICULAR, DR_CR, AMT, BALANCE)

VALUES('T21', 'SB5', '15-DEC-2003', 'B', 'Initial Payment', 'D', 500, 500);

-- Record for TRANS_DTLS

INSERT INTO TRANS_DTLS (TRANS_NO, INST_NO, INST_DT, PAYTO, INST_CLR_DT, BANK_NAME, BRANCH_NAME, PAIDFROM)

VALUES('T6', 098324, '02-DEC-2003', 'Self', '05-DEC-2003', 'HDFC', 'Vile Parle (East)', '2982');

INSERT INTO TRANS_DTLS (TRANS_NO, INST_NO, INST_DT, PAYTO, INST_CLR_DT, BANK_NAME, BRANCH_NAME, PAIDFROM)

VALUES('T7', 232324, '14-DEC-2003', 'Self', '15-DEC-2003', 'India Bank', 'Andheri (West)', '30434');

INSERT INTO TRANS_DTLS (TRANS_NO, INST_NO, INST_DT, PAYTO, INST_CLR_DT, BANK_NAME, BRANCH_NAME, PAIDFROM)

VALUES('T9', 434560, '14-JAN-2004', 'Self', '14-JAN-2004', 'ICICI Bank', 'Bandra (West)', '4882');

INSERT INTO TRANS_DTLS (TRANS_NO, INST_NO, INST_DT, PAYTO, INST_CLR_DT, BANK_NAME, BRANCH_NAME, PAIDFROM)

VALUES('T12', 204907, '14-FEB-2004', 'Self', '15-FEB-2004', 'Memon Co-operative Bank', 'Jogeshwari (West)', '1767');

INSERT INTO TRANS_DTLS (TRANS_NO, INST_NO, INST_DT, PAYTO, INST_CLR_DT, BANK_NAME, BRANCH_NAME, PAIDFROM)

VALUES('T14', 100907, '19-FEB-2004', 'Self', '19-FEB-2004', 'Memon Co-operative Bank', 'Jogeshwari (West)', '2001');

INSERT INTO TRANS_DTLS (TRANS_NO, INST_NO, INST_DT, PAYTO, INST_CLR_DT, BANK_NAME, BRANCH_NAME, PAIDFROM)

VALUES('T15', 204908, '01-APR-2004', 'Self', '05-APR-2004', 'Memon Co-operative Bank', 'Jogeshwari (West)', '1767');

INSERT INTO TRANS_DTLS (TRANS_NO, INST_NO, INST_DT, PAYTO, INST_CLR_DT, BANK_NAME, BRANCH_NAME, PAIDFROM)

VALUES('T20', 098324, '02-DEC-2003', 'Self', '05-DEC-2003', 'HDFC', 'Vile Parle (East)', '2982');

INSERT INTO TRANS_DTLS (TRANS_NO, INST_NO, INST_DT, PAYTO, INST_CLR_DT, BANK_NAME, BRANCH_NAME, PAIDFROM)

VALUES('T21', 232324, '14-DEC-2003', 'Self', '15-DEC-2003', 'India Bank', 'Andheri (West)', '30434');

COMMIT;

DROP TABLE TMP_FD_AMT;

DROP TABLE TRANS_DTLS;

DROP TABLE TRANS_MSTR;

DROP TABLE CNTC_DTLS;

DROP TABLE ADDR_DTLS;

DROP TABLE ACCT_FD_CUST_DTLS;

DROP TABLE NOMINEE_MSTR;

DROP TABLE FD_DTLS;

DROP TABLE FDSLAB_MSTR;

DROP TABLE FD_MSTR;

DROP TABLE ACCT_MSTR;

DROP TABLE SPRT_DOC;

DROP TABLE CUST_MSTR;

DROP TABLE EMP_MSTR;

DROP TABLE BRANCH_MSTR;

-- BRANCH_MSTR

CREATE TABLE "DBA_BANKSYS"."BRANCH_MSTR"(

"BRANCH_NO" VARCHAR2(10),

"NAME" VARCHAR2(25),

CONSTRAINT PK_BRANCHMSTR_BRANCHNO PRIMARY KEY(BRANCH_NO),

CONSTRAINT CHK_BRANCHMSTR_BRANCHNO CHECK(BRANCH_NO LIKE 'B%'));

-- EMP_MSTR

CREATE TABLE "DBA_BANKSYS"."EMP_MSTR"(

"EMP_NO" VARCHAR2(10),

"BRANCH_NO" VARCHAR2(10),

"FNAME" VARCHAR2(25),

"MNAME" VARCHAR2(25),

"LNAME" VARCHAR2(25),

"DEPT" VARCHAR2(30),

"DESIG" VARCHAR2(30),

"MNGR_NO" VARCHAR2(10),

CONSTRAINT PK_EMPMSTR_EMPNO PRIMARY KEY(EMP_NO),

CONSTRAINT CHK_EMPMSTR_EMPNO CHECK(EMP_NO LIKE 'E%'),

CONSTRAINT FK_EMPMSTR_BRANCHNO FOREIGN KEY(BRANCH_NO)

REFERENCES BRANCH_MSTR(BRANCH_NO),

CONSTRAINT FK_EMPMSTR_MNGRNO FOREIGN KEY(MNGR_NO)

REFERENCES EMP_MSTR(EMP_NO));

-- CUST_MSTR

CREATE TABLE "DBA_BANKSYS"."CUST_MSTR"(

"CUST_NO" VARCHAR2(10),

"FNAME" VARCHAR2(25),

"MNAME" VARCHAR2(25),

"LNAME" VARCHAR2(25),

"DOB_INC" DATE NOT NULL,

"OCCUP" VARCHAR2(25),

"PHOTOGRAPH" VARCHAR2(25),

"SIGNATURE" VARCHAR2(25),

"PANCOPY" VARCHAR2(1),

"FORM60" VARCHAR2(1),

CONSTRAINT PK_CUSTMSTR_CUSTNO PRIMARY KEY(CUST_NO),

CONSTRAINT CHK_CUSTMSTR_CUSTNO

CHECK(CUST_NO LIKE 'C%' OR CUST_NO LIKE 'O%'),

CONSTRAINT CHK_CUSTMSTR_PANCOPY CHECK(PANCOPY IN('Y', 'N')),

CONSTRAINT CHK_CUSTMSTR_FORM60 CHECK(FORM60 IN('Y', 'N')));

-- SPRT_DOC

CREATE TABLE "DBA_BANKSYS"."SPRT_DOC"(

"ACCT_CODE" VARCHAR2(4),

"TYPE" VARCHAR2(40),

"DOCS" VARCHAR2(75));

-- ACCT_MSTR

CREATE TABLE "DBA_BANKSYS"."ACCT_MSTR"(

"ACCT_NO" VARCHAR2(10),

"SF_NO" VARCHAR2(10),

"LF_NO" VARCHAR2(10),

"BRANCH_NO" VARCHAR2(10),

"INTRO_CUST_NO" VARCHAR2(10),

"INTRO_ACCT_NO" VARCHAR2(10),

"INTRO_SIGN" VARCHAR2(1),

"TYPE" VARCHAR2(2),

"OPR_MODE" VARCHAR2(2),

"CUR_ACCT_TYPE" VARCHAR2(4),

"TITLE" VARCHAR2(30),

"CORP_CUST_NO" VARCHAR2(10),

"APLNDT" DATE,

"OPNDT" DATE,

"VERI_EMP_NO" VARCHAR2(10),

"VERI_SIGN" VARCHAR2(1),

"MANAGER_SIGN" VARCHAR2(1),

"CURBAL" NUMBER(8, 2) DEFAULT 0,

"STATUS" VARCHAR2(1) DEFAULT 'A',

CONSTRAINT PK_ACCTMSTR_ACCTNO PRIMARY KEY(ACCT_NO),

CONSTRAINT FK_ACCTMSTR_BRANCHNO FOREIGN KEY(BRANCH_NO)

REFERENCES BRANCH_MSTR(BRANCH_NO),

CONSTRAINT FK_ACCTMSTR_INTROCUSTNO FOREIGN KEY(INTRO_CUST_NO)

REFERENCES CUST_MSTR(CUST_NO),

CONSTRAINT FK_ACCTMSTR_INTROACCTNO FOREIGN KEY(INTRO_ACCT_NO)

REFERENCES ACCT_MSTR(ACCT_NO),

CONSTRAINT CHK_ACCTMSTR_INTROSIGN CHECK(INTRO_SIGN IN('Y', 'N')),

CONSTRAINT CHK_ACCTMSTR_TYPE CHECK(TYPE IN('SB', 'CA')),

CONSTRAINT CHK_ACCTMSTR_OPRMODE CHECK(OPR_MODE IN('SI', 'ES', 'JO', 'AS')),

CONSTRAINT CHK_ACCTMSTR_CURACCTTYPE

CHECK(CUR_ACCT_TYPE IN('0S', '1C', '2C', '3C', '4C', '5C', '6C', '7C')),

CONSTRAINT CHK_ACCTMSTR_CORPCUSTNO CHECK(CORP_CUST_NO LIKE 'O%'),

CONSTRAINT FK_ACCTMSTR_VERIEMPNO FOREIGN KEY(VERI_EMP_NO)

REFERENCES EMP_MSTR(EMP_NO),

CONSTRAINT CHK_ACCTMSTR_VERISIGN CHECK(VERI_SIGN IN('Y', 'N')),

CONSTRAINT CHK_ACCTMSTR_MANAGERSIGN CHECK(MANAGER_SIGN IN('Y', 'N')),

CONSTRAINT CHK_ACCTMSTR_STATUS CHECK(STATUS IN('A', 'S', 'T')));

-- FD_MSTR

CREATE TABLE "DBA_BANKSYS"."FD_MSTR"(

"FD_SER_NO" VARCHAR2(10),

"SF_NO" VARCHAR2(10),

"BRANCH_NO" VARCHAR2(10),

"INTRO_CUST_NO" VARCHAR2(10),

"INTRO_ACCT_NO" VARCHAR2(10),

"INTRO_SIGN" VARCHAR2(1),

"ACCT_NO" VARCHAR2(10),

"TITLE" VARCHAR2(30),

"CORP_CUST_NO" VARCHAR2(10),

"CORP_CNST_TYPE" VARCHAR(4),

"VERI_EMP_NO" VARCHAR2(10),

"VERI_SIGN" VARCHAR2(1),

"MANAGER_SIGN" VARCHAR2(1),

CONSTRAINT PK_FDMSTR_FDSERNO PRIMARY KEY(FD_SER_NO),

CONSTRAINT FK_FDMSTR_BRANCHNO FOREIGN KEY(BRANCH_NO)

REFERENCES BRANCH_MSTR(BRANCH_NO),

CONSTRAINT FK_FDMSTR_INTROCUSTNO FOREIGN KEY(INTRO_CUST_NO)

REFERENCES CUST_MSTR(CUST_NO),

CONSTRAINT FK_FDMSTR_INTROACCTNO FOREIGN KEY(INTRO_ACCT_NO)

REFERENCES ACCT_MSTR(ACCT_NO),

CONSTRAINT CHK_FDMSTR_INTROSIGN CHECK(INTRO_SIGN IN('Y', 'N')),

CONSTRAINT CHK_FDMSTR_ACCTNO CHECK(ACCT_NO LIKE 'CA%' OR ACCT_NO LIKE 'SB%'),

CONSTRAINT CHK_FDMSTR_CORPCUSTNO CHECK(CORP_CUST_NO LIKE 'O%'),

CONSTRAINT CHK_FDMSTR_CORPCNSTTYPE

CHECK(CORP_CNST_TYPE IN('0S', '1C', '2C', '3C', '4C', '5C', '6C', '7C')),

CONSTRAINT FK_FDMSTR_VERIEMPNO FOREIGN KEY(VERI_EMP_NO)

REFERENCES EMP_MSTR(EMP_NO),

CONSTRAINT CHK_FDMSTR_VERISIGN CHECK(VERI_SIGN IN('Y', 'N')),

CONSTRAINT CHK_FDMSTR_MANAGERSIGN CHECK(MANAGER_SIGN IN('Y', 'N')));

-- FDSLAB_MSTR

CREATE TABLE "DBA_BANKSYS"."FDSLAB_MSTR"(

"FDSLAB_NO" NUMBER(2),

"MINPERIOD" NUMBER(5),

"MAXPERIOD" NUMBER(5),

"INTRATE" NUMBER(5,2),

CONSTRAINT PK_FDSLABMSTR_FDSLABNO PRIMARY KEY(FDSLAB_NO));

-- FD_DTLS

CREATE TABLE "DBA_BANKSYS"."FD_DTLS"(

"FD_SER_NO" VARCHAR2(10),

"FD_NO" VARCHAR2(10),

"TYPE" VARCHAR2(1),

"PAYTO_ACCTNO" VARCHAR2(10),

"PERIOD" NUMBER(5),

"OPNDT" DATE,

"DUEDT" DATE,

"AMT" NUMBER(8,2),

"DUEAMT" NUMBER(8,2),

"INTRATE" NUMBER(3),

"STATUS" VARCHAR2(1) DEFAULT 'A',

"AUTO_RENEWAL" VARCHAR2(1),

CONSTRAINT PK_FDDTLS_FDNO PRIMARY KEY(FD_NO),

CONSTRAINT FK_FDDTLS_FDSERNO FOREIGN KEY(FD_SER_NO)

REFERENCES FD_MSTR(FD_SER_NO),

CONSTRAINT CHK_FDDTLS_TYPE CHECK(TYPE IN('S', 'R')),

CONSTRAINT CHK_FDDTKS_PAYTOACCTNO CHECK(PAYTO_ACCTNO LIKE 'CA%' OR PAYTO_ACCTNO LIKE 'SB%'),

CONSTRAINT CHK_FDDTLS_STATUS CHECK(STATUS IN('A', 'C', 'M')),

CONSTRAINT CHK_FDDTLS_AUTORENEWAL CHECK(AUTO_RENEWAL IN('Y', 'N')));

-- ACCT_FD_CUST_DTLS

CREATE TABLE "DBA_BANKSYS"."ACCT_FD_CUST_DTLS"(

"ACCT_FD_NO" VARCHAR2(10),

"CUST_NO" VARCHAR2(10),

CONSTRAINT CHK_ACCTFDCUSTDTLS_ACCTFDNO

CHECK(ACCT_FD_NO LIKE 'CA%' OR ACCT_FD_NO LIKE 'FS%'

OR ACCT_FD_NO LIKE 'SB%'),

CONSTRAINT FK_ACCTFDCUSTDTLS_CUSTNO FOREIGN KEY(CUST_NO)

REFERENCES CUST_MSTR(CUST_NO));

-- NOMINEE_MSTR

CREATE TABLE "DBA_BANKSYS"."NOMINEE_MSTR"(

"NOMINEE_NO" VARCHAR2(10),

"ACCT_FD_NO" VARCHAR2(10),

"NAME" VARCHAR2(75),

"DOB" DATE,

"RELATIONSHIP" VARCHAR2(25),

CONSTRAINT PK_NOMINEEMSTR_NOMINEENO PRIMARY KEY(NOMINEE_NO),

CONSTRAINT CHK_NOMINEEMSTR_ACCTFDNO

CHECK(ACCT_FD_NO LIKE 'CA%' OR ACCT_FD_NO LIKE 'FS%'

OR ACCT_FD_NO LIKE 'SB%'));

-- ADDR_DTLS

CREATE TABLE "DBA_BANKSYS"."ADDR_DTLS"(

"ADDR_NO" NUMBER(6),

"CODE_NO" VARCHAR2(10),

"ADDR_TYPE" VARCHAR2(1),

"ADDR1" VARCHAR2(50),

"ADDR2" VARCHAR2(50),

"CITY" VARCHAR2(25),

"STATE" VARCHAR2(25),

"PINCODE" VARCHAR2(6),

CONSTRAINT PK_ADDRDTLS_ADDRNO PRIMARY KEY(ADDR_NO),

CONSTRAINT CHK_ADDRDTLS_CODENO

CHECK(CODE_NO LIKE 'B%' OR CODE_NO LIKE 'C%' OR CODE_NO LIKE 'E%'

OR CODE_NO LIKE 'N%' OR CODE_NO LIKE 'O%'),

CONSTRAINT CHK_ADDRDTLS_ADDRTYPE

CHECK(ADDR_TYPE IN('C', 'N', 'H', 'B')));

-- CNTC_DTLS

CREATE TABLE "DBA_BANKSYS"."CNTC_DTLS"(

"ADDR_NO" NUMBER(6),

"CODE_NO" VARCHAR2(10),

"CNTC_TYPE" VARCHAR2(1),

"CNTC_DATA" VARCHAR2(75),

CONSTRAINT FK_CNTCDTLS_ADDRNO FOREIGN KEY(ADDR_NO)

REFERENCES ADDR_DTLS(ADDR_NO),

CONSTRAINT CHK_CNTCDTLS_CODENO

CHECK(CODE_NO LIKE 'B%' OR CODE_NO LIKE 'C%' OR CODE_NO LIKE 'E%'

OR CODE_NO LIKE 'N%' OR CODE_NO LIKE 'O%'),

CONSTRAINT CHK_CNTCDTLS_CNTCTYPE

CHECK(CNTC_TYPE IN('R', 'O', 'M', 'P', 'E', 'F', 'W')));

-- TRANS_MSTR

CREATE TABLE "DBA_BANKSYS"."TRANS_MSTR"(

"TRANS_NO" VARCHAR2(10),

"ACCT_NO" VARCHAR2(10),

"DT" DATE,

"TYPE" VARCHAR2(1),

"PARTICULAR" VARCHAR2(30),

"DR_CR" VARCHAR2(1),

"AMT" NUMBER(8,2),

"BALANCE" NUMBER(8,2),

CONSTRAINT PK_TRANSMSTR_TRANSNO PRIMARY KEY(TRANS_NO),

CONSTRAINT CHK_TRANSMSTR_ACCTNO

CHECK(ACCT_NO LIKE 'CA%' OR ACCT_NO LIKE 'SB%'),

CONSTRAINT CHK_TRANSMSTR_TYPE CHECK(TYPE IN('B', 'C', 'D')),

CONSTRAINT CHK_TRANSMSTR_DRCR CHECK(DR_CR IN('D', 'W')));

-- TRANS_DTLS

CREATE TABLE "DBA_BANKSYS"."TRANS_DTLS"(

"TRANS_NO" VARCHAR2(10),

"INST_NO" NUMBER(6),

"INST_DT" DATE,

"PAYTO" VARCHAR2(30),

"INST_CLR_DT" DATE,

"BANK_NAME" VARCHAR2(35),

"BRANCH_NAME" VARCHAR2(25),

"PAIDFROM" VARCHAR2(10),

CONSTRAINT FK_TRANSDTLS_TRANSNO FOREIGN KEY(TRANS_NO)

REFERENCES TRANS_MSTR(TRANS_NO));