{"presentation":{"slides":[{"elements":[{"x":26.143790849673202,"y":25.806451612903224,"width":43.24618736383442,"height":40,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Normalization - Its Purpose<\/span><\/h2>\n"},"subContentId":"ffb8a22e-ce1b-4b77-884d-26bb3c3d2dcf","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":true,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":2.178649237472767,"y":86.02150537634408,"width":95.64270152505446,"height":4.946236559139785,"action":{"library":"H5P.Audio 1.5","params":{"fitToWrapper":true,"playerMode":"full","controls":true,"autoplay":true,"playAudio":"Play audio","pauseAudio":"Pause audio","contentName":"Audio","audioNotSupported":"Your browser does not support this audio","files":[{"path":"audios\/files-5e72c9812d0dc.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"41aed858-5f6f-4400-b32e-a16bea0f40ae","metadata":{"contentType":"Audio","license":"U","title":"Purpose"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{},"keywords":[{"main":"Objective"}]},{"elements":[{"x":28.32244008714597,"y":27.956989247311824,"width":41.50326797385621,"height":41.72043010752688,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Divides large tables into smaller,<\/span><\/h3>\n\n
less redundant<\/span>, tables <\/span><\/h3>\n\n
and defines relationships between them.<\/span><\/h3>\n"},"subContentId":"5af1c342-595c-4f62-a01b-6a2d2c3fc543","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":88.07118279569892,"width":92.37472766884532,"height":4.946236559139785,"action":{"library":"H5P.Audio 1.5","params":{"fitToWrapper":true,"playerMode":"full","controls":true,"autoplay":true,"playAudio":"Play audio","pauseAudio":"Pause audio","contentName":"Audio","audioNotSupported":"Your browser does not support this audio","files":[{"path":"audios\/files-5e72c99964be6.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"da08b255-6a90-43ee-9c47-aae1e0974355","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{},"keywords":[{"main":"Less Redudancy"}]},{"elements":[{"x":30.501089324618736,"y":19.354838709677416,"width":39.97821350762527,"height":64.08602150537634,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Isolates Data<\/span><\/h2>\n\n
Allows changes to data in one location, <\/span><\/h2>\n\n
propogates this change using relationships.<\/span><\/h2>\n"},"subContentId":"f9d80d6c-f843-4141-bd32-28604b1b9a49","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":2.178649237472767,"y":88.07118279569892,"width":95.64270152505446,"height":4.946236559139785,"action":{"library":"H5P.Audio 1.5","params":{"fitToWrapper":true,"playerMode":"full","controls":true,"autoplay":true,"playAudio":"Play audio","pauseAudio":"Pause audio","contentName":"Audio","audioNotSupported":"Your browser does not support this audio","files":[{"path":"audios\/files-5e72c9bbc9ac7.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"a395a8aa-9b0e-4e5a-9ad9-9a091e3c795e","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{},"keywords":[{"main":"Isolates Data"}]},{"elements":[{"x":7.625272331154684,"y":6.438172043010752,"width":88.01742919389979,"height":81.29032258064515,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Process is reversible.<\/span><\/h2>\n\n
Data is not lost, data is not added.<\/span><\/h2>\n\n
A database in 3NF, i.e. Third Normal Form is free from <\/span><\/h2>\n\n
Insertion<\/span><\/h2>\n\n
Update <\/span>and <\/span><\/h2>\n\n
Deletion <\/span>Anomalies.<\/span><\/h2>\n\n
<\/p>\n"},"subContentId":"f9d80d6c-f843-4141-bd32-28604b1b9a49","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":3.2679738562091507,"y":88.12172043010753,"width":92.37472766884532,"height":7.096774193548386,"action":{"library":"H5P.Audio 1.5","params":{"fitToWrapper":true,"playerMode":"full","controls":true,"autoplay":true,"playAudio":"Play audio","pauseAudio":"Pause audio","contentName":"Audio","audioNotSupported":"Your browser does not support this audio","files":[{"path":"audios\/files-5e72c9d0bf7a8.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"0c45f312-edca-40db-bf02-f5c063f57b81","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{},"keywords":[{"main":"Removes Anomalies"}]},{"elements":[{"x":19.607843137254903,"y":21.50537634408602,"width":50.98039215686275,"height":46.88172043010752,"action":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"9a1cc16f-41d2-4518-9389-fbdc1ba53ecf","summary":["
Normalization minimizes data redudancy.<\/p>\n","
Normalization maximizes data redudancy.<\/p>\n","
Normalization has no effect on data redudancy.<\/p>\n"],"tip":""}],"overallFeedback":[{"from":0,"to":100}],"solvedLabel":"Progress:","scoreLabel":"Wrong answers:","resultLabel":"Your result","labelCorrect":"Correct.","labelIncorrect":"Incorrect! Please try again.","alternativeIncorrectLabel":"Incorrect","labelCorrectAnswers":"Correct answers.","tipButtonLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","progressText":"Progress :num of :total"},"subContentId":"ef17920d-5943-4dcc-9fd1-dba51e8b7654","metadata":{"contentType":"Summary","license":"U","title":"Data Redudancy"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}}],"keywordListEnabled":true,"globalBackgroundSelector":{},"keywordListAlwaysShow":false,"keywordListAutoHide":true,"keywordListOpacity":90},"override":{"activeSurface":false,"hideSummarySlide":false,"summarySlideSolutionButton":true,"summarySlideRetryButton":true,"enablePrintButton":false,"social":{"showFacebookShare":true,"facebookShare":{"url":"@currentpageurl","quote":"I scored @score out of @maxScore on a task at @currentpageurl."},"showTwitterShare":true,"twitterShare":{"statement":"I scored @score out of @maxScore on a task at @currentpageurl.","url":"@currentpageurl","hashtags":"h5p, course"},"showGoogleShare":true,"googleShareUrl":"@currentpageurl"},"showSolutionButton":"on","retryButton":"on"},"l10n":{"slide":"Slide","score":"Score","yourScore":"Your Score","maxScore":"Max Score","total":"Total","totalScore":"Total Score","showSolutions":"Show solutions","retry":"Retry","exportAnswers":"Export text","hideKeywords":"Hide sidebar navigation menu","showKeywords":"Show sidebar navigation menu","fullscreen":"Fullscreen","exitFullscreen":"Exit fullscreen","prevSlide":"Previous slide","nextSlide":"Next slide","currentSlide":"Current slide","lastSlide":"Last slide","solutionModeTitle":"Exit solution mode","solutionModeText":"Solution Mode","summaryMultipleTaskText":"Multiple tasks","scoreMessage":"You achieved:","shareFacebook":"Share on Facebook","shareTwitter":"Share on Twitter","shareGoogle":"Share on Google+","summary":"Summary","solutionsButtonTitle":"Show comments","printTitle":"Print","printIngress":"How would you like to print this presentation?","printAllSlides":"Print all slides","printCurrentSlide":"Print current slide","noTitle":"No title","accessibilitySlideNavigationExplanation":"Use left and right arrow to change slide in that direction whenever canvas is selected.","accessibilityCanvasLabel":"Presentation canvas. Use left and right arrow to move between slides.","containsNotCompleted":"@slideName contains not completed interaction","containsCompleted":"@slideName contains completed interaction","slideCount":"Slide @index of @total","containsOnlyCorrect":"@slideName only has correct answers","containsIncorrectAnswers":"@slideName has incorrect answers","shareResult":"Share Result","accessibilityTotalScore":"You got @score of @maxScore points in total","accessibilityEnteredFullscreen":"Entered fullscreen","accessibilityExitedFullscreen":"Exited fullscreen"}}

Normalization - Its Purpose

Saif Terai