Database table definition is provided along with the marking craitria for better answer
TABLE DEFINITIONS FOR DVD'S DELIVERED
DVD
(dvd_id numeric NN PK, dvd_title character(100) NN, rental_cost money NN, rating numeric NN, cover_image character 100)
RATING
(rating_id numeric NN PK, rating_name, character(5) NN, rating_description character(100) NN)
GENRE
(genre_id numeric NN PK, genre_description character(30) NN)
DVD_GENRE
(dvd_id numeric NN PK, genre_id numeric NN PK)
Attachment:- Assignment.rar