{"interactiveVideo":{"video":{"startScreenOptions":{"title":"Interactive Video","hideStartTitle":false},"textTracks":{"videoTrack":[{"label":"Subtitles","kind":"subtitles","srcLang":"en"}]},"files":[{"path":"videos\/files-5f076c62372f6.mp4","mime":"video\/mp4","copyright":{"license":"CC BY","version":"4.0"},"metadata":{"qualityName":"720p"}}]},"assets":{"interactions":[{"x":65.50218340611353,"y":73.64341085271317,"width":10,"height":10,"duration":{"from":856.519,"to":866.519},"libraryTitle":"Link","action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"conestoga.desire2learn.com\/d2l\/le\/content\/456176\/viewContent\/9477342\/View"},"title":"Normalization Example"},"subContentId":"4f14f0f6-a93a-44c1-b15b-002764f4d395","metadata":{"contentType":"Link","license":"U"}},"displayType":"poster","visuals":{"backgroundColor":"rgba(0,0,0,0.5)","boxShadow":true},"pause":false,"buttonOnMobile":false},{"x":34.93449781659388,"y":42.63565891472868,"width":10,"height":10,"duration":{"from":157.435,"to":159.435},"libraryTitle":"Text","action":{"library":"H5P.Text 1.1","params":{"text":"

Stop and think here. What column or columns would uniquely identify every row in this new table?<\/p>\n"},"subContentId":"fbf210ba-67db-4318-9539-4af5fcd0d9ae","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"visuals":{"backgroundColor":"rgb(255, 255, 255)","boxShadow":true},"goto":{"url":{"protocol":"http:\/\/"},"visualize":false,"type":""},"label":""},{"x":44.75982532751092,"y":23.25581395348837,"width":20.960698689956335,"height":14.23580786026201,"duration":{"from":212.051,"to":214.051},"libraryTitle":"Multiple Choice","action":{"library":"H5P.MultiChoice 1.16","params":{"media":{"disableImageZooming":false},"answers":[{"correct":true,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"

VendorName<\/div>\n"},{"correct":false,"tipsAndFeedback":{"chosenFeedback":"

InvoiceNumber and ItemDescription form our composite primary key. So VendorName is a non-key column.<\/div>\n","tip":"","notChosenFeedback":""},"text":"

InvoiceNumber<\/div>\n"},{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"

InvoiceNumber and ItemDescription form our composite primary key. So VendorName is a non-key column.<\/div>\n","notChosenFeedback":""},"text":"

ItemDescription<\/div>\n"}],"overallFeedback":[{"from":0,"to":100}],"behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"type":"auto","singlePoint":false,"randomAnswers":true,"showSolutionsRequiresInput":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"passPercentage":100,"showScorePoints":true},"UI":{"checkAnswerButton":"Check","showSolutionButton":"Show solution","tryAgainButton":"Retry","tipsLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","tipAvailable":"Tip available","feedbackAvailable":"Feedback available","readFeedback":"Read feedback","wrongAnswer":"Wrong answer","correctAnswer":"Correct answer","shouldCheck":"Should have been checked","shouldNotCheck":"Should not have been checked","noInput":"Please answer before viewing the solution","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"

Which of the columns in our table is a non-key column?<\/p>\n"},"subContentId":"87207ef6-eefc-485d-8b33-b5b0a24b4cbc","metadata":{"contentType":"Multiple Choice","license":"U","title":"Non-key columns Multiple Choice"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":48.03493449781659,"y":25.23047064531781,"width":17.03056768558952,"height":14.74413209606987,"duration":{"from":229.917,"to":231.917},"libraryTitle":"True\/False Question","action":{"library":"H5P.TrueFalse 1.8","params":{"media":{"disableImageZooming":false},"correct":"false","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"feedbackOnWrong":"VendorName depends on InvoiceNumber, but not ItemDescription.","feedbackOnCorrect":"VendorName depends on InvoiceNumber, but not ItemDescription."},"l10n":{"trueText":"True","falseText":"False","score":"You got @score of @total points","checkAnswer":"Check","showSolutionButton":"Show solution","tryAgain":"Retry","wrongAnswerMessage":"Wrong answer","correctAnswerMessage":"Correct answer","scoreBarLabel":"You got :num out of :total points","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"

VendorName depends on BOTH InvoiceNumber and ItemDescription?<\/p>\n"},"subContentId":"18ac8bb4-ec77-4d40-9d68-2e63841b2bb9","metadata":{"contentType":"True\/False Question","license":"U","title":"2NF True\/False Question"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":47.81659388646288,"y":27.171276079573023,"width":18.340611353711793,"height":14.220114628820962,"duration":{"from":423.452,"to":425.452},"libraryTitle":"Multiple Choice","action":{"library":"H5P.MultiChoice 1.16","params":{"media":{"disableImageZooming":false},"answers":[{"correct":true,"tipsAndFeedback":{"chosenFeedback":"

VendorPhone and other vendor values depend on the identity of the Vendor, not so much what Invoice record they belong to (InvoiceID).<\/div>\n","tip":"","notChosenFeedback":""},"text":"

VendorName<\/div>\n"},{"correct":false,"tipsAndFeedback":{"chosenFeedback":"

VendorPhone and other vendor values depend on the identity of the Vendor, not so much what Invoice record they belong to (InvoiceID).<\/div>\n","tip":"","notChosenFeedback":""},"text":"

InvoiceID<\/div>\n"}],"overallFeedback":[{"from":0,"to":100}],"behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"type":"auto","singlePoint":false,"randomAnswers":true,"showSolutionsRequiresInput":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"passPercentage":100,"showScorePoints":true},"UI":{"checkAnswerButton":"Check","showSolutionButton":"Show solution","tryAgainButton":"Retry","tipsLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","tipAvailable":"Tip available","feedbackAvailable":"Feedback available","readFeedback":"Read feedback","wrongAnswer":"Wrong answer","correctAnswer":"Correct answer","shouldCheck":"Should have been checked","shouldNotCheck":"Should not have been checked","noInput":"Please answer before viewing the solution","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"

The value of VendorPhone primarily depends on which column?<\/p>\n"},"subContentId":"b445551a-981f-4291-97c5-22c9b473234c","metadata":{"contentType":"Multiple Choice","license":"U","title":"3NF Multiple Choice"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":2.1834061135371177,"y":3.8755458515283845,"width":10.480349344978167,"height":17.03056768558952,"duration":{"from":606.419,"to":608.419},"libraryTitle":"Multiple Choice","action":{"library":"H5P.MultiChoice 1.16","params":{"media":{"disableImageZooming":false},"answers":[{"correct":true,"tipsAndFeedback":{"chosenFeedback":"","tip":"","notChosenFeedback":""},"text":"

TermsID<\/div>\n"},{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"

VendorID<\/div>\n"}],"overallFeedback":[{"from":0,"to":100}],"behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"type":"auto","singlePoint":false,"randomAnswers":true,"showSolutionsRequiresInput":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"passPercentage":100,"showScorePoints":true},"UI":{"checkAnswerButton":"Check","showSolutionButton":"Show solution","tryAgainButton":"Retry","tipsLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","tipAvailable":"Tip available","feedbackAvailable":"Feedback available","readFeedback":"Read feedback","wrongAnswer":"Wrong answer","correctAnswer":"Correct answer","shouldCheck":"Should have been checked","shouldNotCheck":"Should not have been checked","noInput":"Please answer before viewing the solution","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"

Do TermsDescription and TermsDueDays depend on TermsID or VendorID?<\/p>\n"},"subContentId":"0fff2dc5-7819-492c-89d9-70abcc92cb3f","metadata":{"contentType":"Multiple Choice","license":"U","title":"3NF introducing an ID column Multiple Choice"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":0,"y":0,"width":39.737991266375545,"height":22.53275109170306,"duration":{"from":816.14,"to":818.14},"libraryTitle":"Drag Text","action":{"library":"H5P.DragText 1.10","params":{"taskDescription":"

Match the normal form with the goal each form achieves<\/p>\n","overallFeedback":[{"from":0,"to":100}],"checkAnswer":"Check","tryAgain":"Retry","showSolution":"Show solution","dropZoneIndex":"Drop Zone @index.","empty":"Drop Zone @index is empty.","contains":"Drop Zone @index contains draggable @draggable.","ariaDraggableIndex":"@index of @count draggables.","tipLabel":"Show tip","correctText":"Correct!","incorrectText":"Incorrect!","resetDropTitle":"Reset drop","resetDropDescription":"Are you sure you want to reset this drop zone?","grabbed":"Draggable is grabbed.","cancelledDragging":"Cancelled dragging.","correctAnswer":"Correct answer:","feedbackHeader":"Feedback","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"instantFeedback":false},"scoreBarLabel":"You got :num out of :total points","textField":"In *first-normal form (1NF)*, non-atomic columns and repeating columns are made into a single atomic column.\n\nIn *second-normal form (2NF)*, any partial functional dependencies (non-key columns depending on only a part of a composite primary key) are eliminated.\n\nIn *third-normal form (3NF)*, any transitive functional dependencies (non-key columns that depend transitively on the primary key, but directly with another non-key column) are eliminated.","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"subContentId":"624dc391-f33e-415f-9131-07451e5c5551","metadata":{"contentType":"Drag Text","license":"U","title":"Normalization Drag Text"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""}],"endscreens":[{"time":901.674667,"label":"15:01 Submit screen"}]},"summary":{"task":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"8390a96f-619b-4b9c-ae8a-7c72b4043957","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":"93be262f-7dbf-4dac-87f8-7547bde7c640","metadata":{"contentType":"Summary","license":"U","title":"Untitled Summary"}},"displayAt":3}},"override":{"autoplay":false,"loop":false,"showBookmarksmenuOnLoad":false,"showRewind10":false,"deactivateSound":false,"preventSkippingMode":"none"},"l10n":{"interaction":"Interaction","play":"Play","pause":"Pause","mute":"Mute","unmute":"Unmute","quality":"Video Quality","captions":"Captions","close":"Close","fullscreen":"Fullscreen","exitFullscreen":"Exit Fullscreen","summary":"Open summary dialog","bookmarks":"Bookmarks","endscreen":"Submit screen","defaultAdaptivitySeekLabel":"Continue","continueWithVideo":"Continue with video","playbackRate":"Playback Rate","rewind10":"Rewind 10 Seconds","navDisabled":"Navigation is disabled","sndDisabled":"Sound is disabled","requiresCompletionWarning":"You need to answer all the questions correctly before continuing.","back":"Back","hours":"Hours","minutes":"Minutes","seconds":"Seconds","currentTime":"Current time:","totalTime":"Total time:","singleInteractionAnnouncement":"Interaction appeared:","multipleInteractionsAnnouncement":"Multiple interactions appeared.","videoPausedAnnouncement":"Video is paused","content":"Content","answered":"@answered answered","endcardTitle":"@answered Question(s) answered","endcardInformation":"You have answered @answered questions, click below to submit your answers.","endcardInformationNoAnswers":"You have not answered any questions.","endcardInformationMustHaveAnswer":"You have to answer at least one question before you can submit your answers.","endcardSubmitButton":"Submit Answers","endcardSubmitMessage":"Your answers have been submitted!","endcardTableRowAnswered":"Answered questions","endcardTableRowScore":"Score","endcardAnsweredScore":"answered","endCardTableRowSummaryWithScore":"You got @score out of @total points for the @question that appeared after @minutes minutes and @seconds seconds.","endCardTableRowSummaryWithoutScore":"You have answered the @question that appeared after @minutes minutes and @seconds seconds."}}

Designing Relational Databases - Step 5 Normalization

Chris Lo