Banking Assignment - Procedures Database SQL

Added on - 18 Sep 2019

20
Pages
1754
Words
240
Views
0
Downloads

Share on Facebook Share on Twitter Share on LinkedIn Share on Whatsapp Share on Mail Copy Link

Trusted by +2 million users,
1000+ happy students everyday

Download This Document

Showing pages 1 to 4 of 20 pages

Faisal Jahdlai08 December, 2016BANKING SCENARIOPROCEDURES

Faisal JahdaliSecond Draft1|Page

ContentsER DIAGRAMCREATE AND INSERT TABLE COMMANDSSQL PROCEDURES2|Page

ER DIAGRAMCREATE AND INSERT TABLE COMMANDSCREATE SEQUENCE c1MINVALUE 1MAXVALUE 999999START WITH 1INCREMENT BY 1CACHE 20;3|PageAccountAcct_ID {PK}Cust_ID {FK}Acct_NumBalanceCustomerCust_ID {PK}Cust_TypeLast_NameFirst_NameStreetCityStateZipCodeSexTrans_ID {PK}Acct_ID {FK}AmountDateTrans_TypeTransaction1,0,*Has0,*1,1Has