ITC - Database storage.

SPECIFICATION The problem that I intend to renovate is the inconvenience of the stock check by automating the current system, which is manual and can lead to human error and will limit the time required to fulfil the needed specifications. The current system is manual work and not very accurate, it can cause mistakes and more likely to make errors as stock check is done by hand. It is difficult to find out if an item is in stock. Invoices have to be calculated manually leading to the possibility of mistakes being made. My new computerized system will monitor stock and once it has gone below an assured level then it will automatically re-order stock without the need for human supervision on the stock. My new system will also be able to store vast amounts of information and will allow users to print out appropriate references and other source of valid information. It will be a menu driven program for employees and general use. Requirements of new system is a database storage check which will in turn show the stock available in the shop and will steadily decrease after a period of time and then re-order after a certain level of availability. Also require a processor, which has the ability to run Microsoft Access to store database knowledge of the stock. It will have minimal supervision required which saves time over the other system which requires all the

  • Word count: 1183
  • Level: AS and A Level
  • Subject: Business Studies
Access this essay

An investigation to compare and determine the concentrations of some alkalis in saturated solution.

An investigation to compare and determine the concentrations of some alkalis in saturated solution. Introduction Hydroxides from group 1 of the periodic table are stronger alkalis than those from group 2. Reason being that group 2 hydroxides have lower solubilities. Group1 hydroxides are soluble in water. When these hydroxides undergo titration with acid, the end products are usually salt and water. For example, NaOH (aq) + HCl(aq) H2O + NaCl(aq) An acid based titration is a procedure used to determine concentrations. It involves the neutralization of the base with an acid, both in aqueous solution. It indicates an equivalence point (this can also be termed 'end-point'). This is the point where the colour of the base permanently changes to a pink colour, representing its neutralization. The point is clear to us with the use of an indicator. In this case, the indicator phenolphthalein will be used as Ethanedioic acid is being used. This indicator is chosen because the titration is of a weak acid and a strong base. Metal hydroxides that are soluble make strong bases. It is necessary to construct primary standard solutions when finding out concentrations of solutions. They need to be of a known concentration. Primary standard solutions must: * Be available in a pure source * Be stable in air * Have a high molar mass * Be soluble

  • Word count: 1257
  • Level: GCSE
  • Subject: Science
Access this essay

Make a system, which can print of invoices for customers who place an order via the telephone, which will show details of price, vat, delivery charge and other calculations.

Problem My friend owns a bookshop in his local town called "The Book Warehouse". They buy books in bulk straight from the publishers for cheap prices and then sell them off separately for retail prices. That's how they make their money. The company is divided into two parts. One part deals with everyday High street customers and the other part is phone based. My friend takes care of the phone based part on his own. Customers from all over the country phone the shop and order their books. My friend writes down the name of the book that the caller wants and their phone number. The reason he takes their phone number is because he has to find out how much the books costs and then has to calculate the V.A.T, delivery charge and maybe a discount if a large quantity of books are ordered. This takes too long and so my friend just decides to call the caller back instead of the caller staying online. When my friend has called the caller and they have decided to order the books, my friend then has to fill out an invoice with all the calculations twice. One of the invoice is for the customer and the other is for the company, so it can keep a record of what the customer has bought. This whole process can take up to 5 minutes. At the moment the shop has a small amount of stock and already my friend is feeling the heat. On average he receives a phone call every 2 minutes and one

  • Word count: 1207
  • Level: GCSE
  • Subject: ICT
Access this essay

Comparative analysis of stress levels using ANSYS and classical approach

Introduction A large screen is to be mounted upon a beam; the aim of this analysis is to establish whether it should be directly placed on the beam or through a fixed pillar by comparing values obtained from the classical approach and FE method. Finite elements solve by breaking up a problem into small regions and solutions are found for each region taking into account only the regions that are right next to the one being solved. Whereas, the classical approach involves the use of free body, shear force and bending moment diagrams. Furthermore, the weight of the beam will be analysed to see if there is any significance to the stress when taking it into consideration or not. In addition, the reliability of the values obtained through the different methods will also be taken into account. CASE 1 Point Load (without weight) Free body diagram: => R1 + R2 + Fy = 0 => R1 + R2 + 5 = 0 => R1 = - R2 - 5 => ( 2 x 5 ) - (|R2|x 4 ) = 0 => 4|R2|= 10 => |R2 |= 2.5 kN => R2 = - 2.5 kN => R1 = - ( -2.5 ) - 5 => R1 = - 2.5 kN Shear force diagram: Bending Moment Diagram: Calculating Stress: In order to calculate stress we need to find the second moment of area using the following equation: Ix = D^4 = ( 0.2 )^4 = 1 12 12 7500 Then use the following formulae to calculate stress ?: ? = maximum bending moment x ( y ) = 5000 x

  • Word count: 1343
  • Level: University Degree
  • Subject: Engineering
