<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/> <meta name='google-adsense-platform-domain' content='blogspot.com'/> <!-- --><style type="text/css">@import url(//www.blogger.com/static/v1/v-css/navbar/3334278262-classic.css); div.b-mobile {display:none;} </style> </head> <body><script type="text/javascript"> function setAttributeOnload(object, attribute, val) { if(window.addEventListener) { window.addEventListener('load', function(){ object[attribute] = val; }, false); } else { window.attachEvent('onload', function(){ object[attribute] = val; }); } } </script> <div id="navbar-iframe-container"></div> <script type="text/javascript" src="https://apis.google.com/js/platform.js"></script> <script type="text/javascript"> gapi.load("gapi.iframes:gapi.iframes.style.bubble", function() { if (gapi.iframes && gapi.iframes.getContext) { gapi.iframes.getContext().openChild({ url: 'https://www.blogger.com/navbar.g?targetBlogID\x3d2110564875967830374\x26blogName\x3d%E2%99%A5+Marielle.+Yr+12+IPT\x26publishMode\x3dPUBLISH_MODE_BLOGSPOT\x26navbarType\x3dBLUE\x26layoutType\x3dCLASSIC\x26searchRoot\x3dhttps://justdareyou.blogspot.com/search\x26blogLocale\x3den\x26v\x3d2\x26homepageUrl\x3dhttps://justdareyou.blogspot.com/\x26vt\x3d1537764824001591938', where: document.getElementById("navbar-iframe-container"), id: "navbar-iframe", messageHandlersFilter: gapi.iframes.CROSS_ORIGIN_IFRAMES_FILTER, messageHandlers: { 'blogger-ping': function() {} } }); } }); </script>



entries ● about ● chat ● links

Tuesday, February 8, 2011
Databases @ 3:30 AM
0 comments : click to leave one.

~Databases~
  • Single tables are flat file databases that can have redundant data where the same data is repeated multiple times over
  • Relational databases have multiple tables with minimised redundant data
  • Relational databases also have key fields to link the tables (ID field)
  • The primary key uniquely identifies a record through not every table has one
  • In each field the specific data type has to be defined
  • Data types in a database include; text (alpha numeric), numeric, Boolean (yes/no or true/false or 0/1), memo ("unlimited" length), date and time, objects (digital-images, audio, video, documents), HTML
  • Database Management System (DBMS)