Banking Assignment - Procedures Database SQL
Added on - 18 Sep 2019
Trusted by +2 million users,
assist thousands of students everyday
assist thousands of students everyday
Showing pages 1 to 4 of 20 pages
Faisal Jahdlai08 December, 2016BANKING SCENARIOPROCEDURES
Faisal JahdaliSecond Draft1|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

You’re reading a preview
To View Complete Document
Become a Desklib Library Member.
Subscribe to our plans