Cunha & Ribeiro Ltd: Stock Control & Invoice Database

Cunha & Ribeiro Ltd: Stock Control & Invoice Database Centre Name: Parliament Hill School Centre Number: Candidate Name: Carlos Fernandes Candidate Number: Table of Contents Analysis 6 Problem Definition 7 Background to the Company 7 Initial Problem Definition 7 The Current System 8 Data Flow in Current System 10 Origins of Data 10 Analysis of Current System 11 Restatement of Problem 11 Investigation and Analysis 12 Justification of Methods of Fact-Finding 12 Fact Recording: 2 12 Analysis of Data 14 Requirements Specification 14 Agreement from Organisation to Requirements 17 Alternative Approaches 18 Selected Approach 20 Acceptance from Organisation to Selected Approach 21 Hardware Requirements 22 Design 23 Nature of the Solution 24 Set of objectives 24 Design Specification 25 Input 25 Customer Details Input Document: 25 Delivery Appointments Input Document: 26 Sales Details Input Document: 27 Available Stock Input Document: 28 Payment Plan Input Document: 29 Customer Details Input Screen: 30 Sales Details Input Screen: 32 Stock Input Screen: 33 Payment Plan Input Screen: 34 Processing 35 Output 38 Delivery Report: 39 Out-Standing Payments Report: 40 Available Stock Report: 41 Append Query: 41 User Interface 42 Report Switchboard 43 Error Messages 44 Files and Data Structures 44 File Sizing 48 System Diagrams 51 Task Model 53

  • Word count: 16932
  • Level: AS and A Level
  • Subject: ICT
Access this essay

Database Coursework on a Vehicle Rental System: Analysis

Introduction I am a student starting my second year of A levels at a College of Further and Higher Education and one of these A levels is ICT. The A2 part of the ICT A level consists of three modules, one of which is coursework and it is worth 40% of my overall A2 grade. The coursework requires me to identify and conduct research into an open-ended problem that exists for a real end-user. From results of this preliminary research, I must design an appropriate ICT-based solution for the problem using the skills and knowledge that I have acquired throughout the duration of my course. After designing such a solution, I will develop the actual software to be used to address the problem along with the technical documentation. This software will then undergo extensive testing so that I may identify and correct any bugs that may be present within the system. Plans on how the system will be implemented will then be made, including any training the staff will need and how existing data will be transferred into the new system. Finally, the User Documentation will be produced and I will evaluate the system on a number of various criteria to see if it meets the requirements outlined at the analysis stage. Throughout the whole process, I will be using the skills and experience that I've acquired in the first year of the course (and what I will be learning this year) to incorporate a wide

  • Ranking:
  • Word count: 15099
  • Level: AS and A Level
  • Subject: ICT
Access this essay

Performance Evaluation of an End-to-End Measurement Based Call Admission Control Method

Performance Evaluation of an End-to-End Measurement Based Call Admission Control Method . by Balázs Soós mailto:[email protected] http://web.axelero.hu/kssoftware/balazs 2. Master's Thesis Submitted for the Diploma in Computer Science Department of Telecommunications and Telematics Budapest University of Technology and Economics Advisors: István Szabó,Dániel Orincsay,Ericsson Research Tibor Cinkler PhD, Budapest University of Technology and Economics Budapest, 2003 Abstract The modeling and the performance evaluation of Call Admission Control solutions in IP-network are still famous research areas in our days. One trend of these areas is represented by the End-to-End Measurement Based Call Admission Control methods. There are two main approaches of them: In the passive approach, the communicating endpoints are continuously tracing the main QoS features of the live traffic generated by themselves. They decide upon the gathered statistics if the network is capable of serving a new call demand, while preserving the adequate QoS in the network. In the active approach, the endpoints generate test-packets in the network to measure their delay and jitter in order to estimate the available network resources. In this thesis a new Call Admission Control method is proposed for IP-telephony-gateways that is based on the active method called Self Loading Periodic

  • Word count: 13519
  • Level: AS and A Level
  • Subject: ICT
Access this essay

The Impact of Mobile Phones on social Interaction

