Discuss what data is collected by different organisation

Reference no: EM132195711

Review Questions

1. 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.

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
Banking / Finance
Retail
Education Sector
Search Engines
Social networking sites

2. What is data redundancy, and which characteristics of the file system can lead to it?

3. What is data independence, and why is it lacking in file systems.

4. What is a DBMS and what are its functions?

5. What is structural independence, and why is it important?

6. Explain the difference between data and information.

7. What is metadata in the context of a database system?

Portfolio Questions

Figure 1

1. Given the file structure shown in the Figure 1, answer the followingquestions:

a) How many records does the file contain? How many fields are there perrecord?

b) What problem would you encounter if you wanted to produce a listing by city? How would you solve this problem by altering the file structure?

c) If you wanted to produce a listing of the file contents by last name, area code, city, state, or zip code, how would you alter the file structure?

d) What data redundancies do you detect? How could those redundancies lead to anomalies?

Figure 2

2. Given the file structure shown in the Figure 2, answer the following questions.
a) Identify and discuss the serious data redundancy problems exhibited by the file structure shown in Figure 2

b) Looking at the EMP_NAME and EMP_PHONE contents in Figure 2, what changes would you recommend?

c) Identify the different data sources in the file you examined in Problem 2a).

d) Given your answer to Problem 2c), what new files should you create to help eliminate the data redundancies found in the file shown in Figure 2?

Attachment:- Bigdata and analytics.rar

Reference no: EM132195711

Questions Cloud

Compute the value of the test statistic : a. If he were to conduct a hypothesis test for his theory, what would be the null and alternative hypotheses?

Which ones may be of benefit to vulnerable populations : Which ones may be of benefit to vulnerable populations? Explore nonprofit agencies that are concerned with Women's Health. Share resources aimed to benefit.

Cost of a leading liquid laundry detergent : The cost of a leading liquid laundry detergent in different sizes is given below.

Conduct a capacity analysis of the location and logistics : Develop a flowchart that analyzes the steps of the organization's business processes. Conduct a capacity analysis of the location(s) and logistics.

Discuss what data is collected by different organisation : ITECH1103 Big Data and Analytics - What is data redundancy, and which characteristics of the file system can lead to it - What is data independence

Discuss the clevland clinic facility case management program : Describe and discuss the clevland clinic facility's Case Management program. Compare and critique the subject facility's Case Management program.

What is the interval estimate for the population mean : The average cost per night of a hotel room in New York City is $431. Assume this estimate is based on a sample of 55 hotels and that the sample

Discuss about the health information system : Provide a table that contains lists of all standards that are required for each specific health information system (information system for patients care).

Discuss the functions of finance and human resources : Suppose that a firm is considering moving from a batch process to a line process to better meet evolving market needs.

User Account

All Pages