Banking Assignment - Procedures Database SQL

Added on - 18 Sep 2019

  • 20

    Pages

  • 1754

    Words

  • 199

    Views

  • 0

    Downloads

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
desklib-logo
You’re reading a preview
Preview Documents

To View Complete Document

Click the button to download
Subscribe to our plans

Download This Document