Premium Essay

Data Redundancy

In:

Submitted By jellybean14
Words 409
Pages 2
Can a database contain two identical records without a negative effect on the integrity of the database? Why or why not?
Data redundancy is a situation that occurs within database systems and involves the unintentional creation of duplicated data that is not necessary to the function of the database. While redundancy is often a desirable trait in some situations, this is not true when it comes to the function of a database. The presence of duplicated data can often have an adverse effect on the function of the system, resulting in returning information in response to system queries that is less than helpful. One of the key functions of data management identification of duplicated data and the removal of those duplications (Tatum, 2015).
The potential for data redundancy is found in just about any type of database program. Programs that are considered flat, such as spreadsheets, and rely on manual entry of data are particularly susceptible to the duplication of information that may lead to complications when it comes to retrieving the information desired. Relational style databases, such as sales contact databases, often include processes that help to minimize the chances for unintentional duplication, such as the creation of two different contact files on the same contact associated with the same company. Even with the use of system checks to help reduce the incidence of data redundancy, there is still the potential for issues to occur, making it necessary to periodically engage in the task of data cleanup within a database (Tatum, 2015).
At best, data redundancy means that the database is littered with information that is not essential but poses no real threat to the ability to find the data when and as needed. At worst, the presence of the duplicated data slows down the essential functions of the database and can complicate the process of using the database to

Similar Documents

Premium Essay

Employee Conflict Management

...Employee Conflict Management Reductions in force are not a pleasant situation for the employees of a company. I discovered through this simulation that reductions in force are not pleasant for the employer either. Being told a certain number of people have to be laid off presents a problem. People who have good productivity, attendance, and “wow” factors are those that a company wants to keep. However, the company has to consider discrimination when conducting layoffs. What may seem like a good reason for laying someone off may be a reason for an employee to file a lawsuit against the company. During my initial view of the candidates selected for potential layoff, I looked at the skill sets. Although my father works with computers specializing in Linux, networking, and Oracle, I have no knowledge in it myself. I felt like laying-off Carl Haimes or Brian Carter would be a mistake because I do not have skills that can match their skills. Sarah Boyd, Nora Manson, and Jenny Mills each have jobs that I could perform. Even though I may not excel in each job as I would prefer, I felt like it would be easier to cover those positions within the company than those of Carl and Brian. I also considered absenteeism and special achievements as well as overall productivity. Before I made my final selection, however, I considered discrimination. If I were to layoff Sarah, Nora, and Jenny at the same time, I could have a potential lawsuit regarding gender discrimination to consider. I decided...

Words: 1401 - Pages: 6

Premium Essay

5 Rtp

...the principles of effective workforce planning and tools used to carry it out. | | | * Develop basic succession and career development plans | | | * Contribute to plans for downsizing an organisation. | | | LO5: Understand how to maximise employee retention. | * Explain the costs associated with dysfunctional employee turnover and ways of calculating them. | | | * Examine why people choose to leave or remain employed by organisations. | | | * Assess the strengths and weaknesses of different approaches to the retention of talent. | | | LO6: Know how to manage dismissal, redundancy, and retirement effectively and lawfully. | * Explain the main legal requirements in relation to dismissal, retirement, and redundancy. | | | * Advise organisations on good practice in the management of dismissals, retirements, and redundancies. | | | ASSESSMENT OUTCOME | PASS/REFER | | Students should please note that the above Assessment Outcome for this Unit is provisional and is subject to Internal EHWLC verification (IV) and external CIPD Verification (EV). Tutor: Date: Tutor’s signature: Title of report: Resource and Talent Planning Contents Introduction ...........................4 L.O. 2 ......................................4 L.O. 5 ..................................... L.O 6 ..................................... Appendix ............................. References .......................... Introduction...

Words: 5426 - Pages: 22

Free Essay

Human Rsource Managment

...Is there a direct relationship between morale and productivity? According to Robert H. Garin, professor of secondary and higher education at East Texas State University and John F. Cooper, dean of instruction at Patrick Henry Community College, the traditional view that the individual whose morale is high will be highly productive, or vice versa, is not a necessarily valid one. The authors analyzed the historical development of the major representative research studies and concepts concerning the morale-productivity relationship and found that the relationship evolved from one of simple direct correlation to the present viewpoint that a variety of factors--such as the environment, motivation, job levels, and so on--must be taken into consideration before any positive conclusion can be drawn. Because of the national concern over the decline in American productivity standards, Garin and Cooper believe that the morale-productivity relationship is an area ripe for further experimental research Downsizing, the planned elimination of positions or jobs, is a phenomenon that has affected hundreds of companies and millions of workers since the late 1980s. While there is no shortage of articles on "How To" or "How Not To" downsize, the current article attempts to synthesize what is known in terms of the economic and organizational consequences of downsizing. We argue that in many firms anticipated economic benefits fail to materialize, for example, lower expense ratios, higher profits...

