﻿CREATE TABLE ActorMovie(
ActorID INT NOT NULL ,
MovID INT NOT NULL ,
Role VARCHAR( 20 ) ,
CONSTRAINT PK_AM PRIMARY KEY Clustered( ActorID, MovID ) ,
CONSTRAINT FK_Actor_ActorMovie FOREIGN KEY ( ActorID ) REFERENCES Actor( ActorID ) 
ON UPDATE CASCADE 
ON DELETE CASCADE ,
CONSTRAINT FK_Movie_ActorMovie FOREIGN KEY ( MovID ) REFERENCES Movie( MovID ) 
ON UPDATE CASCADE 
ON DELETE CASCADE
)
