Banking Assignment - Procedures Database SQL

Added on - 18 Sep 2019

Trusted by +2 million users,
assist thousands of students everyday
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
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Become a Desklib Library Member.
Subscribe to our plans

Download This Document