Database Management Systems Tutorial Week 2
Database Management Systems
Tutorial Week 1
Weight 1%
.
.
ASSESSABLE TASKS OF THE WEEK
1. Investigate data and information
Data is collected about individuals and groups by a large number of organisations and in a variety of ways.
a) Form a group of approximately four students and discuss the organisation that is allocated to you by your tutor.
b) Fill in the following table as you discuss what data is collected by the different organisation types, and how this data is used regarding individuals and groups.
c) Present your ideas to the class.
Organisation Type
Data collected for individual
What information can be gained from this data about individuals?
What information can be gained from this data about groups?
Government Departments
Name
Address
Driving license number
Phone number
Gender
Birthday
Occupation
Age of each person
Credit History
Driving history
Medical history
Number of population at state, city.
Gender distribution of each state.
Number of Unoccupied population
Banking / Finance
Account number
Name
Address
Phone number
Account balance
Credit history
Total annual deposit of the bank, each branch
Number of accounts of each branch
Retail
Name
Address
Phone number
Parches items
Individual Choice of items
Brand name of parches items
What are the famous brand
Beast selling items
Store wise sell
Education Sector
Name
Address
Phone number
Birthday
Gender
Education history
Education qualifications
Grades of each subjects
Educational level of each country, stat, city
Gender wise educational levels
Search Engines
Name
Email address
Birthday
Gender country Search history
Individual preferences
Most search key words
Likeness of country wise
Gender preferences Social networking sites
Email address
Pass word
Name
Address
Phone number birthday Individual preferences
Tutorial Week 1
Weight 1%
.
.
ASSESSABLE TASKS OF THE WEEK
1. Investigate data and information
Data is collected about individuals and groups by a large number of organisations and in a variety of ways.
a) Form a group of approximately four students and discuss the organisation that is allocated to you by your tutor.
b) Fill in the following table as you discuss what data is collected by the different organisation types, and how this data is used regarding individuals and groups.
c) Present your ideas to the class.
Organisation Type
Data collected for individual
What information can be gained from this data about individuals?
What information can be gained from this data about groups?
Government Departments
Name
Address
Driving license number
Phone number
Gender
Birthday
Occupation
Age of each person
Credit History
Driving history
Medical history
Number of population at state, city.
Gender distribution of each state.
Number of Unoccupied population
Banking / Finance
Account number
Name
Address
Phone number
Account balance
Credit history
Total annual deposit of the bank, each branch
Number of accounts of each branch
Retail
Name
Address
Phone number
Parches items
Individual Choice of items
Brand name of parches items
What are the famous brand
Beast selling items
Store wise sell
Education Sector
Name
Address
Phone number
Birthday
Gender
Education history
Education qualifications
Grades of each subjects
Educational level of each country, stat, city
Gender wise educational levels
Search Engines
Name
Email address
Birthday
Gender country Search history
Individual preferences
Most search key words
Likeness of country wise
Gender preferences Social networking sites
Email address
Pass word
Name
Address
Phone number birthday Individual preferences