Ask a question to Desklib · AI bot

Ask NowBETA

Banking Assignment - Procedures Database SQL

Added on -2019-09-18

| 20 pages
| 1754 words
| 421 views

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

Faisal Jahdlai08 December, 2016BANKING SCENARIO PROCEDURES
Faisal Jahdali Second Draft 1 | Page
ContentsER DIAGRAMCREATE AND INSERT TABLE COMMANDSSQL PROCEDURES2 | Page
ER DIAGRAMCREATE AND INSERT TABLE COMMANDSCREATE SEQUENCE c1 MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20;3 | PageAccountAcct_ID {PK}Cust_ID {FK}Acct_Num BalanceCustomerCust_ID {PK}Cust_TypeLast_NameFirst_NameStreetCityStateZipCodeSexTrans_ID {PK}Acct_ID {FK}Amount DateTrans_TypeTransaction1,0,*Has0,*1,1Has

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