Answer Happy

Task1 (15marks)Drawand present a dependency diagram for the tableabove, including transitivedependencies. Inyourwritten presentation, you need to explain eachdependency.
Task2 (5 marks)Ifthe table above is not in thefirst normal form, normaliseit so that it is in thefirst normal formwithoutcreating any more tables. You maycreate an additional attribute orattributes.Presentyour solution and the reason why it was not inthe first normal form, and whatchangesweremade to make it in the first normalform. If the table above is in thefirst normal form, explainwhy it is in first normalform.
Task3 (15 marks)Ifthe resulting table from the previoustask is not in the secondnormal form, normalise it so thatitisin the second normal form withoutcreating any more tables. You maycreate an additionalattributeor attributes. Present your solution and the reason why it was notin the secondnormalform, as well as the changesthat were made to turnit to the second normal form. Iftheresultingtable from the previous task isalready in thesecond normal form, explain why it is inthesecondnormal form.
Task4 (30 marks)Ifthe resulting table from the previous task is not inthe third normal form, normalise it so that itisinthe third normal form. You may create additionaltables. Present your solution andthereasonwhy it was not in the third normalform, as well as the changesthat were made to turnit tothethird normal form. If the resulting table from the previoustask is already inthe third normalform,explain why it is in the thirdnormal form.
Task5 (15 marks)Basedon the resulting table from the previous task, draw and present anERD to the audience.Pleaseuse LucidChart or an equivalent professionaldiagramming software applicationto draw theERD.
according to the parking regulations governing Parking and Traffic management regulations of the university, and any unlawing or traffic displayed on signages, and vehicles parked longer than the indicated time may incur a fine of $50 for the offence. Likewise, parking penalties may also be comprise multiple fines, and each fine rate for each offence depends on the type of Examine the following PARKING FINE table used by the Fiction University to record parking violations committed. These fines are recorded typically below: