List the tables and their fields if you normalized the following information in 3rd normal form. HQ and Director are composite attributes that need to be transformed, There should be at least 3 tables represented. You should list all the fields as well as noting the primary and foreign keys. If a table would have a poor primary key then provide it a surrogate primary key. Budget Genre Movieid Runtime Title 148 Spectre 139 Spider-Man 3 151 Batman v Superman: Dawn of Justice 154 Superman Returns 169 Pirates of the Caribbean: At World's End 100 Tangled 151 Pirates of the Caribbean: Dead Man's Chest 165 The Dark Knight Rises 143 Man of Steel Director BD 245000000 Action Columbia PicturesCulver City, Calfornia, US Columbia Pitres Culver City, Calfornia, US DC Comics DC Comics Disney Disney Disney Legendary Pictures Burbank, California, US Legendary Pictures Burbank, California, US Burbank, California, US Burbank, California, US Burbank, California, US Burbank, California, US Burbank, California, US 206647 559 209112 1452 285 38757 58 49026 49521 Samuel Alexander Samuel M Raimi Zachary Edward Sny Bryan J Singer Gore Verbinsky Nathan Greno Gore Verbinsky Christopher Edward Zachary Edward Sny 8/1/1965 10/23/1959 3/1/1966 9/17/1965 3/16/1964 3/22/1975 3/16/1964 7/31/1970 3/1/1966 250000000 Action 250000000 Action 225000000 Action