The Impact of Mobile Phones on social Interaction Marwan Nawaz ABSTRACT This dissertation attempts to understand the reasons behind the growth of mobile phones and the impact of this growth on social interaction. In order to achieve this aim, the study looks at two separate communities. It firstly looks at the impact the mobile phones have had on the social interaction of the general public, and secondly it take a more concentrated look at the subject by studying the impact on the 13-18 year old community. This aim was achieved through the use of questionnaires, a focus group and a literature search. The questionnaires were conducted on both the general public and 13-18 year old community. Similarly, the focus group was also conducted on the 3-18 year old community to gain a deeper understanding of the questionnaire results. Analyses of these questionnaires and focus group, combined with the literature search form a major part of the project. Findings suggest that there is no single reason behind the growth of mobile phones and different factors hold varying levels of importance depending upon geographical, economic, political and social factors. Similarly, whilst mobile phones have had both a positive and negative effect on social interaction, it may be fair to conclude that the positive effects outweigh the negative effects. It is concluded that, it is

  • Word count: 13153
  • Level: AS and A Level
  • Subject: ICT
Access this essay

Database Coursework on a Rental System: Design

Breakdown of Tasks Description of tasks Expected Date of Completion Consideration of possible solutions 9th October Features of Access 21st October Normalisation 24th October Entity Designs 2nd November Relationship Design 4th November Data input form design 2th November Query Designs 20th November Report Designs 25th November Menu Designs st December Macro Designs 7th December Code Designs 1th December Mail-Merge Design 5th December Gantt Chart For Design Tasks 2 3 4 5 6 7 8 9 0 1 2 3 4 5 6 7 8 9 20 21 22 23 24 25 26 27 28 29 30 Consideration of Possible Solutions Features of Access Hardware and Software Specification Entity Design Relationship Design Data Input Form Design Query Designs Report Designs Menu Design Macro Design Code Design Mail-Merge Design Consideration of possible solutions As outlined in the Analysis stage, there are many problems with the current manual system in use for recording, storing and manipulating data. A computerised solution would be the most effective way to tackle these problems inherent in the current system. Obviously, there many types of computerised solution that one can use and different types of software that can be used to design and use the package on. However, firstly I shall discuss the ways one can go about obtaining such a package. These ways include: *

  • Word count: 13073
  • Level: AS and A Level
  • Subject: ICT
Access this essay

ICT AS-Level Coursework

Coursework Background I am representing a top of the range designer clothing chain store situated I the heart of London's park lane. This is the most popular designer chain store in the UK it has a range of celebrity clients from David Beckham to FHM cover girl caprice. This designer chain store has been repeatedly referred to as the home of fashion it has designer labels from the Italian fashion idols Dolce & Gabanna to Burberry London. The chain store managers have direct connections to all top designers all over the world like Versace, Armani, Prada, Gucci, D&G and of course Louis Vuitton, the stores all have exclusive clothing not available anywhere else worldwide. Problem The problem that they are facing is that the current system is very limited to responses it doesn't do much at all it can do is store bits of information and it has very limited functions built into it therefore they are very anxious to get a program that can fulfil everyone of our needs including data recollection and stock level adjusting, and so on, this is why they require simple yet effective receipt system. The solution needed to solve the needed and requirements of Unique fashions plc. . The first requirement is to have a full-computerised digital database which holds of the product that they stock. 2. There must be some sort of secure login facility,

  • Word count: 12363
  • Level: AS and A Level
  • Subject: ICT
Access this essay

ict as level coursework

CONTENTS PAGE Name Pages _____________________________________________________________________ Specification 2- 15 Implementation 15-44 Testing 44-55 User Documentation 55-67 Evaluation 67-71 Background on company Welcome to Magic Herbal Products, which was founded by Sarah Lenington in 2003, who travelled across the world in search of some of the rarest herbal and organic remedies. Sarah was born in London and studied dermatology at a top university. Her passion was making others feel good about themselves so she decided to take up the opportunity to travel several countries in 1997 in the hope of finding natural ingredients instead of artificial products that are prone to cause skin deterioration and allergic reactions. Her discoveries of mineral oils and powders as well as plant extracts were tested in labs for over three years. This was a major procedure to ensure the ingredients were compatible with both skin and hair. It was important that all ingredients used in each product was natural and was not tested on animals. The ingredients were found in Indonesia, Malaysia, India and also Egypt. What makes Magic Herbal products so different to any other brand is the purity of the products as well as their campaign against testing products on animals. Furthermore the packaging of all their products is recycled to ensure they

  • Word count: 11562
  • Level: AS and A Level
  • Subject: ICT
