• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
  1. 1
  2. 2
  3. 3
  4. 4
  5. 5
  6. 6
  7. 7
  8. 8
  9. 9
  10. 10
  11. 11
  12. 12
  13. 13
  14. 14
  15. 15
  16. 16
  17. 17
  18. 18
  19. 19
  20. 20

Infernowear is a new company run by a self-employed creative designer aiming to producing clothing at reasonable prices aimed at young teenagers who are into the skateboard clothing fashion.

Extracts from this document...


Introduction: Infernowear is a new company run by a self-employed creative designer aiming to producing clothing at reasonable prices aimed at young teenagers who are into the skateboard clothing fashion. As this company has just been set up all orders are phoned through and then written down on any spare paper lying around. At the moment the owner has too much freelance work coming through and is unable to spend the time properly designing and implementing an order system even though he is quite capable. This system will be used to record orders as they are phoned through and also to keep track of the different garments and number in stock. User requirements: Specifically the system should be able to carry out the following procedures. * Store the details of customers and their orders * Keep a list of all garments and garment logos * Record and update stock levels automatically after each order has been recorded * Ability to print out shipping labels for each order placed * Ability to expand the product range by adding new types of garment and garment logos to the system * Each logo and garment should have a simple product code that makes identification and inserting into the database easy and fast. * A search option should be included so that stock level and customer orders can be quickly displayed * A variety of data should be printed in reports including shipping labels and the order line. * As personnel details will be stored it is essential that the system is password protected so that it keeps this data safe and complies with the data protection act. Feasibility study: I will now carry out a feasibility study, as it is the first stage of the systems life cycle. After this I will then make a full detailed investigation into the current system and requirements of the new proposed system. ...read more.


There will also be an auto customer ID number assigned to each new customer. Also I would like to insert a "memo" text box so that any special information about the customer can be logged here, this could include previous complaints and any payment problems. editClothing & editLogos: These two forms will enable the user to add different types of garment and logos whenever new designs are produced. This will make updating the system easy and hassle free because you don't have to manually enter the new products into the complicated forms. FrmOrderline: This form will be where all orders are made; it will use a query called qryOrderline that combines the customer, clothing and logo tables. This data will then be displayed in a sub form within the qryOrderline form. After an order has been made it will then be added to the Orderline table. Report design: My system will include four reports, one for printing shipping labels, two for logos and garment labels these will be stuck to the deliveries as they come in from the printer so that each box of products are easily identifiable when looking in the stock room. The other report will be the master order line consisting of all the customer orders so that Mr Hull can take this into the store room and gather all items needed with out needing individual customer order sheets. Report names: LabelCustomer: This report will be based on the query qryOrderline showing each customer who has an order & with there shipping address. LogoLables: This report will be based on the Logos table giving the user the ability to print out identification labels for labelling the stock. ClothingLables: This report will be based on the Clothing table giving the user the ability to print out labels for identifying the stock. OrderLine: This report will be produced from the query qryOrderline showing all orders with only the customers name and ID; this saves space, paper and ink. ...read more.


I have not been able to test this part of the system, but the report is set up to print on standard A4 labels so I see no reason why it would not work, obviously the label paper would have to match what the system is set up to print. A payment-received option has been added thus only showing orders that have been paid for, on the main master order report. This is a complete success and works with out any glitches or problems. The last performance indicator stat that the stock level should be updateable after each item is booked out. This has eventually been done after a lot of research into SQL and after a lot of time spent getting the syntax just right. It is a small simple piece of code that has fulfilled this last performance criterion. Future enhancements: At this point in time there is no report for printing customer recites, this is quite important but is easily doable and will be completed after Mr Hull gets back from his holiday cruise. Each item could be given a stock location as well as an amount. This would then make sure that if the stock room were to grow the system would already be able to store the individual stock location of any one item. Last but not least it would be a nice idea to include some sort of mail merge so that whenever a letter has to be sent out to all customers it can be automated saving a lot of time manual work. Mr Hull is currently using this system to see whether it's the sort of program that can do the tasks he specified earlier in this document. If this system proves to b built to a high standard he will use it until it needs updating or extra more complicated features are needed, at this point he may be forced to invest in an off the shelf package solution. Unfortunately Mr Hull is on holiday and I am unable to contact him and get any further feedback. Pete Britten Infernowear Database project 1 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Computer Science section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Computer Science essays

  1. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    * Voluntary deductions Voluntary deductions include payments like voluntary contribution towards PF etc. Moreover, you differentiate between: - * One-off Deductions For example a donation * Recurring Deductions For example, in the case of imputed income or a savings plan.

  2. Computing Project

    the DVD which is specific to every DVD movie This table will contain all the usernames and passwords which will allow the user to enter into the system. 4. Storage media and format The media I intend to use to store my programs on is a CD-ROM disc.

  1. GCSE I.T Security Case Study - Riverside Leisure Centre

    Also, when I walked around the outside of the complex I noticed that there is barbed wire at the top of all high walls around the complex so it would be difficult and painful, if not impossible to enter the building by climbing over the walls.

  2. Barilla SpA - Case Report

    Inventory shortage at distributor end may be substituted by competitor's products - distributor's main aim to push products once bought 6. Increased risk of stock-out at customer end - disruption in supply process due to strike/disturbance 7. Impossible to run trade promotions with JITD - can't push Barilla products without incentive 8.

  1. Hardware and Software

    be looked at from a very wide angle, practically from the side. 5. CRT monitors are generally more affordable than LCD monitors. I would suggest them to buy CRT monitors OR buy bigger LCD flat monitor because I think a larger monitor will accommodate all those floating palettes that modern

  2. Discuss the relationship that exists in the UK between the legal rules that govern ...

    be formal and transparent for developing policy and fixing remuneration of individuals, it can be seen how much directors earn in the annual report of a company and now a days many people look at that first when looking at investing in a company.

  1. Tod's Tyres is a small business that supplies new car tyres to company car ...

    To overcome this problem, I have password protected my database. The password is "tod2004". Implementation/Testing Test plan Test No Test Purpose of test Expected outcome 1 To check the system only allows Car Registration numbers of the post-2001 format The system would only allow car registration numbers of post 2001

  2. Programming Techniques

    For example by specifying the wrong number or type of parameters in a subroutine call, or tying to assign a real value or a string of characters to a variable which has been declared as an integer e.g Num1 := 'Testing' {Num1 is an integer varaible} * Logic error: the

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work