MIS201- Database Fundamental - Perform Database Table Normalisation - IT Assignment Help

Assignment Task

Task Summary  
In  this  assessment,  you  are  required  to  perform  database  table  normalisation  and  present  your  solutions in a PowerPoint presentation.  In doing so, you are required to demonstrate your work and  solution  through a  series  of  normal  forms. You  need  to  first  normalise  the  database  tables  to  the  first normal form (1NF), then the second normal form (2NF), and finally the third normal form (3NF).    

Context  
In  the  first  two  modules,  you  learnt  data  models  and  relational  data  modelling.  Next,  you  were  introduced  to  the database  table normalisation process in Module 3.1, which is aimed  to enhance  the quality of database tables. Normalisation plays a significant role in ensuring database tables are  well  structured  so  that  both  data  redundancies  and  the  likelihood  of  data  anomalies  can  be  minimised.  
By completing this assessment, you will demonstrate your understanding of the following:  
(1) the database table normalisation process and 
(2) the criteria for database tables to be in 1NF, 2NF and 3NF as well as your ability to:  
(1) comprehend business rules and logic to determine data dependencies, 
(2) perform database table normalisation process and normalise database tables up to 3NF and (3) articulate your solutions and the rationale to an audience.

Task 1
Draw and present a dependency diagram for the table above, including transitive dependencies. In  your oral presentation, you need to explain each dependency.   

Task 2
If  the  table above is not in  the  first normal  form, normalise it so  that it is in  the  first normal  form  without  creating  any  more  tables.  You  may  create  an  additional  attribute  or  attributes.  Orally  present  your  solution  and  the  reason  why  it  was  not  in  the  first  normal  form,  and  what  changes  were made to make it in the first normal form. If the table above is in the first normal form, explain  why it is in first normal form.   

Task 3 
If the resulting table from the previous task is not in the second normal form, normalise it so that it  is  in  the  second  normal  form  without  creating  any  more  tables.  You  may  create  an  additional  attribute  or  attributes. Orally  present  your  solution  and  the  reason  why  it  was  not  in  the  second  normal  form, as well as  the  changes  that were made  to  turn it  to  the  second  normal  form. If  the  resulting table from the previous task is already in the second normal form, explain why it is in the  second normal form.   

Task 4 
If the resulting table from the previous task is not in the third normal form, normalise it so that it is  in  the  third  normal  form.  You  may  create  additional  tables.  Orally  present  your  solution  and  the  reason why it was not in the third normal form, as well as the changes that were made to turn it to  the  third  normal  form. If  the  resulting  table  from  the  previous  task  is already  in  the  third  normal  form, explain why it is in the third normal form.   

Task 5
Based  on  the  resulting  table  from  the  previous  task,  draw  and  present  an  ERD  to  the  audience.  Please use LucidChart or an equivalent professional diagramming software application  to draw  the  ERD.  

3. When completing this assessment, you are required to make reasonable assumptions based on  common  sense.  For  example,  the  following  are  considered  as  common  sense  or reasonable assumptions: 

• Two  persons  may  have  the  same  name,  that  is,  the  same  first  name  AND  same  last name. 
• Two persons who were born on the same day may have the same name. ? A student will undertake more than one subject at a university. 
• More than one subject may be taught by one lecturer. 
• Each subject has only one subject name. 
• Each School only has one Head of School. 

This MIS201 – IT Assignment has been solved by our IT experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.