Identify and discuss the serious data redundancy problems

Assignment Help Database Management System

Reference no: EM133091147

ITECH1103 Big Data and Analytics

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

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?

2060_Big Data and Analytics.jpg

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?

Reference no: EM133091147

Questions Cloud

What is the level of production based on the maximin : The operators are now trying to work out the level of home production for the coming year in order to maximize profits. What is the level of production

Promotion and pricing strategies : Identify its primary target market. Create a marketing plan to help a business effectively promote its products and services.

What is the amount of depreciation for the second full year : A machine with a cost of $115,000 has an estimated residual value of $13,000. What is the amount of depreciation for the second full year

Challenges in the Business Environment : Explain how each aspect of your Supplier Code of Conduct is committed to ethical business practices and social responsibility.

Identify and discuss the serious data redundancy problems : What is data redundancy, and which characteristics of the file system can lead to it and Identify and discuss the serious data redundancy problems exhibited

What is the amount of bonds payable : Assume that the market rate for similar investments is 7%. The bonds are issued on the date of the bonds. What is the amount of bonds payable

What is a contingent liability : Question - What is a contingent liability? Provide an example of a contingent liability that's recorded in the accounts and discuss

What is the taxable income and tax liability : Rather than a casino, assume Lee borrowed the money as a single lump sum from his bookie in California, What is the taxable income and tax liability

Affected by achievement of the project objectives : A project stakeholder is any group or individual who can affect or is affected by the achievement of the project's objectives.

User Account

All Pages