1. create table customer_master(custname varchar2(10),cin number(10)constraint con_pk primary key,accno number(10),opbal number(10),address varchar(10),phno number(10),opdate date);
2.create table card_master(cin number(10),cardno varchar2(16));
alter table card_master add constraint con_fk foreign key(cin) references customer_master5064(cin);
alter table card_master add constraint cad_pk primary key(cardno);
3) create table daily_transactions(cardno varchar2(16),trandate date,tranamt number(10),balance number(10),deposit number(10),withdraw number(10),txn_ref_no varchar2(20));
alter table daily_transactions add constraint txn_fk foreign key(cardno)references card_master5064(cardno);
alter table daily_transactions5064 add constraint txn_pk primary key(TXN_REF_NO);
insert into customer_master values('&custname',cust64.nextval,acc64.nextval,&opbal,'&address',&phno,'&opdate');
insert into card_master values(1111122222,cdno64.nextval);
Subscribe to:
Post Comments (Atom)
MY HIT COUNTER
Blog Archive
-
▼
2009
(38)
-
▼
November
(27)
- few programs on bank project
- customer identification number
- bank programs
- min balance program in oracle
- cards balance
- real time programs in bank project
- real time registration example
- Creation of tables in oracle
- practice quries
- quries
- reverse number
- throws exception
- throws exception
- divide by zero
- array index
- length of a string name
- no parameters to string
- print two parameters
- abstract class in core java
- inside area of rectangle
- area of rectangle
- three string parameters
- class b extends a
- incremeting numbers
- sum of three parameters
- box program
- strings
-
▼
November
(27)
Custom Search
No comments:
Post a Comment