Databases

** Databases: **
Databases are programs designed to organize data in a meaningful way. It offers to store, manage and retrieve relevant information. The program uses tables to manage the data if you are familiar with how to work with Microsoft Excel then you’re familiar with storing information in a tabular form.

(lifted from http://itgsopedia.wikispaces.com/3.7+Databases)
 * **Link** || **Description** ||  ||
 * What is a database? || Database basics from "BBC - GCSE Bitesize" that explains database structure, terminology and basic functionality. ||  ||
 * Relational Databases || From "How Stuff Works" this is a basic explanation of relational databases with links to other useful websites on relational databases. ||  ||
 * Experimental Shoe-Print Database || Using computational forensics they analyzed the images to identify patterns and built a shoe tread databse of more than 10,000 pairs of men's shoes, ranging from Timberland boots to Nike indoor soccer shoes. ||  ||
 * massive DNA database || This article deals with privacy implications as well as the social and ethical consideration of such a database ||


 * Access tutorials: **

1. Basics media type="youtube" key="CZeAdzOmmNM" height="360" width="480"

2. Planning your database media type="youtube" key="aBEjgGheglk" height="360" width="480"

3. Starting Access media type="youtube" key="hiMht6PJtQA" height="360" width="480"

4. Creating Table media type="youtube" key="DjwVE3sS0c0" height="360" width="480"

5. Creating Table2 media type="youtube" key="ioaixiz0OZ0" height="360" width="480"

6. Using Primary Key media type="youtube" key="7nLLhbPzVyY" height="360" width="480"

7. Adding Customers media type="youtube" key="SYK9ClZNwt0" height="360" width="480"

** Where do we use database? **

1. Warehouses - **R**adio **F**requency **Id**entification media type="youtube" key="4Zj7txoDxbE" height="360" width="480"

2. Government Taking Newborn DNA Samples

media type="youtube" key="Na-PzhZ1JLs" height="360" width="480"

3. Biometrics at Airports

media type="youtube" key="fmDVHfDXOws" height="360" width="480"

4. Library Systems

media type="youtube" key="dISaXUlilkU" height="360" width="480"

5.FBI Plans for Biometrics media type="youtube" key="iTVWO-fO29E" height="360" width="480"

6.Electronic Medical Records and Privacy media type="youtube" key="lRTBH6g8McU" height="360" width="480"

7. Whose data is it anyway? Medical databases, privacy and trust media type="youtube" key="5fsNBDZpTgc" height="360" width="480"

Resources lifted from ITGSopedia


 * [|OpenOffice.org - Free software downloads and software reviews - CNET Download.com]
 * [|NYC Data Web | NYC BigApps]
 * [|YouTube - Entity relationship model.mp4]
 * [|YouTube - Logic Data Modeling 8 - Entity Relationship Diagram, part 1]
 * [|DATABASE DESIGN STEPS / HOW TO DEVELOP A DATABASE - a knol by Dave]
 * [|Database design tutorial - Introduction]
 * [|Database design basics - Access - Microsoft Office]
 * [|Fundamentals of Relational Database Design]
 * [|10 Useful articles about Database design]
 * [|Database Design Guide]
 * [|USAID Creates Online Mapping Tool to Track Animal Diseases - NYTimes.com]
 * [|The dirty little secrets of search]
 * [|Robots to Get Their Own Internet]
 * [|Haiti Earthquake 2010 - Family links Network]
 * [|National Crime Information Center (NCIC) - FBI Information Systems]
 * [|Advanced Distributed Learning - What Is SCORM]
 * [|Spine Factsheet - NHS Connecting for Health]
 * [|BBC News - Q&A: Electronic medical records]
 * [|YouTube - Google: Hungry Beast]
 * [|Gary Flake: is Pivot a turning point for web exploration? | Video on TED.com]