Consider the following database
Customer (cno integer, cname varchar(20), city varchar(20))
Account (a_no int, a_type varchar(10), opening_date date, balance money)
Customer and Account are related with one to many relationship
Create table customer
create table customer ( cno int primary key,cname varchar(50),city varchar(50) );
CREATE TABLE
insert values in customer table
Acode2=# insert into customer values(1,'aaaaa','nashik' );
INSERT 0 1
Acode2=# insert into customer values(2,'bbbbb','sinnar' );
INSERT 0 1
Acode2=# insert into customer values(3,'ccccc','vadangali' );
INSERT 0 1
Acode2=# insert into customer values(4,'ddddd','sukena' );
INSERT 0 1
----------------------------------------------------------------
Out put of table
Acode2=# select * from customer;
o\p
Acode2=# select * from customer;
cno | cname | city
-----+-------+-----------
1 | aaaaa | nashik
2 | bbbbb | sinnar
3 | ccccc | vadangali
4 | ddddd | sukena
Create table account
create table account(ano int primary key,atype varchar(50),odate date,balance money ,cno int references customer(cno));
CREATE TABLE
insert values in account table
asim2=# insert into account values(111,'ac','2005-05-03',25000,1 );
INSERT 0 1
Acode2=# insert into account values(222,'zero','2006-12-04',1000, 2);
INSERT 0 1
Acode2=# insert into account values(333,'current','2019-01-01',100000, 3);
INSERT 0 1
Acode2=# insert into account values(444,'current','2019-06-12',200000, 4);
INSERT 0 1
Acode2=# insert into account values(555,'ac','2015-04-28',200000, 3);
INSERT 0 1 ^
Acode2=# insert into account values(666,'zero','2017-07-30',500, 2);
INSERT 0 1
Output of table
Acode2=# select * from account;
Acode2=# select * from account;
ano | atype | odate | balance | cno
-----+---------+------------+-------------+-----
111 | ac | 2005-05-03 | ₹25,000.00 | 1
222 | zero | 2006-12-04 | ₹1,000.00 | 2
333 | current | 2019-01-01 | ₹100,000.00 | 3
444 | current | 2019-06-12 | ₹200,000.00 | 4
555 | ac | 2015-04-28 | ₹200,000.00 | 3
666 | zero | 2017-07-30 | ₹500.00 | 2
(6 rows)
0 Comments