{"presentation":{"slides":[{"elements":[{"x":18.51851851851852,"y":32.25806451612903,"width":60.67538126361656,"height":18.924731182795696,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"

Garage Shop - Normalization Exercise<\/span><\/h2>\n"},"subContentId":"c6ab18f6-409d-4923-8854-8fc4e8e54381","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":4.778972520908005,"y":84.7877358490566,"width":89.3667861409797,"height":5.188679245283018,"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-5e79516622075.wav","mime":"audio\/x-wav","copyright":{"license":"U"}}]},"subContentId":"c5872880-1749-45e4-b7e4-946dd703b54b","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":23.965141612200437,"y":2.1438172043010755,"width":52.06971677559913,"height":95.05376344086021,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e79200693a20.png","mime":"image\/png","copyright":{"license":"U"},"width":926,"height":855}},"subContentId":"0c0bd8ad-59c6-4a7b-b19d-847486f0de16","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":2.3894862604540026,"y":89.62264150943396,"width":18.87694145758662,"height":5.188679245283018,"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-5e7951f9e7c6f.wav","mime":"audio\/x-wav","copyright":{"license":"U"}}]},"subContentId":"5e07a82f-c5fb-4cb1-af35-b0bb22d4a4c0","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":22.875816993464053,"y":30.10752688172043,"width":53.15904139433551,"height":31.82795698924731,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
\n\t
Pause for a moment and draw a Logical ERD on paper based on the given abstract and business rules.<\/li>\n\t
See how your diagram differs from the Physical ERD.<\/li>\n<\/ol>\n"},"subContentId":"f4e9b80e-80d3-4afe-b2c7-eff44c04f243","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":23.894862604540023,"y":75.3686320754717,"width":63.08243727598567,"height":5.188679245283018,"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-5e795287ac581.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"b9b261be-1c92-4156-a210-f2fa3a84aecd","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":-0.23894862604540026,"y":30.660377358490564,"width":100,"height":40,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e7920ae5263b.png","mime":"image\/png","copyright":{"license":"U"},"width":1390,"height":272}},"subContentId":"6812f195-8a04-4277-bb1b-36e24fe740c8","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":9.55794504181601,"y":82.54716981132076,"width":76.22461170848268,"height":5.188679245283018,"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-5e7954649032a.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"8c804a34-a4d6-4611-8f90-e7c0198eeb65","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":0,"y":29.784946236559136,"width":100,"height":33.54838709677419,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e7929cea0bf3.png","mime":"image\/png","copyright":{"license":"U"},"width":1801,"height":156}},"subContentId":"05a7cdc5-d97e-461f-8029-866325d0d3b3","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":14.336917562724013,"y":84.7877358490566,"width":70.25089605734767,"height":5.188679245283018,"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-5e7955508dda9.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"1bde86c4-7eaa-4a8a-9d9a-dcbe6b37e659","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":0,"y":27.956989247311824,"width":98.91067538126362,"height":33.33333333333333,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e79295f0c0b7.png","mime":"image\/png","copyright":{"license":"U"},"width":1801,"height":156}},"subContentId":"6ffbeff3-5a5a-4db0-b29c-fadf798474b0","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":48.566308243727605,"y":47.16981132075472,"width":2.577632696,"height":5.091753604,"action":{"library":"H5P.Audio 1.5","params":{"fitToWrapper":true,"playerMode":"transparent","controls":true,"autoplay":true,"playAudio":"Play audio","pauseAudio":"Pause audio","contentName":"Audio","audioNotSupported":"Your browser does not support this audio","files":[{"path":"audios\/files-5e79564bbb476.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"50d4f01a-80ae-490c-bba8-4e751b597894","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":7.625272331154684,"y":12.883075268817205,"width":64.37908496732027,"height":29.677419354838708,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
2NF<\/span><\/h2>\n\n
Remove Partial Functional Dependencies<\/span><\/h2>\n"},"subContentId":"90564350-40d0-43e5-a9b7-259608ddabcd","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":7.625272331154684,"y":40.78967741935484,"width":86.9281045751634,"height":31.82795698924731,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
\n\t
\n\t
Group all attributes associated with Invoice Number<\/span><\/h3>\n\t<\/li>\n\t
\n\t
Group all attributes associated with Invoice Number + Problem ID<\/span><\/h3>\n\t<\/li>\n<\/ol>\n\n
<\/p>\n\n
<\/p>\n"},"subContentId":"40bb8972-583b-4fdd-8043-f5b8caa61ea7","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":8.363201911589007,"y":82.43655660377358,"width":82.19832735961769,"height":5.188679245283018,"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-5e795789e9b4b.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"3328fccd-86d6-4dd9-be78-5d392cf9c1c9","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":1.0893246187363834,"y":15.033612903225807,"width":98.69281045751634,"height":53.76344086021505,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e792a4d7b492.png","mime":"image\/png","copyright":{"license":"U"},"width":1043,"height":287}},"subContentId":"99d494cb-4fa4-4469-882d-8326d46e2c82","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":7.168458781362006,"y":82.43655660377358,"width":85.7825567502987,"height":5.188679245283018,"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-5e79581f8f0eb.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"8840960f-002d-45f2-8d4d-c861a2f5cc53","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":9.803921568627452,"y":12.903225806451612,"width":64.37908496732027,"height":29.677419354838708,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
3NF<\/span><\/h2>\n\n
Remove Transitive Dependencies<\/span><\/h2>\n"},"metadata":{"contentType":"Text","license":"U","title":"Untitled Text"},"subContentId":"5bc1dd8b-c13d-4e01-81e4-aae41eb4588d"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":10.75268817204301,"y":70.65896226415094,"width":77.41935483870968,"height":5.188679245283018,"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-5e7958f6a2fd5.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"ea8be899-c14b-48dc-b52a-ea022252c889","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":17.429193899782135,"y":15.053763440860214,"width":57.51633986928105,"height":74.19354838709677,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e793108b3e04.png","mime":"image\/png","copyright":{"license":"U"},"width":2732,"height":2048}},"subContentId":"1e4ccef8-f12d-4a63-97b0-e361825074da","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":48.566308243727605,"y":47.16981132075472,"width":2.577632696,"height":5.091753604,"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-5e795b394c690.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"6701d251-678e-4cc8-afb6-0e1d12702c98","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"slideBackgroundSelector":{},"elements":[{"x":4.778972520908005,"y":11.79245283018868,"width":65.50950319393822,"height":40,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e793205da9ad.png","mime":"image\/png","copyright":{"license":"U"},"width":702,"height":217}},"subContentId":"512f267c-b3ae-49c0-888e-8cccccf78681","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":14.336917562724013,"y":77.72334905660378,"width":29.629629629629633,"height":5.188679245283018,"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-5e795bd1361c0.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"4110b1c1-bdfd-4295-a28c-101ea0cf13b5","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":76.46356033452808,"y":61.32075471698113,"width":18.51851851851852,"height":16.037735849056602,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e793486a7176.png","mime":"image\/png","copyright":{"license":"U"},"width":362,"height":160}},"metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"6190bdd8-ab5d-4b11-9c3c-406378ff2717"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}]},{"slideBackgroundSelector":{},"elements":[{"x":13.142174432497015,"y":16.50943396226415,"width":39.41146274773016,"height":34.40860215053763,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e793486a7176.png","mime":"image\/png","copyright":{"license":"U"},"width":362,"height":160}},"subContentId":"f77ea8cb-febd-4d40-a908-b246497ee929","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":71.68458781362008,"y":75.47169811320754,"width":24.611708482676228,"height":16.27358490566038,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e7934d9050d4.png","mime":"image\/png","copyright":{"license":"U"},"width":489,"height":166}},"metadata":{"contentType":"Image","license":"U","title":"Untitled Image"},"subContentId":"84262c19-9a01-49ad-8ceb-862e2917d4df"},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}]},{"elements":[{"x":20.697167755991288,"y":30.10752688172043,"width":53.238136142652074,"height":35.69892473118279,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e7934d9050d4.png","mime":"image\/png","copyright":{"license":"U"},"width":489,"height":166}},"subContentId":"380c21c4-0b0a-4dd8-8b17-845be227879c","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":0,"y":29.784946236559136,"width":100,"height":39.354838709677416,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e7935212affa.png","mime":"image\/png","copyright":{"license":"U"},"width":962,"height":183}},"subContentId":"73a39f43-a4c6-4d68-aa55-a3c5573b866f","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":9.55794504181601,"y":84.7877358490566,"width":82.19832735961769,"height":5.188679245283018,"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-5e795ebbb127f.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"d24e120f-ec62-4031-92cc-f907fbaecf6b","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":0,"y":29.784946236559136,"width":100,"height":35.053763440860216,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e793554cc767.png","mime":"image\/png","copyright":{"license":"U"},"width":1430,"height":163}},"subContentId":"e7ecad6a-4595-49ed-b5dc-3faf3a4a213b","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":10.75268817204301,"y":84.7877358490566,"width":65.47192353643968,"height":5.188679245283018,"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-5e79604c661ee.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"b1c6c99f-5542-4f1e-ade7-f18fe2c0d2c4","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":25.05446623093682,"y":15.053763440860214,"width":53.15904139433551,"height":72.68817204301075,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Number of Records in each table.<\/span><\/h2>\n\n
Customer_T - <\/span>2<\/span> records<\/span><\/h2>\n\n
Vehicle_T - <\/span>2<\/span> Records<\/span><\/h2>\n\n
Mechanic_T - <\/span>4<\/span> Records<\/span><\/h2>\n\n
Invoice_T - <\/span>2<\/span> Records<\/span><\/h2>\n\n
Problem_T - <\/span>5<\/span> Records<\/span><\/h2>\n\n
<\/p>\n"},"subContentId":"6098b518-cf2d-477f-9b37-79bdcd3a2733","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":5.973715651135006,"y":89.49740566037735,"width":84.5878136200717,"height":5.188679245283018,"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-5e7960a2719c6.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"f0896a69-be54-4c58-bdf6-a6123c8e8c95","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":10.893246187363834,"y":25.77290322580645,"width":77.12418300653594,"height":59.784946236559136,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Study the DDL & DML Files.<\/span><\/h2>\n\n
Create a database and run the DDL & DML files.<\/span><\/h2>\n\n
Reverse Engineer the database. Study the ERD.<\/span><\/h2>\n\n
The link is on the next slide.<\/span> <\/h2>\n\n
<\/h2>\n"},"subContentId":"ceaae0e8-e9bb-4457-bf2e-b023e84fa47f","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":7.168458781362006,"y":91.85589622641508,"width":85.7825567502987,"height":5.188679245283018,"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-5e79610e5aa07.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"630bc639-6f58-492b-ae64-7c95bdd0753d","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":29.411764705882355,"y":30.06731182795699,"width":46.62309368191721,"height":8.172043010752688,"action":{"library":"H5P.Link 1.3","params":{"linkWidget":{"protocol":"https:\/\/","url":"algonquinlivecom-my.sharepoint.com\/:f:\/g\/personal\/terais_algonquincollege_com\/ElakxhgRJcBOtuNK8tmoPPUBnUvXxkSp-Tr20RdzL-fuGQ?e=DLqfnJ"},"title":"Garage Shop DDL, DML, query and JOIN files."},"subContentId":"33207342-d952-45fe-8c6a-2793d11fc8a5","metadata":{"contentType":"Link","license":"U"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":33.452807646356035,"y":49.52830188679245,"width":39.97821350762527,"height":9.462365591397848,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
ERD from Toad is on the next slide.<\/p>\n"},"subContentId":"c642269e-3591-49d5-ac21-50fc81bcad57","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":25.05446623093682,"y":8.602150537634408,"width":45.53376906318083,"height":16.774193548387096,"action":{"library":"H5P.AdvancedText 1.1","params":{"text":"
Use this link to access the DDL, DML and query files.<\/p>\n\n
Run each of the JOIn statements independently. <\/p>\n"},"subContentId":"103d833d-82fd-432a-a73f-f6fbfde3e263","metadata":{"contentType":"Text","license":"U","title":"Untitled Text"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}},{"elements":[{"x":19.607843137254903,"y":4.301075268817204,"width":58.60566448801743,"height":92.04301075268816,"action":{"library":"H5P.Image 1.1","params":{"contentName":"Image","file":{"path":"images\/file-5e792d4a48926.png","mime":"image\/png","copyright":{"license":"U"},"width":938,"height":746}},"subContentId":"6835af00-f355-4fab-ac05-8c3f6341695a","metadata":{"contentType":"Image","license":"U","title":"Untitled Image"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""},{"x":78.85304659498208,"y":87.14622641509435,"width":18.87694145758662,"height":5.188679245283018,"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-5e796266b2f70.mp3","mime":"audio\/mpeg","copyright":{"license":"U"}}]},"subContentId":"3e9a5fcf-bfe9-4944-949e-61776bf627ed","metadata":{"contentType":"Audio","license":"U","title":"Untitled Audio"}},"alwaysDisplayComments":false,"backgroundOpacity":0,"displayAsButton":false,"buttonSize":"big","goToSlideType":"specified","invisible":false,"solution":""}],"slideBackgroundSelector":{}}],"keywordListEnabled":true,"globalBackgroundSelector":{},"keywordListAlwaysShow":false,"keywordListAutoHide":false,"keywordListOpacity":90},"override":{"activeSurface":false,"hideSummarySlide":false,"summarySlideSolutionButton":true,"summarySlideRetryButton":true,"enablePrintButton":false,"social":{"showFacebookShare":false,"facebookShare":{"url":"@currentpageurl","quote":"I scored @score out of @maxScore on a task at @currentpageurl."},"showTwitterShare":false,"twitterShare":{"statement":"I scored @score out of @maxScore on a task at @currentpageurl.","url":"@currentpageurl","hashtags":"h5p, course"},"showGoogleShare":false,"googleShareUrl":"@currentpageurl"}},"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"}}

Garage Shop Normalization Exercise

Saif Terai