mysql - How do I create this relational table? -


Below is a part of the relational data base, I know how to create a table and provide it with the primary key .. But no help to make other tables and assign primary keys to it?

Enter image details here

table movie

  create table (id key primary key, heading VARCHAR (35) no, description, VARCHAR (256) No, zero, absolute no check no (year> 19 00), rating integer no 3 discount faucet (rating between 1 and 5);   

How do I table FilmFormat and OrderItem ?

Z (JPKfield) ('PKfield'), Contract 'FK' Foreign Key 'FK' (`PKFIELD`) Reference 'Film' (` `` `), '' Field '', 'Primary' ID`) on the Daily restrictions on the updated restriction) Engine = InDebbi;

Comments