Contents ER DIAGRAM...........................................................................................................................2 CREATE AND INSERT TABLE COMMANDS....................................................................2 SQL PROCEDURES.................................................................................................................3 1|P a g e
ER DIAGRAM CREATE AND INSERT TABLE COMMANDS CREATE SEQUENCE c1 MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20; 2|P a g e Has1,10,* Has0,* 1,1 Cust_ID {PK} Cust_Type Last_Name First_Name Street City State ZipCode Sex Trans_ID {PK} Acct_ID {FK} Amount Date Trans_Type Transaction Customer Acct_ID {PK} Cust_ID {FK} Acct_Num Balance Account
CREATE SEQUENCE T1 MINVALUE 1 MAXVALUE 999999 START WITH 1 INCREMENT BY 1 CACHE 20; 3|P a g e