Data Transformations: Databases

Introduction to Databases

Links to database notes 

http://www.slideshare.net/sakuvenderzira/c1-basic-concepts-of-database

http://www.teach-ict.com/as_a2_ict_new/ocr/AS_G061/315_database_concepts/terminology/miniweb/index.htm

http://www.quackit.com/database/tutorial/

Database Normalization

http://www.teach-ict.com/as_a2_ict_new/ocr/AS_G061/315_database_concepts/normalisation/miniweb/

https://www.essentialsql.com/get-ready-to-learn-sql-database-normalization-explained-in-simple-english/

Practical Exercises

1. http://fliphtml5.com/cmfu/qunw/basic

2. https://edu.gcfglobal.org/en/access2010/working-with-tables/1/

Use the downloaded GCFAccess2010Sample the link sample database perform the following practical tasks.

a) How many tables have been related to create the Cakes & Pies Sold query?

b) Create a query using Customers Table that filters customer whose First names start with letter A, B, C and D. Save query as ABCD. 

b) Study how Decembers orders query was created and create 2011 Orders query.

c) Create a Switchboard Form that opens all the listed forms and the two Reports

Write short notes on the following;

• Database  integrity, Database reliability, and Database redundancy
• Data matching and Data mining definitions and applications https://www.slideshare.net/smj/data-mining-slides, https://medium.com/neuronio/what-is-data-matching-9478c80da888
• Database security Types types : https://en.wikipedia.org/wiki/Database_security

Databases News Articles

1. Google Maps Databases

https://www.theatlantic.com/technology/archive/2012/09/how-google-builds-its-maps-and-what-it-means-for-the-future-of-everything/261913/

https://www.youtube.com/watch?v=HV46i7xUNXg

2. GPS Databases https://www.youtube.com/watch?v=FU_pY2sTwTA, https://www.wired.com/story/car-hacking-biometric-database-security-roundup/

3. DNA Databases; https://www.theguardian.com/science/2018/feb/03/1000-genomes-project-genetics-dna-database-key-beating-rarest-disorders, https://www.mcclatchydc.com/news/nation-world/national/article217037455.html

https://www.washingtonpost.com/news/true-crime/wp/2018/04/27/golden-state-killer-dna-website-gedmatch-was-used-to-identify-joseph-deangelo-as-suspect-police-say/

4. Government Databases; https://www.cnbc.com/2019/05/16/this-chinese-facial-recognition-start-up-can-id-a-person-in-seconds.html; https://www.nytimes.com/2020/01/12/technology/facial-recognition-police.html