support@essaywritingexpert.orgIn the first two modules, you learnt data models and relational data modelling. Next, you wereintroduced to the database table normalisation process in Module 3.1, which is aimed toenhance the quality of database tables. Normalisation plays a significant role in ensuringdatabase tables are well structured so that both data redundancies and the likelihood of dataanomalies can be minimised. By completing this assessment, you will demonstrate your understanding of the following: ( 1 ) t h e d a t a b a s e t a b l e n o r m a l i s a t i o n p r o c e s s a n d ( 2 ) t h e c r i t e r i a f o r d a t a b a s e t a b l e s t o b e i n 1 N F , 2 N F a n d 3 N F 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. Page 1 of 8 In this assessment, you are required to perform database table normalisation and present yoursolutions in a PowerPoint presentation. In doing so, you are required to demonstrate your work andsolution through a series of normal forms. You need to first normalise the database tables to the firstnormal form (1NF), then the second normal form (2NF), and finally the third normal form (3NF). Context Submission Page 2 of 8 Examine the following PARKING FINE table used by the Fiction University to record parking violations committed. These fines are recorded typically asbelow: StID A00020 A00049 A00040 A00044 A00020 G u r d e e p S i n g h F i o n a J a m e s Rudy Deco T h o m a s Brown StudName Thomas Brown P h o n e N o 0 4 0 1 2 4 8 8 6 040124234 040456234 0 4 0 8 9 6 2 4 5 0 4 0 1 2 4 8 8 6 M I T M I T B B I S MBIS C o u r s e BBIS B U S School B U S S c i e n c e & E n g S c i e n c e & E n g BUS TRE142 LicNo B R Y 1 2 3 TRE176 T R E 1 7 9 BRY123 F F P P L i c C a t P F u l l F u l l Prov P r o v LicDesc P r o v 14984 1 4 9 9 7 1 4 9 9 9 1 5 6 3 9 T i c k e t N o 1 5 6 3 4 T i c k e t D a t e 1 0 / 1 0 / 2 0 1 9 2 3 / 1 0 / 2 0 2 1 2 2 / 0 3 / 2 0 2 0 2 2 / 0 3 / 2 0 2 1 10/10/2020 2 3 1 4 2 3 O f f e n c e C o d e 4 O f f e n c e D e s c N o V a l i d P a r k i n g p e r m i t O v e r s t a y i n g a l l o t t e d t i m e P a r k i n g o n d i s a b i l i t y p a r k i n g s p a c e P a r k i n g o n p a r k i n g r e s t r i c t e d a r e a N o V a l i d P a r k i n g p e r m i t O v e r s t a y i n g a l l o t t e d t i m e P a r k i n g o n d i s a b i l i t y p a r k i n g space 5 0 1 0 0 1 5 0 4 0 5 0 1 0 0 F i n e Task Instructions 2. When completing this assessment, you are required to make reasonable assumptions based on common sense if it has not been explicated int the scenario. The total presentation should be no more than 6 minutes. This includes a 5-minute question-andanswer session. Page 3 of 8 1. Please complete the following tasks and deliver a 5-minute presentation to communicate your answers/solutions 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 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.
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. You may create additional tables. 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. Length and Layout of the Presentation • • Please prepare your presentation using Microsoft PowerPoint. Note: The Reviewer may ask you to do a video recording of the presentation instead of an in-person presentation. R Special Instructions P a g e 5 o f 8 If the table is in the first normal form, explain why it is in the first normal form. Outcome: a) Analyse specific organisational needs that can be addressed by collection, storage and management of organisational data. T a s k 1 D r a w a n d p r e s e n t a d e p e n d e n c y d i a g r a m i n c l u d i n g t r a n s i t i v e d e p e n d e n c i e s . E x p l a i n e a c h d e p e n d e n c y i n t h e p r e s e n t a t i o n . O u t c o m e : a ) A n a l y s e s p e c i f i c o r g a n i s a t i o n a l n e e d s t h a t c a n b e a d d r e s s e d b y c o l l e c t i o n , s t o r a g e a n d m a n a g e m e n t o f organisational data.
T a s k 2 ➢ ➢ Normalise the table to be in the first normal form, if it is not already in the first normal form. Discuss the solution and explain the reasons as to why the table was not in the first normal form, a n d w h a t c h a n g e s w e r e m a d e t o t u r n i t i n t o t h e f i r s t n o r m a l f o r m i n t h e o r a l p r e s e n t a t i o n . ➢P a g e 6 o f 8 ➢ I f t h e t a b l e i s i n t h e f i r s t n o r m a l f o r m , e x p l a i n w h y i t i s i n t h e f i r s t n o r m a l f o r m . O u t c o m e : o r g a n i s a t i o n a l d a t a .
T a s k 4 ➢➢ N o r m a l i s e t h e t a b l e t o b e i n t h e t h i r d n o r m a l f o r m , i f i t i s n o t a l r e a d y i n t h e t h i r d n o r m a l f o r m a n d w h a t c h a n g e s w e r e m a d e t o t u r n i t i n t o t h e t h i r d n o r m a l f o r m i n t h e o r a l p r e s e n t a t i o n . ➢ I f t h e t a b l e i s i n t h e t h i r d n o r m a l f o r m , e x p l a i n w h y i t i s i n t h e t h i r d n o r m a l f o r m . Outcome: a) Analyse specific organisational needs that can be addressed by collection, storage andmanagement of o r g a n i s a t i o n a l d a t a .
T a s k 3 ➢ ➢ N o r m a l i s e t h e t a b l e t o b e i n t h e s e c o n d n o r m a l f o r m , i f i t i s n o t a l r e a d y i n t h e s e c o n d n o r m a l f o r m . D i s c u s s t h e s o l u t i o n a n d e x p l a i n t h e r e a s o n s a s t o w h y t h e t a b l e w a s n o t i n t h e s e c o n d n o r m a l f o r m , a n d w h a t c h a n g e s w e r e m a d e t o t u r n i t i n t o t h e s e c o n d n o r m a l f o r m i n t h e o r a l p r e s e n t a t i o n . P a g e 7 o f 8
Task 5 ➢➢ D r a w a n d p r e s e n t a n E R D b a s e t o t h e a u d i e n c e . d) Apply and communicate the database solutions for specialist and non-specialist stakeholders. E f f e c t i v e C o m m u n i c a t i o n C l a r i t y , p a c e a n d f l u e n c y . C l e a r a n d l o g i c a l s t r u c t u r e o f t h e o r a l p r e s e n t a t i o n .