Use Oracle SQL Developer DATABASE :..................................................................

 

UNNORMALIZED TABLE 1. MOVIE ID MOVIE TITLE MOVIE VALUE MOVIE QTY MOVIE CAT ID MOVIE CATEGORY 1 Alien 10 5 1 SciFi 2 Bladerunner 8 3 1 SciFi 3 Star Wars 15 11 1 SciFi 4 Texas Chainsaw Masacre 7 2 2 Horror 5 Jaws 6 The good, the bad and the ugly 7 Silverado N N N 7 1 2 Horror 7 2 3 Western 7 1 3 Western 8 Duck Soup 5 1 4 Comedy 9 Planes, trains and automobiles 5 3 4 Comedy 10 Waking Ned Devine 12 11 Deep Blue Sea 12 The Fifth Element 14 15 215 435 LO 4 Comedy 5 Drama 5 Drama Columns Descriptions movie id Movie ID movie title movie value movie_qty movie_cat_id movie_category Movie Title The value (cost) of each movie The number of copies available for each movie Movie Category ID The category for each movie