create an ER model of a movie database system. Film table (relationship model) should contain information about each and every film. Table should contain columns with these headings in the different columns: movie id, title, genre, year realized, minutes, director, main actor & country.

Start creating the ER model by setting up all the tables you need, as well as key values. Then make the links between the forms.

Then you should normalize your system.

You will now create the database and fill in the tables with information.

use mysql workbench