logo

Banking Scenario Procedure Database SQL

9 Pages1874 Words471 Views
   

Added on  2019-10-18

Banking Scenario Procedure Database SQL

   Added on 2019-10-18

ShareRelated Documents
STUDENT08OCTOBER,2016BANKINGSCENARIOPROCEDURES
Banking Scenario Procedure Database SQL_1
ContentsER DIAGRAM...........................................................................................................................2CREATE AND INSERT TABLE COMMANDS....................................................................2SQL PROCEDURES.................................................................................................................31 | P a g e
Banking Scenario Procedure Database SQL_2
ER DIAGRAMAs mentioned in the mail by you, that you have already drawn the ERD. So ERD is not missing. You can paste the ERD in this area.CREATE AND INSERT TABLE COMMANDSCREATE SEQUENCE c1 MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20;CREATE SEQUENCE T1 MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20;create table customer (cust_id int primary key, cust_type varchar2(20), fname varchar2(20), lname varchar2(20), street varchar2(30), city varchar2(30), zip number(6,0), state varchar2(30), gender char(1), constraint chk_1 check (cust_type IN ('small business', 'large business', 'personal')),constraint chk_2 check (gender IN ('M', 'F')));INSERT INTO CUSTOMER VALUES (C1.NEXTVAL, 'small business', 'JIA', 'STEVEN', '21 PARK STREET', 'ASPEN', 889988, 'CA', 'F');INSERT INTO CUSTOMER VALUES (C1.NEXTVAL, 'large business', 'DIA', 'STONES', '212 PARK VIEW ROAD', 'ASPEN', 889908, 'CA', 'F');INSERT INTO CUSTOMER VALUES (C1.NEXTVAL, 'personal', 'LIA', 'DAVID', '41 GREEN PARK STREET', 'ASPEN', 889918, 'CA', 'F');create table account ( acct_id int primary key, cust_id int, acct_type varchar2(20) not null, acct_num number(16,0)unique , balance number(10,2), constraint fk_1 foreign key(cust_id) references customer(cust_id),2 | P a g e
Banking Scenario Procedure Database SQL_3

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
Banking Assignment - Procedures Database SQL
|20
|1754
|421

SQl Procedures and ER Diagram Assignment
|20
|1871
|385

BANKING SCENARIO PROCEDURES Faisal Jahdlai 08 December, 2016 BANKING SCENARIO PROCEDURES Faisal Jahdali 08 December, 2016 ER DIAGRAM 2 CREATE AND INSERT TABLE COMMANDS 2 SQL PROCEDURES Faisal Jahdlai
|19
|1901
|149