Create table Movie Actor related with many to many relationship.

 

 

Consider the following database  

Movie (m_name varchar (25), release_year integer, budget money) 

Actor (a_name varchar(30), role varchar(30), charges money, a_address varchar(30) ) 

Movie and Actor are related with many to many relationship. 

Create table Actor

create table actor ( aid int primary key, aname varchar(30)
, role varchar(30),charges money ,aadd varchar(30) );

 Insert values in  Actor Tabel

insert into actor values (1,'aaaa','hero',20000000,'mubali');

insert into actorvalues(2,'bbbb','hero/programer',2500000,'us');

insert into actor values (3,'cccc','hero',3500000,'india');

insert into actor values (4,'dddd','hero',3500000,'india');

output of Actor table

Acode2=# select * from actor;

 aid | aname |      role      |    charges     |  aadd  

-----+-------+----------------+----------------+--------

   1 | aaaa  | hero           | ₹20,000,000.00 | mubali

   2 | bbbb  | hero/programer |  â‚¹2,500,000.00 | us

   3 | cccc  | hero           |  â‚¹3,500,000.00 | india

   4 | dddd  | hero           |  â‚¹3,500,000.00 | india

Create table movie

create table movie (mid int primary key ,
mname varchar(25) ,ryear int, budget money );

 Insert values in Movies Tabel 

insert into movie values (  1,'Dnagal' ,2018 ,2500000    );

 insert into movie values (  2,'Sultan' ,2017 ,3000000    );

insert into movie values (  3,'KGF' ,2019 ,250000000    );

 insert into movie values (  4,'bahubali' ,2019 ,35000000    );

insert into movie values (  5,'THE social network' ,2010 ,20000000    );

output of Movies table

Acode2=# select * from movie;

o\p

 mid |       mname        | ryear |     budget      

-----+--------------------+-------+-----------------

   1 | Dnagal             |  2018 |   ₹2,500,000.00

   2 | Sultan             |  2017 |   ₹3,000,000.00

   3 | KGF                |  2019 | ₹250,000,000.00

   4 | bahubali           |  2019 |  â‚¹35,000,000.00

   5 | THE social network |  2010 |  â‚¹20,000,000.00

=========================================================================

create table actor and moives 

create table moviact( aid int references actor(aid),mid int references movie(mid)    );

 Insert values in  Actor & movies  Tabel

Acode2=# insert into moviact values (1,4   );

INSERT 0 1

Acode2=# insert into moviact values (1,2   );

INSERT 0 1

Acode2=# insert into moviact values (1,3   );

INSERT 0 1

Acode2=# insert into moviact values (1,1   );

INSERT 0 1

Acode2=# insert into moviact values (2,1   );

INSERT 0 1

Acode2=# insert into moviact values (2,2   );

INSERT 0 1

Acode2=# insert into moviact values (2,3   );

INSERT 0 1

Acode2=# insert into moviact values (2,4   );

INSERT 0 1

Acode2=# insert into moviact values (2,5   );

INSERT 0 1

Acode2=# insert into moviact values (1,5   );

INSERT 0 1

Acode2=# insert into moviact values (3,1   );

INSERT 0 1

Acode2=# insert into moviact values (3,2   );

INSERT 0 1

Acode2=# insert into moviact values (3,3   );

INSERT 0 1

Acode2=# insert into moviact values (3,4   );

INSERT 0 1

Acode2=# insert into moviact values (3,5   );

INSERT 0 1

Acode2=# insert into moviact values (4,1   );

INSERT 0 1

Acode2=# insert into moviact values (4,2   );

INSERT 0 1

Acode2=# insert into moviact values (4,3   );

INSERT 0 1

Acode2=# insert into moviact values (4,4   );

INSERT 0 1

Acode2=# insert into moviact values (4,5   );

INSERT 0 1

Acode2=# insert into moviact values (5,5   );

-----------------------------------------------------------------------------

output of Actor and  Movies table

Acode2=# select * from moviact;

 aid | mid 

-----+-----

   1 |   4

   1 |   2

   1 |   3

   1 |   1

   2 |   1

   2 |   2

   2 |   3

   2 |   4

   2 |   5

   1 |   5

   3 |   1

   3 |   2

   3 |   3

   3 |   4

   3 |   5

   4 |   1

   4 |   2

   4 |   3

   4 |   4

   4 |   5

(20 rows)