logo

Transaction and Customer Management System

   

Added on  2019-10-18

9 Pages1874 Words471 Views
 | 
 | 
 | 
STUDENT08OCTOBER,2016BANKINGSCENARIOPROCEDURES
Transaction and Customer Management System_1

ContentsER DIAGRAM...........................................................................................................................2CREATE AND INSERT TABLE COMMANDS....................................................................2SQL PROCEDURES.................................................................................................................31 | P a g e
Transaction and Customer Management System_2

ER DIAGRAMAs mentioned in the mail by you, that you have already drawn the ERD. So ERD is not missing. You can paste the ERD in this area.CREATE AND INSERT TABLE COMMANDSCREATE SEQUENCE c1 MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20;CREATE SEQUENCE T1 MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20;create table customer (cust_id int primary key, cust_type varchar2(20), fname varchar2(20), lname varchar2(20), street varchar2(30), city varchar2(30), zip number(6,0), state varchar2(30), gender char(1), constraint chk_1 check (cust_type IN ('small business', 'large business', 'personal')),constraint chk_2 check (gender IN ('M', 'F')));INSERT INTO CUSTOMER VALUES (C1.NEXTVAL, 'small business', 'JIA', 'STEVEN', '21 PARK STREET', 'ASPEN', 889988, 'CA', 'F');INSERT INTO CUSTOMER VALUES (C1.NEXTVAL, 'large business', 'DIA', 'STONES', '212 PARK VIEW ROAD', 'ASPEN', 889908, 'CA', 'F');INSERT INTO CUSTOMER VALUES (C1.NEXTVAL, 'personal', 'LIA', 'DAVID', '41 GREEN PARK STREET', 'ASPEN', 889918, 'CA', 'F');create table account ( acct_id int primary key, cust_id int, acct_type varchar2(20) not null, acct_num number(16,0)unique , balance number(10,2), constraint fk_1 foreign key(cust_id) references customer(cust_id),2 | P a g e
Transaction and Customer Management System_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents