Create tables in MySQL

(Single Primary Key)

mysql> create table movie (cMovieID varchar(6) not null, vTitle varchar(30) not null, cDirectorID varchar(6) not null, cProducerID varchar(6) not null, cDuration int(11) default null, vDescription varchar(200) default null, cRatingID varchar(6) not null, cCategoryID varchar(6) not null, PRIMARY KEY (cMovieID));

For multiple primary keys, you can give PRIMARY KEY(cActorID, cMovieID)