Limited-time offer! Save up to 50% Off | Solutions starting at $6 each  

Banking Scenario Procedures- Doc

Added on - 19 Sep 2019

Trusted by 2+ million users,
1000+ happy students everyday
Showing pages 1 to 4 of 19 pages
Faisal Jahdlai
08 December, 2016
BANKING SCENARIO
PROCEDURES
Faisal Jahdali
Second Draft
Contents
ER DIAGRAM...........................................................................................................................2
CREATE AND INSERT TABLE COMMANDS....................................................................2
SQL PROCEDURES.................................................................................................................3
1|P a g e
ER DIAGRAM
CREATE AND INSERT TABLE COMMANDS
CREATE SEQUENCE c1
MINVALUE 1
MAXVALUE 999999
START WITH 1
INCREMENT BY 1
CACHE 20;
2|P a g e
Has1,10,*
Has0,*
1,1
Cust_ID {PK}
Cust_Type
Last_Name
First_Name
Street
City
State
ZipCode
Sex
Trans_ID {PK}
Acct_ID {FK}
Amount
Date
Trans_Type
Transaction
Customer
Acct_ID {PK}
Cust_ID {FK}
Acct_Num
Balance
Account
CREATE SEQUENCE T1
MINVALUE 1
MAXVALUE 999999
START WITH 1
INCREMENT BY 1
CACHE 20;
3|P a g e
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document