Words: 472 - Pages: 2

Free Essay

Redundancy

...FAO: Operations Manager Proposed Redundancies A redundancy situation has arisen within the organisation due to a downturn in the volume of business. We anticipate that this will include 5 employee's from within your team. The following will assist you in the redundancy process: Legal Requirements We need to ensure compliance with the following legal requirements. If we do not there is a possibility of an employee applying to an employment tribunal for a protective award. Consultation – You will need to carry out meaningful individual consultations with all affected employees over a 15 day consultation period. This includes two meetings in which you will discuss reasons for redundancy, the number of employees affected, how they will be selected and how redundancy payments will be calculated. The purpose of redundancy consultation is to allow employees and managers to share problems and to examine the options. This results in them working better together in the redundancy process and reduces uncertainty. Legally we do not have to perform collective consultation as under 20 redundancies are to take place. Fairly select employees – Employees need to be selected fairly for redundancy. According to Acas, 'The Criteria must be consistently applied and be objective, fair and consistent'. This can be achieved by using our criteria matrix which is based upon skills, work standard, attendance and disciplinary records. You will need to score employees on all of the...

Words: 977 - Pages: 4

Free Essay

Business Enviroment

...[pic] Redundancy and Redeployment Frequently Asked Questions 1. What is redundancy? Redundancy is a form of dismissal. A genuine redundancy only arises in three very narrowly defined circumstances: • the closure of the business,: • the closure of a particular workplace – for example an academic unit, department, course, unit or office/building: • a reduction in the need for employees – the test being not whether an employer needs fewer employees, but whether it needs fewer employees to do work of a particular kind. This could be due to restructuring. The key point to remember initially is that it is the post that is redundant and not the employee. Once it has been decided that a post is redundant, the question is what will happen to the employee or employees who hold that post. For a redundancy to be genuine, the role must disappear. New staff may still be recruited, but not to undertake the post the redundant employee was doing. A redundancy does not necessarily have to arise from the need to make financial savings. It is possible that other reasons, such as changed priorities, new technology or processes, could drive the need to restructure the workforce which may lead to potential redundancies. 2. What is redeployment? Redeployment is an attempt to secure suitable alternative employment for employees within the University. The need for redeployment may occur for a number of reasons, including redundancy. The University...

Words: 3911 - Pages: 16

Free Essay

Redundancy

...What is redundancy? Redundancy is not defined in the Employment Relations Act 2000 (“ERA”) but the commonly accepted definition today is that from the Labour Relations Act 1987. Section 184(5) of the Act defined redundancy as: … a situation where…[a] worker’s employment is terminated by the employer, the termination being attributable, wholly or mainly, to the fact that the position filled by that worker is, or will become, superfluous to the needs of the employer… The emphasis in the definition, and in the case law since redundancy has been a feature of New Zealand’s employment law jurisprudence, is on the position rather than the worker who occupies the position. The common law accepts the right of the employer to determine the structure of the business and, therefore, to make positions redundant subject to any redundancies being genuine and carried out in a fair and reasonable manner (G N Hale and Son Ltd v Wellington Caretakers etc IUOW) [1]. The ERA has overlaid this management prerogative with a statutory obligation to act in good faith, including specifically in relation to consultation over changes to the business (section 4(4)(c)), any proposal to contract out or sell or transfer all or part of the business (section 4(4)(d)) and making employees redundant (section 4(4)(e)). Acting in good faith means, amongst other things, where the employer is proposing to make a decision that could mean an employee’s employment is terminated, giving relevant employees access...

Words: 2610 - Pages: 11

Free Essay

Human Resources

