Answer Happy

NORMALIZATION UserIDU_Emall Fisrt_Name Last_Name Clty State ZIP MA12 [email protected] Emmanuel Jacobs Bilaspur Chatisgarh 458991 LA33 [email protected] Lavleen Dallah Raipur Chatisgarh 853578 PO32 [email protected] Poojah Magg Kacch Gujrat 832212 CH99 [email protected] Chimal Bedí Trichy Tamil Nadu 632011 DA74 [email protected] Dani Miller Trichy Tamil Nadu 632011 Figure 1: Users' Personal Data Consider the table in Figure 1 showing personal data for users a) What is the Normal Form of the Student table in Figure 1? [1 mark] b) Explain the anomalies that a database is susceptible to using suitable examples and state whether is any may occur in this table [6 marks] c) State the key for the table and its dependencies. Describe and illustrate the process of normalization by creating the normalized tables that are normalized up to 4NF. Ensure to identify the primary keys and foreign keys in each derivation. [5 marks]