Databases

=Databases= toc

Resources
[|Download Openoffice] [|Openoffice Tutorials]

//Social and Ethical Issues//
(spreadsheets and databases)
 * privacy of information in different cultures
 * rights of individuals with respect to the storage of personal data
 * social consequences of outdated or incorrect data stored in databases
 * social consequences of the release of sensitive data stored in databases
 * legislation on access and use of database information in different countries
 * responsibility for the security of data stored in databases from different perspectives, eg the developer, the user and the management of an organization
 * accountability for the negative social effects caused by insecure databases
 * ethical issues related to the collection and use of personal data
 * ethical issues related to the selling of data stored in databases

//Knowledge of Technology//

 * Design and creation concepts:**
 * Key terms: field, key field, record, search, query, sort, database management system, mail merge
 * Flat file database versus relational database
 * Paper files versus electronic files
 * Data redundancy and data integrity
 * Updating data
 * Storage and access concepts:**
 * Data transfer between a database and a spreadsheet
 * Search and use of the Boolean operators (AND, OR, and NOT)
 * Data mining/data matching
 * Presentation concepts:**
 * Report generation
 * Special purpose databases eg personal information managers, encyclopedias, library systems

Resources

 * You MUST read this: Types of Databases
 * Beekman, George. (2006). Computer Confluence. Seventh Edition. Chapter 7, pg. 264 (check index for other related entries)
 * [|Computer Confluence] and [|Chapter 7 PPT] (Database Applications and Privacy Implications)
 * Doyle, Stephen. (1999). Information Systems For You. Second Edition. Chapter 8, pg 61, Chapter 30, pg. 255
 * [|Atomic Learning] tutorials for [|MS Access] (see Mrs Lindsay for school login and password)
 * [|Wikipedia on Databases]
 * [|Webopedia on Databases]
 * Geek Girls: [|Databases from scratch] and [|Database dictionary]
 * Sarah Baase "A Gift of Fire', PPT slides (see Chapter 2)