...Redundancy essay Discuss the proposition that pursuing short-term cost-cutting through redundancy and downsizing is likely to lead to the creation of lowered employee morale and greater insecurity in employees. Intro People Resourcing and Talent Planning – Pilbream and Corbridge People make the difference to organizational performance and are a source of competitive advantage, but a redundancy situation can unbalance and the organization and destroy the motivation, trust and commitment of the people upon whom the organization will rely on for future success. Redundancy often endangers fear and insecurity which damages the psychological contract between employers and employees, which is detrimental to the organization. What is redundancy and downsizing ACAS: ‘British industry requires constant review of products , methods of work and the application of new technology. The ability to remain competitiveness in the worlds markets depends on this. It is inevitable, however, that the redeployment of labour and redundancies will sometimes be necessary. A poorly thought out approach to change can result in a level of uncertainty which damages company performance and, should redundancies be unavoidable, may lead to financial and emotional costs to the individuals affected’ (Advisory, Conciliation and Arbitration Service, 2009, Redundancy Handling: Advisory Booklet 12. London) People Resourcing – Steven Taylor ‘In the uk the term redundancy is defined by law...

Words: 427 - Pages: 2

Free Essay

What

...For your reference, the following formulae are listed: 1) Transmission rate = (Baud rate) (bits per baud) 2) Nyquist’s Theorem: C = 2 W log2(M) Where W is the bandwidth in Hz, M # of detectable events (a.k.a. signal elements) C is the channel capacity in bits per second 3) Shannon’s Law: C = W log2(1 + S/N) Where W is the bandwidth in Hz, S/N is the signal power to noise power ratio, C is the channel capacity in bits per second 4) The ratio P2/P1 expressed in decibel is: 10 log10(P2/P1) -------------------------------------------------------------------------------------------- 1. Given the following communication diagram, identify each of the blocks appropriately as DTE, or DCE, or CC (communication channel) Personal Modem Telephone Modem Personal Computer System Computer 2. A channel has a signal to noise ratio of 2047.Shannon’s capacity for the channel is 11 kbps. What is the bandwidth of the channel? C = W log2(1 + S/N) 11000 = W log2(2048) 11000 = W * 11 W=1000 Hz 3. Which of the following is a form of software flow control? a) XON/XOFF b) RTS/CTS c) Selective ARQ d) Continuous ARQ 4. Given three channels A,...

Words: 1504 - Pages: 7

Free Essay

Crc Computations

...Lab Project Report | Cyclic Redundancy Check | | 0701020045 Berat Özbay | 25/4/2012 | Contents 1. Introduction: The Need for Error Detection 3 1.1 Error detection process 3 1.2 Types of errors 4 1.2.1 Single bit error 4 1.2.2 Burst error 4 2. Cyclic Redundancy Check 4 2.1 Background 4 2.2 Idea behind the CRC 5 2.3 CRC Algorithm 5 2.3.1 Modulo 2 Arithmetic 6 2.3.2 Polynomial representation 8 2.3.3 Digital Logic 9 2.4 Why CRC works 10 3. The Generator Polynomial and Error Detection Capabilities 10 3.1 Kinds of error CRC detects 10 4. References 11 1. Introduction: The Need for Error Detection In communication systems, data transmitted over a channel will be exposed to transmission impairments. The most significant impairments are attenuation, delay distortion and noise. These impairments cause the received signal to be different than the transmitted signal which is not a desired situation. An error detection technique allows the receiver to determine if the received data is corrupted or not. 1.1 Error detection process To enable detection of errors, an error detection technique appends (n - k) extra bits to k data bits to be transmitted, creating an n bit frame. Appended bits are called redundant bits because they do not change the data bits and discarded by the receiver as soon as the integrity of the data bits is determined. Redundant bits (also called the checksum) are computed as a function of data bits to be sent. Receiver applies...

Words: 2530 - Pages: 11

Free Essay

Input and Output Devices

...Norah Stanley NT 1110 July 12, 2014 INPUT AND OUTPUT DEVICES Chapter three of the textbook Computer Structure and Design is all about the different types of input and output devices that are found on many laptops and desktops. Input and output devices are ports that transfer information. Some examples of input and output ports are USB, HDMI and Network ports. I will discuss their functions and where they are located on the Dell Inspiron 3542 laptop. One of the most popular ports I use is the USB port. USB stands for universal serial bus. The three types of USB ports are USB 1.1, USB 2.0 and USB 3.0. Each port transfers data but at different speeds. The USB 1.1 ports has a top speed of 12 Mbps. The USB 2.0 has a top speed of 480 Mbps. The USB 3.0 has the fastest transfer speed of 4,800 Mbps. The Dell Inspiron 3542 has three USB ports. On the left side of the laptop, there is one USB 2.0 and one USB 3.0 port. The right side of the laptop has the other USB 2.0 port. Another port that is used to transfer information is the HDMI port. HDMI stands for high definition multimedia interface. The HDMI port and cord are used to transport digital video and audio from one device to another. Many smartphones, tablets, dvd and blu ray players laptops, high definition televisions, computer monitors and cameras have an HDMI port. Most of the electronic devices I mentioned usually come with one HDMI port. High Definition televisions are equipped with two or three...

