MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_01C67739.16084600" This document is a Web archive file. If you are seeing this message, this means your browser or editor doesn't support Web archive files. For more information on the Web archive format, go to http://officeupdate.microsoft.com/office/webarchive.htm ------=_NextPart_01C67739.16084600 Content-Location: file:///C:/EB26A0D4/EnforcingDataintegrityProject.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" Data Integrity

PROJECT

Enforcing Data Integrity

 

Overview

3D---

In this project, you will review and modify t= he Conference Room database to include data integrity constraints.<= /span>

 <= /span>

Scenario

3D---

Consider these factors while doing the project:

 

<= img width=3D17 height=3D17 src=3D"EnforcingDataintegrityProject_files/image001.= gif" alt=3D"*">   &n= bsp; The rooms are available only during Monday to Friday 8 to 5

<= img width=3D17 height=3D17 src=3D"EnforcingDataintegrityProject_files/image001.= gif" alt=3D"*">   &n= bsp; Reasonable limits should be placed on columns= (ex. Whiteboards < 10)

<= img width=3D17 height=3D17 src=3D"EnforcingDataintegrityProject_files/image001.= gif" alt=3D"*">   &n= bsp; Default values should be added to make data e= ntry easier

<= img width=3D17 height=3D17 src=3D"EnforcingDataintegrityProject_files/image001.= gif" alt=3D"*">   &n= bsp; Verify that all Not Null, Foreign and Primary= Keys constraints are in place

<= img width=3D17 height=3D17 src=3D"EnforcingDataintegrityProject_files/image001.= gif" alt=3D"*">   &n= bsp; Identify and implement any Unique constraints=

<= img width=3D17 height=3D17 src=3D"EnforcingDataintegrityProject_files/image001.= gif" alt=3D"*">   &n= bsp; A web interface is NOT required in this project (This will be done later)

 

Outcome

3D---

The project should be con= sidered done when the following is complete:

 

3D"*"     You have updated a schema that describes the database

3D"*"     You have verified that all tables have the pr= oper constraints

3D"*"     A user should get a system message when a constraint is violated

3D"*"      You will implement customer messages in a later project

 

 

 