Access this essay

My hypothesis is, if a student (who is an adult) walks or cycles to school every morning, then they are thought to be fitter than the students who go by the means of transport, like a Car, Bus or Tram. The way Im intending to prove this is by using the

Mathematics Coursework Statistics Introduction & Hypothesis For this piece of coursework, I have gathered data on 30 girls and 30 boys in Year 11. The Body Mass Index theory (which I will explain later on) can only be applied on adults. Year 11 students are counted as adults. This is why I am able to use the students in this piece of coursework. My hypothesis is going to act in the form of my prediction as well. Therefore, if this prediction is proved correct by the end of this coursework, I am successful. My hypothesis is, if a student (who is an adult) walks or cycles to school every morning, then they are thought to be fitter than the students who go by the means of transport, like a Car, Bus or Tram. The way I'm intending to prove this is by using the BMI (Body Mass Index) Theory is a way of comparing the height and the weight of an adult, and seeing whether they are under weight, normal, over weight or obese. I can work out the BMI by doing a simple calculation; Weight Answer = BMI Height There is also a grid to help understand the BMI theory; BMI Weight Status Below 18.5 Under Weight 8.5 - 24.9 Normal 25.0 - 29.9 Over Weight Above 30.0 Obese BMI is going to help me decide which students fit in which category. It will also cut down the amount of students I'll need to focus on. The BMI will also help me reveal that my hypothesis is

  • Word count: 1284
  • Level: GCSE
  • Subject: Maths
Access this essay

How the resistance of a thermistor changes with temperature keeping the current constant and recording the voltage as the temperature changes.

My Aims I aim to find how the resistance of a thermistor changes with temperature keeping the current constant and recording the voltage as the temperature changes. I will then record this data and try to explain it using scientific knowledge and detailed reasoning. Background information - Thermistors Thermistors are thermally sensitive resistors and have, according to type, a negative (NTC), or positive (PTC) temperature coefficient. They work because at low temperatures, electrons are fixed onto atoms and so cannot move. As the electrons get hotter they receive enough energy to escape from their atoms, so the thermistor becomes a better conductor. Materials that react like this are called semiconductors. Carbon, silicon are two materials whose resistance decreases as they get hotter. Thermistors can be used for the following functions: * Temperature sensing, switching at temperatures ranging from 60°C to 180°C, e.g. protection of windings in electric motors and transformers. * Solid state fuse to protect against excess current levels, ranging from several mA to several A (25°C ambient) and continuous voltages up to 600V and higher, e.g. power supplies for a wide range of electrical equipment. * Liquid level sensor The equation used for calculation of the resistance of the thermistor is: Resistance = ( R= )

  • Word count: 1296
  • Level: AS and A Level
  • Subject: Science
Access this essay

Statistical Analysis: Homework at IU

Statistical Analysis: Homework at IU The online degree programs are specifically designed for the professional who juggles a career, family and other commitments. Colleges are challenged with the task of designing and supporting a balanced program that fits the busy schedule of the students without sacrificing quality. Prospective students are always concerned if the program would take too much time and interfere with their professional and personal life. At IU, on average, students are expected to spend about 1.5 hours per day working on assignments. However, after the first 5-6 workshops in Statistical Analysis, I was under the impression that I spend on homework more than 2 hours every day. To test my hypothesis I started recording the actual time I work on assignments. I kept records for 3 consecutive workshops. The results are provided in the table that follows: Day of Week Date Time in Minutes Tue 7-Dec 90 Wed 8-Dec 180 Thu 9-Dec 200 Fri 10-Dec 140 Sat 11-Dec 120 Sun 12-Dec 150 Mon 13-Dec 60 Tue 14-Dec 30 Wed 15-Dec 40 Thu 16-Dec 180 Fri 17-Dec 120 Sat 18-Dec 75 Sun 19-Dec 310 Mon 20-Dec 60 Tue 4-Jan 60 Wed 5-Jan 60 Thu 6-Jan 240 Fri 7-Jan 320 Sat 8-Jan 120 Sun 9-Jan 200 Mon 10-Jan 45 To analyze the data I used hypothesis testing. This is a procedure that is based on sample evidence and probability

  • Word count: 1273
  • Level: University Degree
  • Subject: Mathematical and Computer Sciences
