BANKING SCENARIO PROCEDURES Faisal Jahdlai 08 December, 2016 BANKING SCENARIO PROCEDURES Faisal Jahdali 08 December, 2016 ER DIAGRAM 2 CREATE AND INSERT TABLE COMMANDS 2 SQL PROCEDURES Faisal Jahdlai

Added on -2019-09-19

Faisal Jahdlai 08 December, 2016 BANKING SCENARIO PROCEDURES Faisal Jahdali 08 December, 2016 BANKING SCENARIO PROCEDURES Faisal Jahdali Second Draft Contents ER DIAGRAM 2 CREATE AND INSERT TABLE COMMANDS 2 SQL PROCEDURES 3 ER DIAGRAM Has 1,1 1,1 0,* 0,* Has 0,* 0,* 1,1 1,1 Cust_ID PK Cust_Type Last_Name
| 19 pages
| 1901 words
| 149 views

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
Has 1,10,*
Has 0,*
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

Found this document preview useful?

You are reading a preview
Upload your documents to download
or
Become a Desklib member to get accesss

Students who viewed this