MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_NextPart_01C5554F.4449ED00" This document is a Single File Web Page, also known as a Web Archive file. If you are seeing this message, your browser or editor doesn't support Web Archive files. Please download a browser that supports Web Archive, such as Microsoft Internet Explorer. ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)

This presentation contains content that your browser may not be able to = show properly. This presentation was optimized for more recent versions of Micro= soft Internet Explorer.

If you would like to proceed anyway, click here.

 ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/master04.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"
Click to edit Master title style
Click to edit Master text styles
Second level
Third level
Fourth level
Fifth level
‹date/time›
&= #8249;footer› <= /span>
‹#›
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/master04.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/preview.wmf Content-Transfer-Encoding: base64 Content-Type: image/x-wmf AQAJAAADBRoAAAYAUQIAAAAABAAAAAMBCAAFAAAACwIAAAAABQAAAAwCeQChAAMAAAAeAAcAAAD8 AgAA////AAAABAAAAC0BAAAIAAAA+gIFAAAAAAD///8ABAAAAC0BAQAOAAAAJAMFAP///////3gA oAB4AKAA////////CAAAAPoCAAAAAAAAAAAAAAQAAAAtAQIABwAAAPwCAAD///8AAAAEAAAALQED AAQAAAAnAf//BAAAAPABAAADAAAAHgAHAAAA/AIAADMzzAAAAAQAAAAtAQAABAAAAC0BAQAOAAAA JAMFAAUALAAFADQADAA0AAwALAAFACwABAAAAC0BAgAEAAAALQEDAAQAAAAnAf//AwAAAB4ABAAA AC0BAQAHAAAA/AIAADo6zQAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAAsALAALADUADAA1AAwA LAALACwABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAABmZtIAAAAEAAAALQEEAAQAAAAt AQEADgAAACQDBQAMACwADAA1AA0ANQANACwADAAsAAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcA AAD8AgAAm5veAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUADQAsAA0ANQAOADUADgAsAA0ALAAE AAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAMvL7AAAAAQAAAAtAQQABAAAAC0BAQAOAAAA JAMFAA4ALAAOADUADwA1AA8ALAAOACwABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAADs 7PcAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAPACwADwA1ABAANQAQACwADwAsAAQAAAAtAQEA BAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA/Pz+AAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAEAAs ABAANQARADUAEQAsABAALAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAEAAAALQECAAQAAAAnAf// BAAAAPABAAADAAAAHgAHAAAA/AIAAP/PAQAAAAQAAAAtAQAABAAAAC0BAQAOAAAAJAMFAAcANAAH ADwADgA8AA4ANAAHADQABAAAAC0BAgAEAAAALQEDAAQAAAAnAf//AwAAAB4ABAAAAC0BAQAHAAAA /AIAAP/QHQAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAA0AMwANADwADgA8AA4AMwANADMABAAA AC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAAD/1VgAAAAEAAAALQEEAAQAAAAtAQEADgAAACQD BQAOADMADgA8AA8APAAPADMADgAzAAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA/92M AAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUADwAzAA8APAAQADwAEAAzAA8AMwAEAAAALQEBAAQA AAAtAQMABAAAAPABBAAHAAAA/AIAAP/qvAAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFABAAMwAQ ADwAEQA8ABEAMwAQADMABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAAD/9OAAAAAEAAAA LQEEAAQAAAAtAQEADgAAACQDBQARADMAEQA8ABIAPAASADMAEQAzAAQAAAAtAQEABAAAAC0BAwAE AAAA8AEEAAcAAAD8AgAA//v2AAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAEgAzABIAPAATADwA EwAzABIAMwAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAP///gAAAAQAAAAtAQQABAAA AC0BAQAOAAAAJAMFABMAMwATADwAFAA8ABQAMwATADMABAAAAC0BAQAEAAAALQEDAAQAAADwAQQA BAAAAC0BAgAEAAAAJwH//wMAAAAeAAQAAAAHAQQAUQIAAEELIADMAAgACgAAAAAACAAKADIAAAAo AAAACgAAAAgAAAABAAgAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAP///wCvr/8AoKD/AI+P /wB+fv8AbGz/AFtb/wBKSv8AOTn/ACUl/wADA/8AwsL/ALS0/wClpf8AlJT/AISE/wBycv8AYWH/ AE9P/wA+Pv8ALS3/ANPT/wDHx/8Aubn/AKqq/wCamv8AiYn/AHh4/wBmZv8AVVX/AERE/wDh4f8A 19f/AMvL/wC+vv8An5//AI6O/wDs7P8A5OT/ANra/wDPz/8Ag4P/APT0/wDu7v8A5+f/AN7e/wCZ mf8A+vr/APX1/wDw8P8A6en/AL29/wD9/f8A+/v/APf3/wDy8v8AAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAADU2NzgmJygpDA2EOTAxMjMgISI0 AiSDOSssLS4WFxgZLxuEOSYnKCkMDQ4PKhGEOSAhIiMCJCUFBgeaOxYXGBkaGxwdHh8AAAwNDg8Q ERITFBUAAAIDBAUGBwgJCgsAAAQAAAAnAf//BAAAAPABAAADAAAAHgAHAAAA/AIAABwcHAAAAAQA AAAtAQAABAAAAC0BAQAOAAAAJAMFAAsAKgALAD0ACwA9AAsAKgALACoABAAAAC0BAgAEAAAALQED AAQAAAAnAf//AwAAAB4ABAAAAC0BAQAHAAAA/AIAAB0dHQAAAAQAAAAtAQQABAAAAC0BAQAOAAAA JAMFAAUAOAAFADkABgA5AAYAOAAFADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAAAg ICAAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAGADgABgA5AAcAOQAHADgABgA4AAQAAAAtAQEA BAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAIiIiAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUABwA4 AAcAOQAIADkACAA4AAcAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAACQkJAAAAAQA AAAtAQQABAAAAC0BAQAOAAAAJAMFAAgAOAAIADkACQA5AAkAOAAIADgABAAAAC0BAQAEAAAALQED AAQAAADwAQQABwAAAPwCAAAmJiYAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAJADgACQA5AAoA OQAKADgACQA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAKSkpAAAABAAAAC0BBAAE AAAALQEBAA4AAAAkAwUACgA4AAoAOQALADkACwA4AAoAOAAEAAAALQEBAAQAAAAtAQMABAAAAPAB BAAHAAAA/AIAACsrKwAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAAsAOAALADkADAA5AAwAOAAL ADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAAAtLS0AAAAEAAAALQEEAAQAAAAtAQEA DgAAACQDBQAMADgADAA5AA4AOQAOADgADAA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8 AgAAMDAwAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUADgA4AA4AOQAPADkADwA4AA4AOAAEAAAA LQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAADIyMgAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMF AA8AOAAPADkAEAA5ABAAOAAPADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAAA0NDQA AAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAQADgAEAA5ABEAOQARADgAEAA4AAQAAAAtAQEABAAA AC0BAwAEAAAA8AEEAAcAAAD8AgAANjY2AAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAEQA4ABEA OQASADkAEgA4ABEAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAADg4OAAAAAQAAAAt AQQABAAAAC0BAQAOAAAAJAMFABIAOAASADkAEwA5ABMAOAASADgABAAAAC0BAQAEAAAALQEDAAQA AADwAQQABwAAAPwCAAA6OjoAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQATADgAEwA5ABQAOQAU ADgAEwA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAPT09AAAABAAAAC0BBAAEAAAA LQEBAA4AAAAkAwUAFAA4ABQAOQAVADkAFQA4ABQAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAH AAAA/AIAAD8/PwAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFABUAOAAVADkAFgA5ABYAOAAVADgA BAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAABBQUEAAAAEAAAALQEEAAQAAAAtAQEADgAA ACQDBQAWADgAFgA5ABcAOQAXADgAFgA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA Q0NDAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAFwA4ABcAOQAYADkAGAA4ABcAOAAEAAAALQEB AAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAEVFRQAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFABgA OAAYADkAGgA5ABoAOAAYADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAABISEgAAAAE AAAALQEEAAQAAAAtAQEADgAAACQDBQAaADgAGgA5ABsAOQAbADgAGgA4AAQAAAAtAQEABAAAAC0B AwAEAAAA8AEEAAcAAAD8AgAASkpKAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAGwA4ABsAOQAc ADkAHAA4ABsAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAExMTAAAAAQAAAAtAQQA BAAAAC0BAQAOAAAAJAMFABwAOAAcADkAHQA5AB0AOAAcADgABAAAAC0BAQAEAAAALQEDAAQAAADw AQQABwAAAPwCAABOTk4AAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAdADgAHQA5AB4AOQAeADgA HQA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAUVFRAAAABAAAAC0BBAAEAAAALQEB AA4AAAAkAwUAHgA4AB4AOQAfADkAHwA4AB4AOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA /AIAAFNTUwAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAB8AOAAfADkAIAA5ACAAOAAfADgABAAA AC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAABVVVUAAAAEAAAALQEEAAQAAAAtAQEADgAAACQD BQAgADgAIAA5ACEAOQAhADgAIAA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAV1dX AAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAIQA4ACEAOQAiADkAIgA4ACEAOAAEAAAALQEBAAQA AAAtAQMABAAAAPABBAAHAAAA/AIAAFlZWQAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFACIAOAAi ADkAIwA5ACMAOAAiADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAABbW1sAAAAEAAAA LQEEAAQAAAAtAQEADgAAACQDBQAjADgAIwA5ACQAOQAkADgAIwA4AAQAAAAtAQEABAAAAC0BAwAE AAAA8AEEAAcAAAD8AgAAXV1dAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAJAA4ACQAOQAlADkA JQA4ACQAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAF9fXwAAAAQAAAAtAQQABAAA AC0BAQAOAAAAJAMFACUAOAAlADkAJgA5ACYAOAAlADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQA BwAAAPwCAABhYWEAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAmADgAJgA5ACcAOQAnADgAJgA4 AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAZGRkAAAABAAAAC0BBAAEAAAALQEBAA4A AAAkAwUAJwA4ACcAOQAoADkAKAA4ACcAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIA AGZmZgAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFACgAOAAoADkAKQA5ACkAOAAoADgABAAAAC0B AQAEAAAALQEDAAQAAADwAQQABwAAAPwCAABoaGgAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAp ADgAKQA5ACoAOQAqADgAKQA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAampqAAAA BAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAKgA4ACoAOQArADkAKwA4ACoAOAAEAAAALQEBAAQAAAAt AQMABAAAAPABBAAHAAAA/AIAAGxsbAAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFACsAOAArADkA LAA5ACwAOAArADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAABubm4AAAAEAAAALQEE AAQAAAAtAQEADgAAACQDBQAsADgALAA5AC0AOQAtADgALAA4AAQAAAAtAQEABAAAAC0BAwAEAAAA 8AEEAAcAAAD8AgAAcHBwAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUALQA4AC0AOQAuADkALgA4 AC0AOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAHNzcwAAAAQAAAAtAQQABAAAAC0B AQAOAAAAJAMFAC4AOAAuADkALwA5AC8AOAAuADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAA APwCAAB1dXUAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAvADgALwA5ADAAOQAwADgALwA4AAQA AAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAd3d3AAAABAAAAC0BBAAEAAAALQEBAA4AAAAk AwUAMAA4ADAAOQAxADkAMQA4ADAAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAHp6 egAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFADEAOAAxADkAMgA5ADIAOAAxADgABAAAAC0BAQAE AAAALQEDAAQAAADwAQQABwAAAPwCAAB8fHwAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQAyADgA MgA5ADMAOQAzADgAMgA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAfn5+AAAABAAA AC0BBAAEAAAALQEBAA4AAAAkAwUAMwA4ADMAOQA0ADkANAA4ADMAOAAEAAAALQEBAAQAAAAtAQMA BAAAAPABBAAHAAAA/AIAAICAgAAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFADQAOAA0ADkANQA5 ADUAOAA0ADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAACCgoIAAAAEAAAALQEEAAQA AAAtAQEADgAAACQDBQA1ADgANQA5ADYAOQA2ADgANQA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEE AAcAAAD8AgAAhISEAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUANgA4ADYAOQA3ADkANwA4ADYA OAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAIaGhgAAAAQAAAAtAQQABAAAAC0BAQAO AAAAJAMFADcAOAA3ADkAOAA5ADgAOAA3ADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwC AACIiIgAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQA4ADgAOAA5ADkAOQA5ADgAOAA4AAQAAAAt AQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAioqKAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUA OQA4ADkAOQA6ADkAOgA4ADkAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAI2NjQAA AAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFADoAOAA6ADkAOwA5ADsAOAA6ADgABAAAAC0BAQAEAAAA LQEDAAQAAADwAQQABwAAAPwCAACQkJAAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQA7ADgAOwA5 ADwAOQA8ADgAOwA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAkpKSAAAABAAAAC0B BAAEAAAALQEBAA4AAAAkAwUAPAA4ADwAOQA9ADkAPQA4ADwAOAAEAAAALQEBAAQAAAAtAQMABAAA APABBAAHAAAA/AIAAJSUlAAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAD0AOAA9ADkAPgA5AD4A OAA9ADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAACWlpYAAAAEAAAALQEEAAQAAAAt AQEADgAAACQDBQA+ADgAPgA5AD8AOQA/ADgAPgA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcA AAD8AgAAmJiYAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAPwA4AD8AOQBAADkAQAA4AD8AOAAE AAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAJqamgAAAAQAAAAtAQQABAAAAC0BAQAOAAAA JAMFAEAAOABAADkAQQA5AEEAOABAADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAACc nJwAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQBBADgAQQA5AEIAOQBCADgAQQA4AAQAAAAtAQEA BAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAnp6eAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAQgA4 AEIAOQBDADkAQwA4AEIAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAKCgoAAAAAQA AAAtAQQABAAAAC0BAQAOAAAAJAMFAEMAOABDADkARAA5AEQAOABDADgABAAAAC0BAQAEAAAALQED AAQAAADwAQQABwAAAPwCAACjo6MAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQBEADgARAA5AEUA OQBFADgARAA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAApaWlAAAABAAAAC0BBAAE AAAALQEBAA4AAAAkAwUARQA4AEUAOQBHADkARwA4AEUAOAAEAAAALQEBAAQAAAAtAQMABAAAAPAB BAAHAAAA/AIAAKioqAAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAEcAOABHADkASAA5AEgAOABH ADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAACqqqoAAAAEAAAALQEEAAQAAAAtAQEA DgAAACQDBQBIADgASAA5AEkAOQBJADgASAA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8 AgAArKysAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUASQA4AEkAOQBKADkASgA4AEkAOAAEAAAA LQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAK6urgAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMF AEoAOABKADkASwA5AEsAOABKADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAACwsLAA AAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQBLADgASwA5AEwAOQBMADgASwA4AAQAAAAtAQEABAAA AC0BAwAEAAAA8AEEAAcAAAD8AgAAsrKyAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUATAA4AEwA OQBNADkATQA4AEwAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAALS0tAAAAAQAAAAt AQQABAAAAC0BAQAOAAAAJAMFAE0AOABNADkATgA5AE4AOABNADgABAAAAC0BAQAEAAAALQEDAAQA AADwAQQABwAAAPwCAAC2trYAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQBOADgATgA5AE8AOQBP ADgATgA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAuLi4AAAABAAAAC0BBAAEAAAA LQEBAA4AAAAkAwUATwA4AE8AOQBQADkAUAA4AE8AOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAH AAAA/AIAALq6ugAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAFAAOABQADkAUQA5AFEAOABQADgA BAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAAC8vLwAAAAEAAAALQEEAAQAAAAtAQEADgAA ACQDBQBRADgAUQA5AFMAOQBTADgAUQA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA v7+/AAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAUwA4AFMAOQBUADkAVAA4AFMAOAAEAAAALQEB AAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAMHBwQAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAFQA OABUADkAVgA5AFYAOABUADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAADExMQAAAAE AAAALQEEAAQAAAAtAQEADgAAACQDBQBWADgAVgA5AFcAOQBXADgAVgA4AAQAAAAtAQEABAAAAC0B AwAEAAAA8AEEAAcAAAD8AgAAxsbGAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAVwA4AFcAOQBZ ADkAWQA4AFcAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAMnJyQAAAAQAAAAtAQQA BAAAAC0BAQAOAAAAJAMFAFkAOABZADkAWgA5AFoAOABZADgABAAAAC0BAQAEAAAALQEDAAQAAADw AQQABwAAAPwCAADLy8sAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQBaADgAWgA5AFsAOQBbADgA WgA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAAzc3NAAAABAAAAC0BBAAEAAAALQEB AA4AAAAkAwUAWwA4AFsAOQBdADkAXQA4AFsAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA /AIAANDQ0AAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAF0AOABdADkAXgA5AF4AOABdADgABAAA AC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAADS0tIAAAAEAAAALQEEAAQAAAAtAQEADgAAACQD BQBeADgAXgA5AGAAOQBgADgAXgA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA1NTU AAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAYAA4AGAAOQBhADkAYQA4AGAAOAAEAAAALQEBAAQA AAAtAQMABAAAAPABBAAHAAAA/AIAANbW1gAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAGEAOABh ADkAYwA5AGMAOABhADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAADY2NgAAAAEAAAA LQEEAAQAAAAtAQEADgAAACQDBQBjADgAYwA5AGQAOQBkADgAYwA4AAQAAAAtAQEABAAAAC0BAwAE AAAA8AEEAAcAAAD8AgAA2traAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAZAA4AGQAOQBmADkA ZgA4AGQAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAANzc3AAAAAQAAAAtAQQABAAA AC0BAQAOAAAAJAMFAGYAOABmADkAaAA5AGgAOABmADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQA BwAAAPwCAADf398AAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQBoADgAaAA5AGoAOQBqADgAaAA4 AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA4eHhAAAABAAAAC0BBAAEAAAALQEBAA4A AAAkAwUAagA4AGoAOQBsADkAbAA4AGoAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIA AOTk5AAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAGwAOABsADkAbgA5AG4AOABsADgABAAAAC0B AQAEAAAALQEDAAQAAADwAQQABwAAAPwCAADm5uYAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQBu ADgAbgA5AHAAOQBwADgAbgA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA6OjoAAAA BAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAcAA4AHAAOQByADkAcgA4AHAAOAAEAAAALQEBAAQAAAAt AQMABAAAAPABBAAHAAAA/AIAAOrq6gAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAHIAOAByADkA dAA5AHQAOAByADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAADs7OwAAAAEAAAALQEE AAQAAAAtAQEADgAAACQDBQB0ADgAdAA5AHcAOQB3ADgAdAA4AAQAAAAtAQEABAAAAC0BAwAEAAAA 8AEEAAcAAAD8AgAA7u7uAAAABAAAAC0BBAAEAAAALQEBAA4AAAAkAwUAdwA4AHcAOQB5ADkAeQA4 AHcAOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAPDw8AAAAAQAAAAtAQQABAAAAC0B AQAOAAAAJAMFAHkAOAB5ADkAewA5AHsAOAB5ADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAA APwCAADy8vIAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQB7ADgAewA5AH8AOQB/ADgAewA4AAQA AAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA9PT0AAAABAAAAC0BBAAEAAAALQEBAA4AAAAk AwUAfwA4AH8AOQCCADkAggA4AH8AOAAEAAAALQEBAAQAAAAtAQMABAAAAPABBAAHAAAA/AIAAPb2 9gAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAIIAOACCADkAhgA5AIYAOACCADgABAAAAC0BAQAE AAAALQEDAAQAAADwAQQABwAAAPwCAAD4+PgAAAAEAAAALQEEAAQAAAAtAQEADgAAACQDBQCGADgA hgA5AIkAOQCJADgAhgA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEEAAcAAAD8AgAA+vr6AAAABAAA AC0BBAAEAAAALQEBAA4AAAAkAwUAiQA4AIkAOQCQADkAkAA4AIkAOAAEAAAALQEBAAQAAAAtAQMA BAAAAPABBAAHAAAA/AIAAPz8/AAAAAQAAAAtAQQABAAAAC0BAQAOAAAAJAMFAJAAOACQADkAlQA5 AJUAOACQADgABAAAAC0BAQAEAAAALQEDAAQAAADwAQQABwAAAPwCAAD///8AAAAEAAAALQEEAAQA AAAtAQEADgAAACQDBQCVADgAlQA5AJ4AOQCeADgAlQA4AAQAAAAtAQEABAAAAC0BAwAEAAAA8AEE AAQAAAAtAQIABAAAACcB//8cAAAA+wL+/wAAAAAAAJABAAAAAABAAABUYWhvbWEAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAAAAAQAAAAtAQQABAAAAC4BGAAEAAAAAgEBAAUAAAAJAhwcHAIwAAAAMgpz AFsAGwAAAEFyZWEgMiBDVUcsIDIwIEphbnVhcnkgMjAwNQABAAEAAQABAAEAAQABAAEAAQABAAAA AQABAAEAAAABAAEAAQABAAEAAQAAAAEAAQABAAEAAQAEAAAALgEAABwAAAD7AhAABwAAAAAAvAIA AAAAAQICIlN5c3RlbQAAAAAAAAAAAAAYAAAAAgAAADiRGADkBAAABAAAAC0BBQAEAAAA8AEEABwA AAD7Av7/AAAAAAAAkAEAAAAAAEAAAFRhaG9tYQAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABAAA AC0BBAAEAAAALgEYAAQAAAACAQEABQAAAAkCHBwcAmcAAAAyCnMABgBAAAAAQ29weXJpZ2h0IDIw MDUgSm9obiBSLiBNZXJyaWxsIGFuZCBDeW5kaSBFLiBNZXJyaWxsLCBBbGwgUmlnaHRzIAEAAQAB AAEAAQAAAAEAAQABAAEAAQABAAEAAAABAAEAAQABAAEAAQAAAAEAAAACAAEAAQAAAAAAAAAAAAEA AQABAAEAAQABAAEAAQABAAAAAQABAAEAAAACAAEAAAABAAAAAAAAAAEAAQABAAAAAAABAAEAAAAB AAEAAQABAAEABAAAAC4BAAAEAAAALQEFAAQAAADwAQQAHAAAAPsC/v8AAAAAAACQAQAAAAAAQAAA VGFob21hAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAALQEEAAQAAAAuARgABAAAAAIBAQAF AAAACQIcHBwCEwAAADIKcwA3AAgAAABSZXNlcnZlZAEAAQABAAEAAQABAAEAAQAEAAAALgEAAAQA AAAtAQUABAAAAPABBAAcAAAA+wL+/wAAAAAAALwCAAAAAABAAABUYWhvbWEAAAAAAAAAAAAAAAAA AAAAAAAAAAAAAAAAAAQAAAAtAQQABAAAAC4BGAAEAAAAAgEBAAUAAAAJAhwcHAIJAAAAMgpzAJgA AQAAADGvAQAEAAAALgEAAAQAAAAtAQUABAAAAPABBAAcAAAA+wL3/wAAAAAAAJABAAAAAABAAABU YWhvbWEAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAQAAAAtAQQABAAAAC4BGAAEAAAAAgEBAAUA AAAJAjMzmQIuAAAAMgofACUAGgAAAEEgUXVpY2sgSW50cm9kdWN0aW9uIHRvIGEgBgACAAcABQAC AAQABQACAAQABQADAAMABQAFAAUABAADAAIABQAEAAMAAwAFAAMABAACAAQAAAAuAQAABAAAAC0B BQAEAAAA8AEEABwAAAD7Avf/AAAAAAAAkAEAAAAAAEAAAFRhaG9tYQAAAAAAAAAAAAAAAAAAAAAA AAAAAAAAAAAABAAAAC0BBAAEAAAALgEYAAQAAAACAQEABQAAAAkCMzOZAiUAAAAyCikAJgAUAAAA UkVMQVRJT05BTCBEQVRBQkFTRSAGAAYAAwAGAAUAAwAHAAUABwAEAAIABgAGAAQABgAFAAYABQAF AAIABAAAAC4BAAAEAAAALQEFAAQAAADwAQQAHAAAAPsC9/8AAAAAAACQAQAAAAAAQAAAVGFob21h AAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAALQEEAAQAAAAuARgABAAAAAIBAQAFAAAACQIz M5kCLQAAADIKNAAVABkAAABNQU5BR0VNRU5UIFNZU1RFTSAoUkRCTVMpIAcABgAFAAYABgAFAAcA BQAGAAUAAgAFAAUABQAFAAUACAADAAMABQAGAAUABwAGAAMABAAAAC4BAAAEAAAALQEFAAQAAADw AQQAHAAAAPsC+f8AAAAAAACQAQAAAAAAQAAAVGFob21hAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAEAAAALQEEAAQAAAAuARgABAAAAAIBAQAFAAAACQIAAAACHgAAADIKUAA4AA8AAABKb2huIFIu IE1lcnJpbGwAAwAEAAQABAACAAQAAgACAAUAAwADAAIAAgABAAIABAAAAC4BAAAEAAAALQEFAAQA AADwAQQAHAAAAPsC+f8AAAAAAACQAQAAAAAAQAAAVGFob21hAAAAAAAAAAAAAAAAAAAAAAAAAAAA AAAAAAAEAAAALQEEAAQAAAAuARgABAAAAAIBAQAFAAAACQIAAAACDAAAADIKWABIAAMAAABhbmQA BAAEAAQABAAAAC4BAAAEAAAALQEFAAQAAADwAQQAHAAAAPsC+f8AAAAAAACQAQAAAAAAQAAAVGFo b21hAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAEAAAALQEEAAQAAAAuARgABAAAAAIBAQAFAAAA CQIAAAACHwAAADIKXwA3ABAAAABDeW5kaSBFLiBNZXJyaWxsBAADAAQABAACAAIABAACAAIABQAD AAMAAgACAAEAAgAEAAAALgEAAAQAAAAtAQUABAAAAPABBAADAAAAAAA= ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/master05.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"
Click to edit Master title style<= /div>
Click to edit Master subtitle sty= le
‹date/time›
‹footer›
‹#›
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/master05.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/master02.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii"
‹header›
‹date/time›=
‹footer›
‹#›
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/pres.xml Content-Transfer-Encoding: quoted-printable Content-Type: text/xml; charset="utf-8" ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/slide0001.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)
Area 2 CUG, 20 January 2005
Copyright 2005 John R. Merrill and Cyndi E. Merrill, All Rights Reserved&#= 13;
1
A Quick Introduction to = a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDBMS)
John R. Merrill
and
Cyndi E. Merrill
Handouts:  slices (2up, front&back, BW); rdbms_otherdefs.doc; contact list.xls)
Need: own PC; projector; screen; # of handouts to make
Models are in DB Designer 4


