DBA

Please follow Normalization rules to complete following lab assignments (35 points per question) You need to complete lab step by step and draw ER Diagram for each example. Director No Director Name Actor No Actor Name Role On Sereen F1100 Happy Day D101 im Alan 50 A1000 Judy Foster A1001 A1009 A1200Eddy Murphy A1000Judy Foster Amy Blues Harry Woods 30 Jack James Exxel Fuse Ann Jones Robert Dininor Harrison Ford 65 15 Mrs. President 50 Mr. President Police One Police Two A1000Judy Foster A1009 F1101 Air Force One D105 Woody Ellen Harrison Ford A1200Eddy Murphy A1 35 45 002 Mary Jacksons F1102 Bride Run Away D101 Jim Alan A1003 A1007 David Lynch A1009 A1005 A1000Judy Foster Black Widow Sam Strickland 45 Bank Robber Cab Driver Amy Blues 50 35 65 Julia Roberts Harrison Ford John Wynes