Access this essay

Activities of Tesco finance function.

To: Alexander From: Sawsan Subject: Functional Areas Date: 29 November 2006 Tesco Purpose of finance in Tesco The purpose of the financial for Tesco is that it takes responsibility for organising their financial and accounting affairs including their preparation and presentation of appropriate accounts, and their provision of financial information for managers. What does Tesco finance do? Activities of Tesco finance function Preparing accounts in Tesco The finance staffs in Tesco have of perform a range of activities related to the checking and recording of all amounts received and paid. In each case Tesco are entered into particular accounts. In Tesco, there will be accounts covering sales, purchases and expenses. Information like this is normally computerised in Tesco so up-to-date information can be processed straight away. The information Tesco obtain is known as management information because Tesco managerial decisions would be based on items being sold what popular bands are etc. Tesco financial accountant on the other hand is the person responsible for assembling all the accounts into a format that is required for legal reasons. Paying wages and salaries in Tesco Tesco wages section of the financial department will be responsible for calculating the wages and salaries of employees and organising the collection of Tesco income tax and Tesco national

  • Word count: 1271
  • Level: GCSE
  • Subject: Business Studies
Access this essay

Antibiotic Resistance

Assignment 3: Evolution and Heredity Darwin's evolutionary hypothesis dictates the survival of the fittest. Accordingly, bacteria that overcome the onslaught of antibiotics (which can destroy them) and still replicate, provide a survival advantage for future generations of the same bacteria. However, from the human viewpoint, this genetic resistance to antibiotic treatment can be detrimental. Not only can ineffectiveness of antibiotics lead to exacerbation of an infection within an individual that may have been overcome, but can lead to the spread of an infection within a population that could have been contained. There is an economic consequence of this resistance as additional treatments, hospitalisation and lost labour hours cost money. More importantly, in the worst cases, unchecked infections of this type can lead to death. A very real example of this situation is multi-antibiotic resistance present in a strain of Staphylococcus aureus. This multi-resistance arose in stages1; penicillin resistant S. Aureus were first described within a few years of penicillin being introduced in clinical practice. To combat this resistance, a semi-synthetic penicillin, methicillin, was used. Within a year however, a penicillin and methicillin resistant Staphylococcus aureus (MRSA) strain was described. Subsequently, vanomycin has been used in the fight against MRSA but recently

  • Word count: 1252
  • Level: University Degree
  • Subject: Biological Sciences
Access this essay

Investigate the relationship between speeds of a glider on an air track and the starting distance form the light gate.

AS Practical 3: Data analysis The brief for the experiment was, to investigate the relationship between speeds of a glider on an air track and the starting distance form the light gate. With constant distance and acceleration. For this experiment we were given a pre-designed experiment and were instructed to record the time distance and speed of the glider when passing through the light gate, once this data was obtained we had to analyse the results. I felt the best way to analysis the data was to draw a graph and using a suvat equation to explain the trend of the graph. Or though I have decided to use suvat equations I could have used energy consideration to derive a similar graph and use this to explain the trend of the experiment. Apparatus * 50g weight * Clamp and stand * BBC computer * Air track * Glider * Thin fishing line * Light gate * Blower * 95mm piece of card Diagram Method As this was a pre-designed experiment the equipment was already set-up. We measured the length of the card, this was 95mm, and we then entered this information into the computer. This would allow the computer to calculate the time when the light gate is broken and give us a resultant of speed. This is done because the card is inserted into the top of the glider and the front of the card breaks the beam and the end of the card allows the light gate beam to reform and there for

  • Word count: 1300
  • Level: GCSE
  • Subject: Science
Access this essay