------=_NextPart_01C67739.16084600 Content-Location: file:///C:/EB26A0D4/EnforcingDataintegrityProject_files/image001.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhDwAPAJEAAJmZZsDAwAAAAAAAACH5BAEAAAEALAAAAAAPAA8AQAIjjI+ZAu0tlpiUrvei 2opheH2AxpXmaXofaagYG7hZuEpVVQAAOw== ------=_NextPart_01C67739.16084600 Content-Location: file:///C:/EB26A0D4/EnforcingDataintegrityProject_files/image002.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhDwAPAJEAAMyZAMDAwAAAAAAAACH5BAEAAAEALAAAAAAPAA8AQAIjjI+pAu0glph0ykqV 3uy1mHQeuJXmeYoPeagOa7jf4s2oUQAAOw== ------=_NextPart_01C67739.16084600 Content-Location: file:///C:/EB26A0D4/EnforcingDataintegrityProject_files/image003.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhDwAPAJEAAMzMmcDAwAAAAAAAACH5BAEAAAEALAAAAAAPAA8AQAIgjI+pIeAvlph0rovz ac9FxXWfRpZmCEmdp64jUlVmUAAAOw== ------=_NextPart_01C67739.16084600 Content-Location: file:///C:/EB26A0D4/EnforcingDataintegrityProject_files/image004.jpg Content-Transfer-Encoding: base64 Content-Type: image/jpeg /9j/4AAQSkZJRgABAgEASABIAAD/7Qj2UGhvdG9zaG9wIDMuMAA4QklNA+0AAAAAABAASAAAAAEA AQBIAAAAAQABOEJJTQPzAAAAAAAIAAAAAAAAAAA4QklNBAoAAAAAAAEAADhCSU0nEAAAAAAACgAB AAAAAAAAAAI4QklNA/QAAAAAABIANQAAAAEALQAAAAYAAAAAAAE4QklNA/cAAAAAABwAAP////// //////////////////////8D6AAAOEJJTQQIAAAAAAAQAAAAAQAAAkAAAAJAAAAAADhCSU0ECQAA AAAIEAAAAAEAAACAAAAAgAAAAYAAAMAAAAAH9AAYAAH/2P/gABBKRklGAAECAQBIAEgAAP/+ACdG aWxlIHdyaXR0ZW4gYnkgQWRvYmUgUGhvdG9zaG9wqCA0LjAA/+4ADkFkb2JlAGSAAAAAAf/bAIQA DAgICAkIDAkJDBELCgsRFQ8MDA8VGBMTFRMTGBEMDAwMDAwRDAwMDAwMDAwMDAwMDAwMDAwMDAwM DAwMDAwMDAENCwsNDg0QDg4QFA4ODhQUDg4ODhQRDAwMDAwREQwMDAwMDBEMDAwMDAwMDAwMDAwM DAwMDAwMDAwMDAwMDAwM/8AAEQgAgACAAwEiAAIRAQMRAf/dAAQACP/EAT8AAAEFAQEBAQEBAAAA AAAAAAMAAQIEBQYHCAkKCwEAAQUBAQEBAQEAAAAAAAAAAQACAwQFBgcICQoLEAABBAEDAgQCBQcG CAUDDDMBAAIRAwQhEjEFQVFhEyJxgTIGFJGhsUIjJBVSwWIzNHKC0UMHJZJT8OHxY3M1FqKygyZE k1RkRcKjdDYX0lXiZfKzhMPTdePzRieUpIW0lcTU5PSltcXV5fVWZnaGlqa2xtbm9jdHV2d3h5en t8fX5/cRAAICAQIEBAMEBQYHBwYFNQEAAhEDITESBEFRYXEiEwUygZEUobFCI8FS0fAzJGLhcoKS Q1MVY3M08SUGFqKygwcmNcLSRJNUoxdkRVU2dGXi8rOEw9N14/NGlKSFtJXE1OT0pbXF1eX1VmZ2 hpamtsbW5vYnN0dXZ3eHl6e3x//aAAwDAQACEQMRAD8A9SI3NkQ4OGnbTt4pmv3RBBJE9xon28jU Anx1+Schp1P+sapKUJITa9++k9vyp+Rqk6Y5gdz5JKWBBDfA8RxwpJh/Hul7eDE8x+RJSxB3DU99 PFS40A+5MeCAYJ4SkHVJSiNCJPy5SnSTokDI0BEaDsmJA0MgeKSl+0hMRujSEvaSDHHB55Ujrokp YacCJSkzEfNKZS41Emf9e6SlHUHXnTRRDdk7NB+7/wCRGicSZnQ/67U/GvfuUlP/0PVCY5TEiYBA PaUgCBGmnHwTGNpaddNSkpl+J7qLy7QABwJgjjQpmxppG2IPbXwUzMeaSlgZEjVMQAJiSNAf4Sn4 IAiPjqohoa7xPj31KSl5AjcQCeBKeZ+jBB/O51SLhIHikSRxBPf4JKU6QOJjgJQIAOvxT8papKWJ a3Q8eKU+6Z04I80+sf3JiD2/1CSldtE6aCDpwBokTpPPfRJStusp/LlRBDmyQWg6QdPJSkeKSn// 0fVE3lGkeUfBMGxoYgH2hP4O4/eBSUuJ8NFFoLdOR4nlLcNI1Hlr+RO0k8iPAJKWkCIGrjpHdLaS 7du0iI85Tx+PKXySUv2hMdZA+BS1g7YmNJ8fNMTzBHgJ8UlLxxrx/coyCwj80AgkacacKQ7EcRok Z7DWNCUlLBzYa0HnjzhPtbMwJ5TjgTz3hMNo0HZJS0Acxq4mAInT85SHCXdMf96SlRzA1KeUxMNk f6hISRDonukp/9L1SZ+SiddO3dNvEkeH53bv/cpGBqfvSUsA0FsQBrA/uTjQ7Y8Y1nwSkxPPwSjT UzrOv+xJSm66n5JiTOh54EJwQdQZS7JKUB+PPmmAa7X8CI18U5GsjkcJ9f70lLRxGhhLj8gUWggO 2bZ3E8/9UpaEa/ikpeAonX6JjuSO4Tie0Rx9yiBruaCJiZ/1KSmY11TTofxSYZExE6kJ0lLS2IPf t/sSA1MmfBLVOCCJaZHkkp//0/VFEAgaax37lOTA3a/AalKBykpdMdeE/blJJTGYIBidP4/3JzP3 9wmgOMHUDx8VKQB8OUlLDiJ1A7pidwcBMxpBjlP5jg+CYuadCdD9xlJTL/WUwPPiOUuwHHmEo+fm kpW4a+XP5Uo0g8nulrOspcCJ17JKUSGtk8DulJjxB8ExDu0THf8A2J+TpwRzOiSlNb4ye+qYh5B2 mJ5/8xSHMdh3nupf6ykp/9T1OPbofmISbMa6eCUwJ+eifVJS0xz96Xf+CeE06E8wJgcpKUQD/GNE oGvnynTAdgeNISUoE8aADQj8iYhuggHuBpp/KCcgnv469wk127y8jykpiZgz7RxM9v3lLtqIE6/L ukII0P3ap0lLc8HlIxMnt3TF4DmtIJLpgjgQn1me3YJKU6QJaJPgmDSNOR9yTnOaOCfhynnQEcaJ KUAB7RpPB5MpCQNTJ7xoP+/JEGRxHcJNH5x5Oh7cJKf/1fUwIjUmEo5E6nXXVOfJNLeO/KSlCY11 P3JogbfpDvPMFSlLzSUxc1rvpNkecFSmQSNY/gobWthsGD3HH3qUQZnTuOySlAjwiUhAEARHZPpy m3HmJBOnYgecpKW2ng6xx5/FKBOh84+cpwSTxA800AGRM8ckpKXJIIJ4/vTA74LdWnT/AFEJQDyA SnkHUHTsQkpQ1mQl30PfWUgCDHaNPingHXukpYAj7z+KZpDmy3UHhOAJ4hOQeySn/9b1MJjwXAe7 sDpP8lMYBh3AMg8eKl2n8iSlgSAC6BMaeBUvJNrprp3nlL3R5pKUCDwZjQpEH/f4eCUy6EwaN24/ SiJCSlRrodOI/uTmdY0PYp0wJA1MmdYSUqBwUgfv48O6X5Bwluh23ynySUqO/dKABAEAeCQaNTHJ k/FP35+SSlhyYn4mefmn7aalRBLhoY0HI7/KE/5sjQn8pSUoEeOvgm3aHtA1J7Jg0gz4wTHc8fwS redoJDu59w108YSU/wD/2ThCSU0EBgAAAAAABwABAQEAAQEA//4AJ0ZpbGUgd3JpdHRlbiBieSBB ZG9iZSBQaG90b3Nob3CoIDQuMAD/7gAhQWRvYmUAZIAAAAAAAwAQAwABAgAAAAAAAAAAAAAAAP/b AEMADAgICAkIDAkJDBELCgsRFQ8MDA8VGBMTFRMTGBEMDAwMDAwRDAwMDAwMDAwMDAwMDAwMDAwM DAwMDAwMDAwMDP/CAAsIAGQAZAEBEQD/xABnAAEBAQEAAAAAAAAAAAAAAAABAAIHEAEBAQACAgID AQAAAAAAAAABEQAhAjESQSIQMkIDEQABBAEBBQUGBQUAAAAAAAABABEhMUFRYXGBkRLwocECMhCx 0SJCYlKCsuLycqLC0rP/2gAIAQEBAAAA6jM1QhqqKmNAlMTJE0I1ExNRoJKSZzaxqGopcsTE1VDR NEwlMlnVFJoFyjURsNFOYf/aAAgBAQABBQB53VVaplxxuYPAtACtQ7E7es1K+DgroOGv23PUH2Hn AaN5inXJetx5DU7Fd6x5NeBumvV3nI3gY6GDHhjkmOCb65E1j1e1hfh41N8XfsIbsprrp6748aFu ewPhVeomd53O9QTz4w68vaYcRFOxC+2j63/SqhJvGQWjqmvUPGLouu68/gB6yDXOXjIyZQ1IHUzF +0lOasS7gJzzecQP2wQF9by4Tedydgn4FcHqzreamOtI6sjecaF6kwTFxA/re5vtW35PWf11kZ7G 59nw+fr6dpPtf//aAAgBAQEGPwAEGSah9PN/r5k23cw/l5VE/HkhEOdE2vgnO2TtK250U38VFC1h xZ0TRt8FMgF+Sv5WuXrT1f39a1TOH0UllXAbls1TtYYuMYRkHAA2epOKODC+YuALz3IEekj3qyO2 1MZankrYny844qfNFzjiiPNkSqJJkOC37V8xkY8UXPUC7iG9y2HBTtwUEzJCeZjsy0TgghMgQXeQ 2idprg+9BqyMW7oFpMIuXBNNhvZcv2wgJhpl3BZMSw5T6lBIDHUmfYC06nDpmG7YoM4dMAZl8BTG zxW+VXURbbP3IToHLdvmQfWH7fd0oHSalFgsQZzSfKBdtdOfst172BQAwLFRhgVmcp+OIWjWBLj9 SL+kBzxT80/lvko5cbRm6TY0+KtOILuSnmlCY2cE7/gm8MIaGinLu5GcOmZpnCGQZ4J4miAokYIn 3KTOxekNvmtf6k547PulR7G81CiWtMtUWjOhD35pQyaBMEqdU+IIU4Bex3J8Yul1PDVDIYaQ1IDN PlbXwnakWvx70QA5Eh3adqN9uC137U5wj1U1nRPWpOUxNMbkJ2lqYXzTeYbxaDi7bBT4GloAeYQA +f8AL6lbb+aDFtg3o62ppEl9SDOEAcy04QEmpdA1AKbLOy2FFluTT8xJfATEx9KAE6qt7qyYh6jc EDZoE6pxOOCfKl2wPNLN7IEnkoPSCMNapNostTYt3lMOwWoJl9qY3zjCcQGcuG5rD97H+KPvKLQR rDz05VFm2NdX1dS+Vmm6f8v3rYg1NDaKfSx3NH5UGrbfehT7b/Khq3FR6Y8VCH4Yamf6Vjo4M36e npRbque6ur7fwf8ARfV3ar//2b== ------=_NextPart_01C67739.16084600 Content-Location: file:///C:/EB26A0D4/EnforcingDataintegrityProject_files/image005.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhWAIKAHcAACH/C01TT0ZGSUNFOS4wDQAAAAFzUkdCAK7OHOkAIf8LTVNPRkZJQ0U5LjAY AAAADG1zT1BNU09GRklDRTkuMBACIMXeACH/C01TT0ZGSUNFOS4wGAAAAAxjbVBQSkNtcDA3MTIC AAAIddtivwAh+QQBAAAAACwAAAAAWAIKAITAwMDM///MzMyZzMyZmZlmmZlmZmYzZmYzMzMAZmYA MzMAAAAAAAAAAAAAAAAAAAABAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMBAgMB AgMBAgMBAgME/xDISau9OOvNu/9gKI5kaZ5oqq5s675wLM90bd94ru987/9AlOKgKBqPSOOBMDAk n9DooUCoEgrRrHbLLQiIhwFRayBwz9wEVXBdX8dPphOdNLDh9Dwd4S0UBmZafwR4Z0tNeltTVleJ jnReYGJbZY+JagRsfplvUXKWdoSWo098An6AW3+FXIdzpEeLVliwtUaRQ5NkgbZamJpuBaxGn4+h w715pqi8UYPIWa7JQ1Sz07C4YdBGlddQv22cwp6IxnfejsuDqqlQB+/w71TlUvHv6PjRV1VcjflP UwoY2JarWZ4p5/4lQjDl1RM32+zBm+cQoESFGIssqdaPVkaNfv8GagljkA5CUR/RMBSYBSKUQYxm VTwyjw0gJkwSwpIYD+MBAQFmJvlJMGUdAUK7MBl3jWdRPc8E3Yx5JamCmjhxDtBJyuk9hT+DKvpi lI4dq4KWPk3kdFrUJwa2okRDkilcQAgsLREwlSpfu94OoNXYrmw/XXne7vSzSe7NxwLYiLTkZe5d rq0AAUYSl0DeR3v7xvy7FvTggobPMClNExDrkYyxPq6yVfLrJJWhxcWsSLNuvHoziWZEOp/g3iVT x0EMybWtgI1t0qYdmcDkR7mz7LacuROUzp8dhaZqpTi+4yMLKyd3+6rzWtBlT89pe1T2JEHy69/P v7///wAGKOAOgAQWaOCBCCao4IIuRAAAOw== ------=_NextPart_01C67739.16084600 Content-Location: file:///C:/EB26A0D4/EnforcingDataintegrityProject_files/filelist.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C67739.16084600--