{"interactiveVideo":{"video":{"startScreenOptions":{"title":"Interactive Video","hideStartTitle":false},"textTracks":{"videoTrack":[{"label":"Subtitles","kind":"subtitles","srcLang":"en"}]},"files":[{"path":"videos\/files-5f0767a15ce0d.mp4","mime":"video\/mp4","copyright":{"license":"CC BY","version":"4.0"},"metadata":{"qualityName":"720p"}}]},"assets":{"interactions":[{"x":24.017467248908297,"y":38.81610868510432,"width":19.519650655021834,"height":11.60002729257642,"duration":{"from":106.425,"to":108.425},"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":"Foreign key columns simply refer to primary keys from another table. The values (i.e. IDs of another table) usually will repeat in foreign key columns when there is a one-to-many cardinality between the two tables."},"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":"

Columns designated as foreign keys have to contain unique values like primary keys?<\/p>\n"},"subContentId":"e7cb60ee-dcc8-4a45-b7cb-1a190077d4e6","metadata":{"contentType":"True\/False Question","license":"U","title":"Foreign Keys True\/False Question"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":5.458515283842795,"y":40.69767441860465,"width":10,"height":10,"duration":{"from":176.611,"to":178.611},"libraryTitle":"Text","action":{"library":"H5P.Text 1.1","params":{"text":"

Take the time to write all the useful data elements we can store in our database from this invoice document.<\/p>\n"},"subContentId":"32e932ed-6821-4965-810e-c3bf118a3bae","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":54.585152838427945,"y":17.441860465116278,"width":17.77292576419214,"height":15.093477074235809,"duration":{"from":429.593,"to":431.593},"libraryTitle":"Multiple Choice","action":{"library":"H5P.MultiChoice 1.16","params":{"media":{"disableImageZooming":false},"answers":[{"correct":true,"tipsAndFeedback":{"tip":"","chosenFeedback":"

We expect a vendor to issue many invoices. <\/div>\n","notChosenFeedback":""},"text":"

One-to-many<\/div>\n"},{"correct":false,"tipsAndFeedback":{"chosenFeedback":"

It is not one-to-one because we are not expecting each vendor to only have one Invoice.<\/div>\n","tip":"","notChosenFeedback":""},"text":"

One-to-one<\/div>\n"},{"correct":false,"tipsAndFeedback":{"chosenFeedback":"

It is not many-to-many, because we don\u2019t expect an Invoice to have several vendors. <\/div>\n","tip":"","notChosenFeedback":""},"text":"

Many-to-many<\/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":"

What is the cardinality between the two tables Vendors and Invoices?<\/p>\n"},"subContentId":"1325ea3d-f730-4f4a-81c6-7adccc1a8382","metadata":{"contentType":"Multiple Choice","license":"U","title":"Cardinality Multiple Choice"}},"pause":true,"displayType":"poster","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":""},{"x":38.209606986899566,"y":77.51937984496124,"width":10,"height":10,"duration":{"from":558.7,"to":563},"libraryTitle":"Link","action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"conestoga.desire2learn.com\/d2l\/le\/content\/456176\/viewContent\/9477344\/View"},"title":"Next video part: Step 5 - Normalizing the database"},"subContentId":"f8b7844e-ecf3-481e-b54f-a2b379314337","metadata":{"contentType":"Link","license":"U"}},"displayType":"poster","visuals":{"backgroundColor":"rgba(0,0,0,0.5)","boxShadow":true},"pause":false,"buttonOnMobile":false}],"endscreens":[{"time":563.456,"label":"9:23 Submit screen"}]},"summary":{"task":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"da8aa4be-00d8-4e1b-ab02-b120caecaf46","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":"3a082d27-4bcc-400f-a73a-d357a2abe634","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 - Steps 1 to 4

Chris Lo