_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. 1. Film No Title Director No Director Name Actor No Actor Name Role Time On Screen D101 50 30 45 65 15 F1100 Happy Day Jim Alan A1000 A1001 A1009 A1200 A1000 Judy Foster Robert Dininor Harrison Ford Eddy Murphy Judy Foster Amy Blues Harry Woods Jack James Exxel Fuse Ann Jones F1101 Air Force One D105 Woody Ellen Mrs. President 50 A1000 A1009 A1200 A1002 Judy Foster Harrison Ford Eddy Murphy Mary Jacksons Mr. President Police One Police Two 35 45 F1102 Bride Run Away D101 Jim Alan A1003 A1007 A1009 A1005 A1000 50 Julia Roberts David Lynch Harrison Ford John Wynes Judy Foster Black Widow Sam Strickland 45 Bank Robber Cab Driver Amy Blues 35 25 65