------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/master05_image001.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhEAI/AHcAMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAAALAAAAAAO Aj4AhwAAAAAAAAAAMwAAZgAAmQAAzAAA/wAzAAAzMwAzZgAzmQAzzAAz/wBmAABmMwBmZgBmmQBm zABm/wCZAACZMwCZZgCZmQCZzACZ/wDMAADMMwDMZgDMmQDMzADM/wD/AAD/MwD/ZgD/mQD/zAD/ /zMAADMAMzMAZjMAmTMAzDMA/zMzADMzMzMzZjMzmTMzzDMz/zNmADNmMzNmZjNmmTNmzDNm/zOZ ADOZMzOZZjOZmTOZzDOZ/zPMADPMMzPMZjPMmTPMzDPM/zP/ADP/MzP/ZjP/mTP/zDP//2YAAGYA M2YAZmYAmWYAzGYA/2YzAGYzM2YzZmYzmWYzzGYz/2ZmAGZmM2ZmZmZmmWZmzGZm/2aZAGaZM2aZ ZmaZmWaZzGaZ/2bMAGbMM2bMZmbMmWbMzGbM/2b/AGb/M2b/Zmb/mWb/zGb//5kAAJkAM5kAZpkA mZkAzJkA/5kzAJkzM5kzZpkzmZkzzJkz/5lmAJlmM5lmZplmmZlmzJlm/5mZAJmZM5mZZpmZmZmZ zJmZ/5nMAJnMM5nMZpnMmZnMzJnM/5n/AJn/M5n/Zpn/mZn/zJn//8wAAMwAM8wAZswAmcwAzMwA /8wzAMwzM8wzZswzmcwzzMwz/8xmAMxmM8xmZsxmmcxmzMxm/8yZAMyZM8yZZsyZmcyZzMyZ/8zM AMzMM8zMZszMmczMzMzM/8z/AMz/M8z/Zsz/mcz/zMz///8AAP8AM/8AZv8Amf8AzP8A//8zAP8z M/8zZv8zmf8zzP8z//9mAP9mM/9mZv9mmf9mzP9m//+ZAP+ZM/+ZZv+Zmf+ZzP+Z///MAP/MM//M Zv/Mmf/MzP/M////AP//M///Zv//mf//zP///wECAwECAwECAwECAwECAwECAwECAwECAwECAwEC AwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwEC AwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwj/AAEIHEiwoMGDCAGwYJGwocOHECNKnEix osWLGDNq3Mixo8ePIEOKHDkyAEOSKFOqXMmypcuXMGPKnDmRRQCaOHPq3Mmzp8+fQC2aDEq0qNGj SJMqzWlzqdOnUKNKnQp0KNWrWLNq3Zr0hdevYMOGtek1i9ksg9IOcsXWFba3b7nKnUu3rl2EYvPm NflVC9oshNYOwtYKm1u32O4qXsy48VG9kL8u/Ho2rau1h+HGdcy5s+fPKAnkFS2W9Au+WV6YJQRY sKvChd+2Ak27tu3bDSNHJqu68qDAbRHDxU28uPHGL2DkVS6WOeoXfge1vky4OuLj2LNrp6obMu/e aH9j/zasOfH28+jT/wRrmv1eFqp7swa+FjZcV+rz69/fsrte3meFZ1lb5fFn4IEIauTfe339RZ91 5JmX4IQUVljQgmJNVpZZlo0n3GYWhigif+19VaJXpj232nT1VSfbiDDGeB6GYwWwIYfiBVegjDz2 eFtyywV5GnypRcdidYVd5+OSTDpGI1jf+QZcZpo1aeWVdLlXGoOprUjfay4ahuWYZHL3pFcA+jYg WzuW6eabj505ZIPSPZhkhHDmqadPcr6gIXgdsvmhhHsWauhLJ76QaIpEyscimLERduiklKbUZ5o4 TslmlZV26ilC0SgT6qjKKDOMqagOo+owvLDqaqu88P9Si6y1ADlnkQ4KhiSen/baazTAhlrqsKWe auyqyMaqrLK1SmbjjWlNGeFwvlZbKanYEmtsqq92uyxYKgL2qH1v4WftuYYGGyyx7HKLrKqwfuvs jQJitim16OYL57rZCltsqtzC+iovzUzTTDMmHVywwtQ044wz1TxjzTPXQFMxNtFgcw3G+OrrMY/q qttuu++uKjDBCi+k8MoOO/PMy89AY7HFG2/c5sc4j4gxv6L27C/A2ybr6soJs9xyNRBLLPHM12Sc 8VsZ5yy1iCGH3PPIxZb86so2GX3wwzAvbU0015RtM6dTp50gx1X7fPW/QZtq8jDNNIwwCwwz7HLS E1f/3DTHNXes9uD6Bbtz26SOrDWrXAfgdcthy+x34DcTbjl6bLNtdbZAu0u3wkWz/DDSEU9sDdMb P60xoZe3np3TmlcN7NvsHrtq44+DDfPpp5t9tuCuB09c5rA7zTPncau68N0KG3xww6Mr7Tc0gHMM ovDY36Z68bKLrHiqXOPtte4vS07z6pVnr75nxLcvcr/aokq0+KJDzPfSfsMONevr999YecTr3rqw Zircjc9lu4PG2HwHQP850DHuc9/x3DasU9XtYKGzW932VjqKWQx2lOPfA0coFwDuD2oCnF2pfqYM AxqNfDFDHfrQRsIacsV6EeTe7OA3rPkdkHRK6935/1S3MRsacSsmhIsOBUjBFqbMcQcMG+9oVrYG HvGKVFGiFosXQOO5TVjLC53zLhi9vs2seqrDohqjkkTNbC8aJjHJQuRok4XU0Y54zKMe98jHPtrx Cn8M5EIASchAXuGQLDgkIRGpyEY68pGQjKQkIykIRVbykJe8QiYrKYhOatKTneRkKEdJylKa8pSo NGUrQrnKTrZSEK9cZStmCUtazlKWtszlLXfJy1768pfADOYuCTNLYsKmmLc0pjLtk8xIORMuz5QN NKcpzWqWJ1JtzKY2t8nNbnrzmybc3haJV8c4lvOc5qSjOu1IRz/msZDwTKQ840nPedqznvhMJCP3 uf/IfkKSk5oMKEAHKtCCEvSgBjUoKBcqyoaqkpWwjKgsJUrRiVq0ohi9qEYrqsta4vKjHvXlMpG5 K2aW9KQmTSlKV6rSlrL0pS4lV5iiOVNq1tSaNM2pTTWDzZ36FJxJTCc73UnUohqVj4AcpCHveU9+ TvKpUI2qJDeZ0IZ+MpVYzapWtxrLjHL0o8IMq1jHStZejvSYMYXprnD6U6C69a1wjatcr3eR5zUv b8yz6/M4KL0PVu9sawysYx7Hsq5FEWbmq+Lv6CrYxs6FsD58of06KMQqElGEjs0sViD7xNwh8GVT ZGD6NEvaqRxsjKjFIP3GCL37TQ+NwCutbJ/C2YM9qeyw5ZPhYjE7294epbZ5rR8QTcc0/XHMt8hd CnANK1kpKpBsZrNicqdLFatQ97q1aQp2t/sZ63L3uzoJCAA7 ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/slide0002.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)
Area 2 CUG, 20 January 2005
Copyright= 2005 John R. Merrill and Cyndi E. Merrill, All Rights Reserved
2
Agenda
nAgenda Revisions
nBasic Reasons for an RDBMS
nWhat is an RDBMS?
nSome Examples of RDBMSs
nSome Common Uses of RDBMSs
nComponents of an RDBMS
nWhat is Data Modeling?
nData Models
nAn SIRS Area 2 CUG, MS Access Example
nA contacts spreadsheet with relationships
nAn MS Access database for the contacts
nCreating an MS Access Database
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/master04_image002.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlhBAA/AHcAMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAAALAAAAAAB AD0AgAAAABwcHAIGjI+py+1aADt= ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/master04_image003.gif Content-Transfer-Encoding: base64 Content-Type: image/gif R0lGODlh9QE2AHcAMSH+GlNvZnR3YXJlOiBNaWNyb3NvZnQgT2ZmaWNlACH5BAEAAAAALAAAAADz ATQAhwAAAAAAAAAAMwAAZgAAmQAAzAAA/wAzAAAzMwAzZgAzmQAzzAAz/wBmAABmMwBmZgBmmQBm zABm/wCZAACZMwCZZgCZmQCZzACZ/wDMAADMMwDMZgDMmQDMzADM/wD/AAD/MwD/ZgD/mQD/zAD/ /zMAADMAMzMAZjMAmTMAzDMA/zMzADMzMzMzZjMzmTMzzDMz/zNmADNmMzNmZjNmmTNmzDNm/zOZ ADOZMzOZZjOZmTOZzDOZ/zPMADPMMzPMZjPMmTPMzDPM/zP/ADP/MzP/ZjP/mTP/zDP//2YAAGYA M2YAZmYAmWYAzGYA/2YzAGYzM2YzZmYzmWYzzGYz/2ZmAGZmM2ZmZmZmmWZmzGZm/2aZAGaZM2aZ ZmaZmWaZzGaZ/2bMAGbMM2bMZmbMmWbMzGbM/2b/AGb/M2b/Zmb/mWb/zGb//5kAAJkAM5kAZpkA mZkAzJkA/5kzAJkzM5kzZpkzmZkzzJkz/5lmAJlmM5lmZplmmZlmzJlm/5mZAJmZM5mZZpmZmZmZ zJmZ/5nMAJnMM5nMZpnMmZnMzJnM/5n/AJn/M5n/Zpn/mZn/zJn//8wAAMwAM8wAZswAmcwAzMwA /8wzAMwzM8wzZswzmcwzzMwz/8xmAMxmM8xmZsxmmcxmzMxm/8yZAMyZM8yZZsyZmcyZzMyZ/8zM AMzMM8zMZszMmczMzMzM/8z/AMz/M8z/Zsz/mcz/zMz///8AAP8AM/8AZv8Amf8AzP8A//8zAP8z M/8zZv8zmf8zzP8z//9mAP9mM/9mZv9mmf9mzP9m//+ZAP+ZM/+ZZv+Zmf+ZzP+Z///MAP/MM//M Zv/Mmf/MzP/M////AP//M///Zv//mf//zP///wECAwECAwECAwECAwECAwECAwECAwECAwECAwEC AwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwEC AwECAwECAwECAwECAwECAwECAwECAwECAwECAwECAwj/AAEIHEiwoMBmCBMqXMgQoTNnzyI+swbN WrRr17BlxMYRm8GPIEOKHEmypMmTKFOqXMmypcuXMGPKnEmzps2PCKclpJZQJ0KeOXc2e1ht4rNr 0K5Fw7Y048abUKNKnUq1qtWrWLNqXdmwa9eHECNCS5rUaUeOW9OqXcu2rdu3cKV6nbuQWlhrE8ky 3cvxWty/gAMLHky4cEm6iB9KfDYWo+ONHQ1Lnky5suXLKINqbuaTc8/PRI0iVboXskfMqFOrXs36 KmK6YCU2Lqvx7OnWuHPr3s374Ou5dovipUg649LIvZMrX84c7m+viiVStIix9tnm2LNr3z5zM1DP Pz+H/w+Nd/TSpta5q1/Pvr3v5wxjiyVb3fRt9/jz62cNv6vdiMPpdV5Hfu1n4IEIEtZffGHN91h1 1yUo4YQUarVZZxiK5xl5RyU1oGkVhijiiN0tqJB8jNFnVoQktujiiyGZWJczwuVVHF9owajjji3K mFB0AFZ00YrI8WjkkQh6p+F3nfHEoXmlpYfklFS256NDQM5Wn21Vdukldlf+dJeN0Ox1nEZfpqlm YdEo06YycMapzDBzDmPnncPwkicvfPbJSy21NARkig/at+ahiL7l5qJtvknno3Xaqeekee5Zy58X DkWjaB5GWWSioIZqVTSkkiqnnJDiiaeffgqapYrWff8q6qy00mRqo4yiOueuklZKaZ/+bRrgjWfe V+uxyK5U6rKnnvqoqpKy6upi0w0Za47JZqstScziimucqfLqq68vlGsuDOamq8ULWWRBiLuDuBJv K9jQ6wo292K77b7HLutvs81C26ue6RZscBbsZjHIwvO6cm++LPIrsajnlZrrt3CG++yvLxBgcMfp IrzuIPDK6wq9KHdE78Qsh8qUv90CDK7ABH/8cbvtMtywwxDL2vLPXg5Y6ssX66oxuTYXjHC77xIS 77z1Rg0x0FR/+XLFMOcKsMDDJH1wwiQvfLLD+NpmbNVo8yi0mf96mzGv4nadrscGu7D0C00/fXLZ 9Eb/nPbfMHYkNMwWvxlwpHJ7HXLOgzg99sNmAy45jGtXXnjRcD9qMLoGr8t0yVDbW7a+k5deIY6D E27x1rsqHjLYDD8+ut+m144gR5WbebXbGPMKssF0lyvyCyQ7HnrUHK1s+/K3m5266r3L6bq5OCsc eys890w689y3l/v3l7sN7vTsJpy3ySmLvn337G9n25nPq641nOSXn7P1smt/dvv8N4e74Lqz3K0w p4yCBS9ddivf+aB2r775rH8QTI7Z3sc2UgWABRe8IAs2yMEOevCDIAyhCEe4wStw0IQlZIEJV6hC FV5hhS+MoQxnSMMa2vCGNxREDHXIwyv08IeC4GEQ/4dIxCIa8YhITGISWzFEJgaRiVAURBSn2Aoo VvGKWMyiFrfIxS568YtYrFcVxZi+qJXxjGZEnhod6MAJuvGNcIyjHOdIxzra8Y3wC6CZMMjHDPbx j37UIB9FiMIWpvCQLWShIhPJyEU6spGQVOQLXWhDHb7Qkj7cYSZ/uMlOcvKTngzlJ5fYxFI+sZRT lKIqU8nKVbqylbBcZRWlCEaUjfGKZMwlLtHIyzT28pe+DCYwhynMYqIxeSpLJjKXqcY7OvOZcIQf qXYXs2jUb2nWExv2IMelCHpTOf8Lpx6/hw03DfB3BnzdyEC3t5Qh85vw5M0zsQa9a+JMZ48jWzfj yWhP/dTvZuZjZxmn1s+CuuefAL2fNsmmP4M6dD3pBN7HEoiwBe6tgft8qEabg9CbMc5x25zdAzdK Ut1s7mOcK5jn3CVQqc2upDDtTUeVBruFcpN2Mc1patA5t48dcHjF01sZ36nToqolIAA7 ------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/slide0051.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)
Area 2 CUG, 20 January 2005
Copyright= 2005 John R. Merrill and Cyndi E. Merrill, All Rights Reserved
3<= span style=3D'font-family:Tahoma;font-size:42%;mso-special-format:lastCR;displa= y: none'>
Basic Reasons for an RDBMS 1
nEasily handle more complex data than flat files / = = spreadsheets
n= Multiple (0, 1, 2,…) business addresses =
n= Complex relationships among records, such as supervisor, supervisee, CEO,… relationships&= #13;
n&= #13;
nPerform simple queries more efficiently (rather = than complex spreadsheet selects or sorts)
n&= #13;
nPerform more complex  information needs <= span style=3D'position:absolute;top:68.25%;left:8.05%;width:102.24%;height:6.5%= '>(questions asked / queries) than selects / sorts i= n = a flat file / spreadsheet
n= Everybody living in city1 but working (i.e. having= offices) in city2 and (either city3 or city4)
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/slide0052.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)
Area 2 CUG, 20 January 2005
Copyright= 2005 John R. Merrill and Cyndi E. Merrill, All Rights Reserved
4<= span style=3D'font-family:Tahoma;font-size:42%;mso-special-format:lastCR;displa= y: none'>
Basic Reasons for an RDBMS 2
nWork only with the subset of data you need
n= An RDBMS would store states for addresses in their= own “table”.
nIf you’re working with the state, you deal o= nly with a table of states and don’t carry along all the other data (names, etc.).
n&= #13;
nAllow considerably higher scalability <= /span>
n= If go from 100 records to 1 million records, you don’t have to add 999,900 states (with repetitions).  E= ach new record simply points to the state already in the state table.
n&= #13;
nSimplifying storing & using complex data <= /span>
n= Instead of having the same state (say California i= n all the ways you’d like= to display it) in every record, there is one entry (CA, California, Cal,…) in a state table, only referenced in the main table of records.
n“District of Columbia” is 20 characters long.
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/slide0018.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)
Area 2 CUG, 20 January 2005
Copyright= 2005 John R. Merrill and Cyndi E. Merrill, All Rights Reserved
5<= span style=3D'font-family:Tahoma;font-size:42%;mso-special-format:lastCR;displa= y: none'>
What is an RDBMS? – History 1<= /div>
nStarted with flat files - pretty much free-form character data =
n
nRealized there were different sorts of data
nWent to files much like current spreadsheets
n
nRealized there were relationships between files
nPut field in “primary” file which is a record # in = “secondary” file
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/slide0040.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)
Area 2 CUG, 20 January 2005
Copyright= 2005 John R. Merrill and Cyndi E. Merrill, All Rights Reserved
6<= span style=3D'font-family:Tahoma;font-size:42%;mso-special-format:lastCR;displa= y: none'>
What is an RDBMS? – History 2<= /div>
nRealized there were faster ways to move between those files
nCreated Indexed Files with “keys” between file
nIBM’s were called ISAM & VSAM
n
nRealized there were more complicated relationships needed
nCreated databases, families of tables/files
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/slide0038.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)
Area 2 CUG, 20 January 2005
Copyright= 2005 John R. Merrill and Cyndi E. Merrill, All Rights Reserved
7<= span style=3D'font-family:Tahoma;font-size:42%;mso-special-format:lastCR;displa= y: none'>
What is an RDBMS? – History 3<= /div>
nRealized there shou= ld be “rules” for creating “relational” databases
<= span style=3D'mso-special-format:bullet;color:#3333CC;mso-color-index:7;positio= n: absolute;left:-3.96%;font-family:Wingdings;font-size:60%'>n&= #13;
nCreated rules for structuring= the data (normalization, E.F. Codd)
n
nCreated a standard visualizat= ion for the relational data structures (ER modeling, Peter Chen) <= /span>
n
nCreated a language for handli= ng the relational data (standardized language called SQL =3D “Sequel” =3D Structured Query Language)
------=_NextPart_01C5554F.4449ED00 Content-Location: file:///C:/208AD58C/merril_files/slide0025.htm Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset="us-ascii" A Quick Introduction to a RELATIONAL DATABASE MANAGEMENT SYSTEM (RDB= MS)
Area 2 CUG, 20 January 2005
Copyright= 2005 John R. Merrill and Cyndi E. Merrill, All Rights Reserved
8<= span style=3D'font-family:Tahoma;font-size:42%;mso-special-format:lastCR;displa= y: none'>
What is an RDBMS? – Pioneers<= /div>
n
n
n
n&= #13;
n&= #13;