Words: 439 - Pages: 2

Premium Essay

Assignment

...Question 1: What is meant by a “nondeterministic” protocol? Give an example. Question 2: Your wireless LAN device has just sent a request to send (RTS). What happens next? Question 3: Your company wants to create a wireless network for the entire office building. The building is 10 stories high, and the company wants to incorporate IEEE 802.11a by placing one access point on the tenth floor. Will this layout work? Explain. Question 4: Why is ARP necessary if every workstation connected to the Internet has a unique IP address? Question 5: What are the main advantages and disadvantages of: centralized routing distributed routing adaptive routing Question 6: What are the various combinations of circuit switched and packet switched networks and connection-oriented and connectionless network applications? Explain each case with examples. Question 7: Compare and contrast star, bus and ring topologies of computer networks. Question 8: How can a business use a private virtual network and tunneling to support an off-site connection? Question 9: Generate the parity bits and longitudinal parity bits for even parity for the characters 0101010, 0011010, 0011110, 1111110, and 0000110. Question 10: Answer the following: a) In a stop-and-wait error control system, Station A sends packet 0, it arrives without error, and an ACK is returned, but the ACK is lost. What happens next? b) In a sliding window error control system in which...

Words: 321 - Pages: 2

Free Essay

Assignement

...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. d) 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 Passport, Banking / Finance Retail Education Sector Search Engines Social networking sites 2. Data management Given the file structure shown in the above Figure, answer the following questions: a) How many records does the file contain? How many fields are there per record? 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? 3. Question(s) a) Find definitions using your text or other appropriate source for...

Words: 324 - Pages: 2

Premium Essay

System Inventory

...system used at that Virtual Organization. Add rows to the chart as necessary. |System Name |Brief Description |Department to Use |Purpose of the System |Connects With |Development Details | | | |the System | | | | |Fleet Truck Maintenance |Relational database and |Fleet Maintenance |The DBMS will house |Drivers, Fleet |Ease of use – This DBMS has a | |Database Management |an information | |all the maintenance |Maintenance, and the|familiar Windows ‘look and | |System |management tool that | |data tables for |entire organization.|feel.’ | | |helps you store | |Huffman’s trucks and | | | |Microsoft |information for | |trailers, Tire | |Support – Best-selling desktop| |Access/Microsoft Word |reference, reporting, | |Maintenance, | |database with future support | | |and analysis. Microsoft| |Maintenance | |from software parent company. | |...

Words: 650 - Pages: 3

Free Essay

Ciss 301

...the particular item. This reduction in time means a greater degree of efficiency on the part of the system, ensuring the greatest number of users or requests are serviced, rather than letting jobs and requests clog up. 10. The majority of reasons why computer terms are confused is because most users will not or cannot take the time to learn the proper terms and their meaning. Couple this with the fact that not every one who is an expert is of the mind or ability to correct those they encounter, then the situation merely perpetuates and in some cases compounds. A perfect example of this is a recent situation at my job, where the terms Megabit and Megabyte were confused. Because people confuse the two, most applications measure speeds of data transfers in MB/s when they should be measuring in Mb/s. An item we were just launching was getting bad reviews because of slow transfer speeds, it was not until I pointed out the common mathematical error, and showed those I worked with what was going on did...

Words: 758 - Pages: 4

Premium Essay

New System Proposal

...New System Proposal Team A CIS/207 February 23rd 2014 Riordan Manufacturing requires an innovative information system proficient in the organization of product sales, which allows management of data by employees from computers and mobile devices. This new system would contain customer records and be password protected for sales agent’s individual accounts and further promote confidentiality of client and corporate data. Information security and carbon footprints will need to be addressed with creation of a new data warehouse. The cloud computing system would be an idyllic system for addressing the needs of Riordan Manufacturing and would be an inexpensive conversion from the old systems. Cloud computing initially evolved from visualization. The use of visualization would allow Riordan to separate its software, business applications, and data from hardware sources that may experience an issue. The cloud offers storage, network, and hardware virtualization. Businesses can set up private clouds as storage warehouses for company information. Information technology virtualization enhances the business’s assets and offers lower administration fees, reduced maintenance, and consolidation of company information for strategic marketing initiatives in one location. With this in place, there would be less risk of possible loss of important and pertinent information. The entire marketing division would be combined into one superior database for easier comparison of information. Switching...

Words: 1178 - Pages: 5