{"introPage":{"showIntroPage":false,"startButtonText":"Quiz starten","introduction":""},"progressType":"dots","passPercentage":50,"questions":[{"params":{"scoreShow":"\u00dcberpr\u00fcfen","tryAgain":"Wiederholen","scoreExplanation":"Richtige Antworten geben +1 Punkte. Bei falschen Antworten gibt es -1 Punkt. Die kleinstm\u00f6gliche Punktzahl ist 0.","question":{"settings":{"size":{"width":620,"height":310}},"task":{"elements":[{"x":67.87330316742083,"y":3.7678975131876413,"width":10.981603773584904,"height":2.9391509433962266,"dropZones":["0","1","2"],"type":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Klassenleiter - Klasse<\/p>\n"},"subContentId":"053599f2-173c-48ef-aa2d-d8d9f17570b2","metadata":{"contentType":"Text","license":"U","title":"Unbenannt: Text"}},"backgroundOpacity":100,"multiple":false},{"x":67.87330316742083,"y":30.14318010550113,"width":10.981603773584904,"height":2.9391509433962266,"dropZones":["0","1","2"],"type":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Sch\u00fcler - Klasse<\/p>\n"},"metadata":{"contentType":"Text","license":"U","title":"Unbenannt: Text"},"subContentId":"a88b4d6e-39db-4880-980a-e3afff41a535"},"backgroundOpacity":100,"multiple":false},{"x":45.248868778280546,"y":45.214770158251696,"width":10.981603773584904,"height":2.9391509433962266,"dropZones":["0","1","2"],"type":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Mutter - Kind<\/p>\n"},"metadata":{"contentType":"Text","license":"U","title":"Unbenannt: Text"},"subContentId":"2023e573-db47-44d9-9adc-9e513c90c467"},"backgroundOpacity":100,"multiple":false},{"x":69.75867269984919,"y":60.28636021100226,"width":10.981603773584904,"height":2.9391509433962266,"dropZones":["0","1","2"],"type":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Fahrer - Taxi<\/p>\n"},"metadata":{"contentType":"Text","license":"U","title":"Unbenannt: Text"},"subContentId":"960c95d1-80a7-48d2-9efd-d30c1726deb3"},"backgroundOpacity":100,"multiple":false},{"x":45.248868778280546,"y":18.839487565938207,"width":10.981603773584904,"height":2.9391509433962266,"dropZones":["0","1","2"],"type":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Tierpfleger - Tier<\/p>\n"},"metadata":{"contentType":"Text","license":"U","title":"Unbenannt: Text"},"subContentId":"05596c2a-6489-46ac-954e-f70c30a23e8f"},"backgroundOpacity":100,"multiple":false},{"x":45.248868778280546,"y":75.35795026375283,"width":10.981603773584904,"height":2.9391509433962266,"dropZones":["0","1","2"],"type":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Schauspieler - Serie<\/p>\n"},"metadata":{"contentType":"Text","license":"U","title":"Unbenannt: Text"},"subContentId":"26563c34-11cf-4702-b767-8193bd11e004"},"backgroundOpacity":100,"multiple":false}],"dropZones":[{"x":-2.3023446362445648e-6,"y":7.534612691627376,"width":15.35377358490566,"height":3.6556603773584904,"correctElements":["0","3"],"showLabel":true,"backgroundOpacity":100,"tipsAndFeedback":{"tip":""},"single":false,"autoAlign":false,"label":"

1:1 Beziehung<\/div>\n"},{"x":0,"y":45.214770158251696,"width":15.35377358490566,"height":3.6556603773584904,"correctElements":["1","2"],"showLabel":true,"backgroundOpacity":100,"tipsAndFeedback":{"tip":""},"single":false,"autoAlign":false,"label":"

1:n Beziehung<\/div>\n"},{"x":0,"y":81.00979653353428,"width":15.35377358490566,"height":3.6556603773584904,"correctElements":["4","5"],"showLabel":true,"backgroundOpacity":100,"tipsAndFeedback":{"tip":""},"single":false,"autoAlign":false,"label":"

n:m Beziehung<\/div>\n"}]}},"overallFeedback":[{"from":0,"to":100}],"behaviour":{"enableRetry":true,"enableCheckButton":true,"showSolutionsRequiresInput":true,"singlePoint":false,"applyPenalties":true,"enableScoreExplanation":true,"dropZoneHighlighting":"dragging","autoAlignSpacing":2,"enableFullScreen":false,"showScorePoints":true,"showTitle":true},"grabbablePrefix":"Ziehbares Element {num} von {total}.","grabbableSuffix":"Abgelegt in Ablagezone {num}.","dropzonePrefix":"Ablagezone {num} von {total}.","noDropzone":"Keine Ablagezone.","tipLabel":"Hinweis zeigen","tipAvailable":"Hinweis verf\u00fcgbar","correctAnswer":"Richtige Antwort","wrongAnswer":"Falsche Antwort","feedbackHeader":"R\u00fcckmeldung","scoreBarLabel":"Du hast :num von :total Punkten erreicht.","scoreExplanationButtonLabel":"Zeige Erkl\u00e4rung der Punktevergabe","localize":{"fullscreen":"Vollbild","exitFullscreen":"Vollbild beenden"}},"library":"H5P.DragQuestion 1.13","metadata":{"contentType":"Drag and Drop","license":"U","title":"Beziehungen zuordnen"},"subContentId":"7cc5114d-7425-4a74-939d-dc36a51688f5"},{"params":{"media":{"disableImageZooming":false},"text":"

Wie wird eine 1:n Beziehung im relationalen Modell umgesetzt?<\/p>\n","overallFeedback":[{"from":0,"to":100}],"showSolutions":"L\u00f6sung anzeigen","tryAgain":"Wiederholen","checkAnswer":"\u00dcberpr\u00fcfen","notFilledOut":"Bitte f\u00fclle alle L\u00fccken aus, um die L\u00f6sung ansehen zu k\u00f6nnen","answerIsCorrect":"':ans' ist korrekt","answerIsWrong":"':ans' ist falsch","answeredCorrectly":"Korrekt beantwortet","answeredIncorrectly":"Falsch beantwortet","solutionLabel":"Korrekte Antwort:","inputLabel":"L\u00fccke @num von @total","inputHasTipLabel":"Tipp verf\u00fcgbar","tipLabel":"Tipp","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"autoCheck":false,"caseSensitive":true,"showSolutionsRequiresInput":true,"separateLines":false,"confirmCheckDialog":false,"confirmRetryDialog":false,"acceptSpellingErrors":false},"scoreBarLabel":"Du hast :num von :total Punkten erreicht.","confirmCheck":{"header":"Beenden?","body":"Ganz sicher beenden?","cancelLabel":"Abbrechen","confirmLabel":"Beenden"},"confirmRetry":{"header":"Wiederholen?","body":"Ganz sicher wiederholen?","cancelLabel":"Abbrechen","confirmLabel":"Best\u00e4tigen"},"questions":["

Der *Prim\u00e4rschl\u00fcssel* der einen Tabelle *1* wird als *Fremdschl\u00fcssel* in der anderen Tabelle *n* gespeichert<\/p>\n"]},"library":"H5P.Blanks 1.12","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"Umsetzung 1:n"},"subContentId":"9a6f2844-7e1e-4f22-bb1f-0ccd8608ea93"},{"params":{"media":{"disableImageZooming":false},"text":"

Wie wird eine n:m Beziehung im relationalen Modell umgesetzt?<\/p>\n","overallFeedback":[{"from":0,"to":100}],"showSolutions":"L\u00f6sung anzeigen","tryAgain":"Wiederholen","checkAnswer":"\u00dcberpr\u00fcfen","notFilledOut":"Bitte f\u00fclle alle L\u00fccken aus, um die L\u00f6sung ansehen zu k\u00f6nnen","answerIsCorrect":"':ans' ist korrekt","answerIsWrong":"':ans' ist falsch","answeredCorrectly":"Korrekt beantwortet","answeredIncorrectly":"Falsch beantwortet","solutionLabel":"Korrekte Antwort:","inputLabel":"L\u00fccke @num von @total","inputHasTipLabel":"Tipp verf\u00fcgbar","tipLabel":"Tipp","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"autoCheck":false,"caseSensitive":true,"showSolutionsRequiresInput":true,"separateLines":false,"confirmCheckDialog":false,"confirmRetryDialog":false,"acceptSpellingErrors":false},"scoreBarLabel":"Du hast :num von :total Punkten erreicht.","confirmCheck":{"header":"Beenden?","body":"Ganz sicher beenden?","cancelLabel":"Abbrechen","confirmLabel":"Beenden"},"confirmRetry":{"header":"Wiederholen?","body":"Ganz sicher wiederholen?","cancelLabel":"Abbrechen","confirmLabel":"Best\u00e4tigen"},"questions":["

Es wird eine *Beziehungstabelle* neu eingef\u00fchrt, in der die *Prim\u00e4rschl\u00fcssel* der miteinander in Beziehung stehenden Tabellen gespeichert werden.<\/p>\n"]},"library":"H5P.Blanks 1.12","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"Umsetzung n:m"},"subContentId":"d0d36cd8-3fb1-4ac8-83ad-e2ecd349d46a"},{"params":{"media":{"disableImageZooming":false},"answers":[{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"

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

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

Prim\u00e4rschl\u00fcssel angeben<\/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":"\u00dcberpr\u00fcfen","showSolutionButton":"L\u00f6sung anzeigen","tryAgainButton":"Wiederholen","tipsLabel":"Hinweis anzeigen","scoreBarLabel":"Du hast :num von :total Punkten erreicht.","tipAvailable":"Hinweis verf\u00fcgbar","feedbackAvailable":"R\u00fcckmeldung verf\u00fcgbar","readFeedback":"R\u00fcckmeldung vorlesen","wrongAnswer":"Falsche Antwort","correctAnswer":"Richtige Antwort","shouldCheck":"H\u00e4tte gew\u00e4hlt werden m\u00fcssen","shouldNotCheck":"H\u00e4tte nicht gew\u00e4hlt werden sollen","noInput":"Bitte antworte, bevor du die L\u00f6sung ansiehst"},"confirmCheck":{"header":"Beenden?","body":"Ganz sicher beenden?","cancelLabel":"Abbrechen","confirmLabel":"Beenden"},"confirmRetry":{"header":"Wiederholen?","body":"Ganz sicher wiederholen?","cancelLabel":"Abbrechen","confirmLabel":"Best\u00e4tigen"},"question":"

Wie kannst du in einer Abfrage mehrere Tabellen sinnvoll miteinander verkn\u00fcpfen, d.h. ohne, dass falsche Datens\u00e4tze entstehen?<\/p>\n"},"library":"H5P.MultiChoice 1.14","metadata":{"contentType":"Multiple Choice","license":"U","title":"Abfrage 1:n allgemein"},"subContentId":"e585bd66-308e-4e4f-a75a-00566aa832b4"},{"params":{"media":{"disableImageZooming":false},"text":"

Gegeben sind die beiden folgenden Tabellen:<\/p>\n\n

Bundesland[Name<\/u>, Hauptstadt, Flaeche, Einwohner]<\/p>\n\n

Stadt[Nr<\/u>, Name, Einwohner]<\/p>\n\n

(In der Tabelle Bundesland wird die Hauptstadt \u00fcber ihre Nummer gespeichert)<\/p>\n\n

Formuliere die folgende Anfrage:<\/p>\n\n

Wie viele Einwohner hat die Hauptstadt von Bayern?<\/p>\n","overallFeedback":[{"from":0,"to":100}],"showSolutions":"L\u00f6sung anzeigen","tryAgain":"Wiederholen","checkAnswer":"\u00dcberpr\u00fcfen","notFilledOut":"Bitte f\u00fclle alle L\u00fccken aus, um die L\u00f6sung ansehen zu k\u00f6nnen","answerIsCorrect":"':ans' ist korrekt","answerIsWrong":"':ans' ist falsch","answeredCorrectly":"Korrekt beantwortet","answeredIncorrectly":"Falsch beantwortet","solutionLabel":"Korrekte Antwort:","inputLabel":"L\u00fccke @num von @total","inputHasTipLabel":"Tipp verf\u00fcgbar","tipLabel":"Tipp","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"autoCheck":false,"caseSensitive":true,"showSolutionsRequiresInput":true,"separateLines":false,"confirmCheckDialog":false,"confirmRetryDialog":false,"acceptSpellingErrors":false},"scoreBarLabel":"Du hast :num von :total Punkten erreicht.","confirmCheck":{"header":"Beenden?","body":"Ganz sicher beenden?","cancelLabel":"Abbrechen","confirmLabel":"Beenden"},"confirmRetry":{"header":"Wiederholen?","body":"Ganz sicher wiederholen?","cancelLabel":"Abbrechen","confirmLabel":"Best\u00e4tigen"},"questions":["

SELECT *Name\/Einwohner* , *Einwohner\/Name*<\/p>\n\n

FROM *Bundesland\/Stadt* , *Stadt\/Bundesland*<\/p>\n\n

WHERE *Bundesland.Hauptstadt = Stadt.Nr\/Bundesland.Name = \"Bayern\"*<\/p>\n\n

AND *Bundesland.Hauptstadt = Stadt.Nr\/Bundesland.Name = \"Bayern\"*<\/p>\n"]},"library":"H5P.Blanks 1.12","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"Abfrage 1:n - 1"},"subContentId":"fb847145-d9ff-490a-93b8-4fb5188f463b"}],"disableBackwardsNavigation":false,"randomQuestions":false,"endGame":{"showResultPage":true,"showSolutionButton":true,"showRetryButton":true,"noResultMessage":"Quiz beendet","message":"Dein Ergebnis:","overallFeedback":[{"from":0,"to":100}],"solutionButtonText":"L\u00f6sung anzeigen","retryButtonText":"Wiederholen","finishButtonText":"Beenden","showAnimations":false,"skippable":false,"skipButtonText":"Video \u00fcberspringen"},"override":{"checkButton":true},"texts":{"prevButton":"Zur\u00fcck","nextButton":"Weiter","finishButton":"Beenden","textualProgress":"Aktuelle Frage: @current von @total Fragen","jumpToQuestion":"Frage %d von %total","questionLabel":"Frage","readSpeakerProgress":"Frage @current von @total","unansweredText":"Unbeantwortet","answeredText":"Beantwortet","currentQuestionText":"Aktuelle Frage"}}

Relationale Datenbanken - Beziehungen zwischen Klassen, Umsetzung, Abfragen