1 . Do the 3rd normal form of this tables without surrogate key for any tables. (12 marks)

2. Put that data from the above movie report into each 3NF table that you design completely. (20 marks)

TheaterNo 2 ShowDate 3 20/9/2018 4 20/9/2019 5 20/9/2020 6 20/9/2021 7 20/9/2022 8 20/9/2023 9 20/9/2024 10 20/9/2025 ShowTime Title 0.416666667 Marvel 0.680555556 Maze Runner 0.416666667 Star war 0.5 Star war 0.479166667 Marvel 0.763888889 Maze Runner 0.479166667 Star War 0.861111111 Maze Runner Movie Report Minutes Type Branch 145 4D NY 120 4D NY 105 3D 105 3D 145 Panorama LA 120 3D 105 Digital LA 120 3D genere 1 Action, Advanture, Fantasy 1 Action, Advanture 2 Animation, Advanture, Comedy 2 Animation, Advanture, Comedy 1 Action, Advanture, Fantasy 2 Action, Advanture 3 Animation, Advanture, Comedy 2 Action, Advanture 11