Ask a question to Desklib · AI bot
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
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
Paid Plans
Free Plan
Single Unlock
Monthly Plan
Yearly Plan