Access this essay

Data Processing Task. Mr Peters, the man who runs this particular Samsung store has approached me and asked me to investigate his current system of usage for keeping records of customers buying products from the store.

Data Processing task 4 Bridge Street Banbridge Co. Down BT323NB Northern Ireland Contents Analysis Background Information: Page 5 Location: Page 6 Introduction: Page 7 Current System Page 8 Problems with the current system: Page 8 Objectives of the new system: Page 10 Inputs, Processes and Outputs: Page 11 Information Requirements: Page 13 Quantative and Qualitive Objectives Page 14 System Design Page 16 Design Entities with Attributes Page Possible Solutions Page Form Design Page Switchboard Design Page Report Design Page Calculations Page Mail Merge Page Queries Data Dictionary Page Macros Data Dictionary Page Testing Test introduction Page Test Plan Page Results Page User Guide Description of Package Page Hardware and Software Configuration Page Installation Guide Page Operating Instructions Page Switchboard Page Order Forms Page Macro Guidelines Page Reports Page Mail Merge Page Troubleshooting Guide Page Background Information Samsung is a Korean company that has risen to prominence in many fields over the years. Samsung is a Korean company that has risen to prominence in many fields over the years. The size and the scope of the company is almost unimaginable, as they are one of the largest and most diverse companies in the world. While the company is mostly known for their

  • Word count: 11133
  • Level: AS and A Level
  • Subject: ICT
Access this essay

This research that I've done will discuss about the effectiveness of the Light Railway Transit (LRT) in Kuala Lumpur.

.0 INTRODUCTION The Malaysian government worked hard in making our beloved nation as a developed country beyond the year 2020. To achieve the goal is not an easy task because it really needs a large amount of commitment. One of the criteria of a developed country is the ability to overcome the country internal problems. Therefore, as a step to overcome the traffic congestion problems, Malaysian government planned the Light Railway Transit (LRT) development. By the way, how far the effectiveness of LRT in overcoming the problem?. A question that appears after several years LRT operated in this country. This research that I've done will discuss about the effectiveness of LRT in Kuala Lumpur. .1 LRT and Urbanization: The Relationship. Kuala Lumpur (KL), the capital of Malaysia, has an area of 243 km² with a population of 1.4 million and a total current employment of 838,000 people. It is the centre of Malaysia's economic activity with 12.4% of total GDP. KL is situated within a larger economic zone known as the Klang Valley, spanning an area of 2843 km². Vehicle ownership in Malaysia has passed 10 million vehicles with an estimated 2.5 million vehicles in the Klang Valley alone. With the rapid vehicle growth rate of 8% per annum, the government realized that uncontrolled urbanization and motorization would result in environmental deterioration and more traffic trams and

  • Word count: 9065
  • Level: AS and A Level
  • Subject: ICT
Access this essay

From the e-commerce strategy you gave me earlier I understand that by having a website and selling goods via the site I need to be aware of certain laws and regulations, can you please give me a brief description of each law and how they will affect the c

Assignment 3 Unit 8 and 28 P1 Outline the web architecture and components which enable internet and web functionality P2 Explain the user side and server side factors that influence the performance of a website P3 Explain the security risks and protection mechanisms involved in website performance. M1 Explain the role of web architecture in website communication D1 Explain the role of the TCP/IP protocol and how it links to application layer protocols. Q1 (EP4) From the e-commerce strategy you gave me earlier I understand that by having a website and selling goods via the site I need to be aware of certain laws and regulations, can you please give me a brief description of each law and how they will affect the company. The Copyright and Patents Act of 1988 The Copyright and Patents Act of 1988 is an act of parliament where inventors can apply for patents to prevent anybody copying their designs for up to 20 years. To qualify for a patent the invention must be novel and have an inventive step not obvious to an expert in the field. You cannot patent literary or artistic works, presentation of information or computer code. These come under copyright. Copyright means you can't you copy something that has already been copyrighted. For something to be copyrighted, you must be the owner of the work, and it must be your own creation. This means copy and use

  • Word count: 8151
  • Level: AS and A Level
  • Subject: ICT
Access this essay