Sunday, January 28, 2018

Databases Concepts

Database Tutorial notes

https://www.cengage.com/school/corpview/RegularFeatures/DatabaseTutorial/db_elements/db_elements2.htm


Get notes for the following and post them on your OneNote page

Database Mining

  • Define the term data mining;
  • What are the benefits of data mining.
  • What are the applications of  data mining.
  • What are the challenges resulting from data mining processes
  • Share an article taking about data mining.
Data Matching

  • Define above term;
  • What are the benefits of data matching.
  • What are the applications of data matching.
  • What are the challenges of data matching.
  • Share an article taking about data matching.
Define the term database normalization

Database security;
  • What are the common database security related issues.
  • What the different solutions to the database related security issues.

Tuesday, January 23, 2018

Database Applications

Database Applications

Task1 
You have each been assigned a particular field to research for any database used there. For each database identified
a) Name and describe how the database is used or works

b) The benefits of databases in the field identified

c) Social and ethical issues arising from using the database in the identified field

d) Suggest some solutions to main problems identified
  • Databases in education
  • Database in health
  • Military Databases
  • Governance or government databases
  • Business databases
  • Medical database
  • Databases used in transport
  • Airline or eservation databases
  • Databses used in entertainment
  • Database used to monitor the environment or climate changes
  • Databases for science and research institutions
  • Business and employment
Task 2

Choose one article from those listed below and answer the following questions and post your findings in your OneNote Page;
Criterion A
     i) What is the main social / ethical issue from the article?
     ii) Who is the main primary stakeholder and why?
Criterion B
  i)
     - Name the technology/System stated in the article 
     - List the IT terms and concepts directly listed in the articles
     - List the IT terminologies that you would use provide more understanding on how the technology works.
  ii) What contributes to the social issue stated in Criterion A to easily occur?

Criterion C
  i) Name three explicitly stated stakeholders in the article and list advantages and disadvantages for each of using the technology

  ii)Name One implicit stakeholder listing the advantages and disadvantage of using the technology

Criterion D
  i) Name one main problem/ main disadvantage of the technology
  ii) State one solution that can be used to solve the problem
  iii) List the strengths and the limitations of your solutions
  iv) State how your proposed solution can be improved in future


a)



Tuesday, January 16, 2018

Databases News Articles

Use the articles in the links below to answer ITGS Paper 2  type questions. 

1. AP: Across US, police officers abuse confidential databases
http://www.usnews.com/news/politics/articles/2016-09-28/ap-across-us-police-officers-abuse-confidential-databases

2. Police database will share data on 15 million people

3. Police building Private DNA databases

4. Three Mobile cyber hack: six million customers' private information at risk after employee login used to access database 


5. Database Error leaves 150 million exposed

6. 'No password' database error exposes info on 93 million Mexican voters

7. Police increasing the use facial  recognition Technology

8. Data Democratization

9. Govt to use Databases track Academic qualifications

10. When Cops commit Crime



Other news on Databases

Mid-term DS Paper 3 Research Activities

  See below the assigned area of investigation Az-zara:  AI-Based Hiring Platforms: HireVue Objective: Research how HireVue uses AI-driven...