• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Database management

Extracts from this document...

Introduction

ICT Coursework-Databases

Background Information

The organisations name is Games 4 You and their slogan is “More Games 4 You 4 Less”. The founder of Games 4 You is the new upcoming entrepreneur Miles Zest he launched this company 2003 and already the competition is vast with new and old companies trying to achieve what Games 4 You has achieved. The organisation is fairly big with 256 employees across 13 branches in the U.K. also Approximately 560 games, 230 accessories and 20 consoles are sold everyday, most of the branches are in England, 3 in Northern Ireland and 6 in Wales, The company is planning to open stores in most countries in Europe then if thing go to plan go worldwide and open stores in Japan, America and China but they say they need a new system that is efficient to achieve this.

The current system

Approximately 560 games, 230 accessories and 20 consoles are sold every day but all of these purchases are done on a till and paper so it is paper based and is very inefficient and slow so less purchases are made from high demanding customers. Also the information such as addresses, names, surnames, numbers and receipts are recorded on paper and filed. When stock is finished of a particular item the order to restock it is written on paper and even costumers orders is written on paper and stored.

Problems with current system

Because

...read more.

Middle

The hardware available at Hornsey School for Girls are as follows:

Pentium 4 processor

DVD/CDRW with floppy disk drives.

Input Devices

Keyboard-to enter information in databases and/or other applications.

Mouse-to click on various buttons to do what you want.

Output Devices

Printer Brother Laser jet HL – 1870N-to print out any information needed in hard copy.

Processor

Clock speed:      2.8 GHz

Processor type:  Intel Pentium 4

Installed processor qty:  1

Max supported processor qty: 1

RAM

RAM installed: 256 MB

Max supported RAM: 2 GB

Memory specification compliance: PC2700

Memory speed: 333 MHz

RAM form factor: DIMM 184-pin

RAM technology: DDR SDRAM

RAM upgrade rule: Max 2 x 1 GB module

System

Recommended use: Small business, corporate business

System type: Personal computer

Video Output

Video Output / Graphics Processor / Vendor: Intel 865G

Max colour resolution (external) : 32-bit colour

Max resolution (external) : 2048 x 1536

Video output form factor : Integrated

Video output interface type : AGP 8x

Video output type : Graphics adapter

Optical Storage

CD / DVD type: CD-ROM

CD / DVD read speed: 48x

Optical storage interface type: IDE

Storage Hard Drive

Hard drive interface: ATA-100

Hard drive size: 40 GB

Hard drive type: Standard

Spindle speed: 7200 rpm

Interface Provided

Interface: 4 x USB, 2 x PS/2, 1 x Ethernet, 1 x VGA, 1 x Audio in, 1 x Audio out/Headphone, 1 x Microphone in

Connector Type: 4 pin USB Type A, 15 pin HD D-Sub (HD-15), Mini-phone 3.5 mm, Mini-phone stereo 3.5 mm, RJ-45

Audio Output

Audio output form factor: Integrated

Audio output type : Sound card

Cache Memory

Cache: 512 KB L2 cache

Cache per processor size: 512 KB

Miscellaneous:

Compliant standards: ACPI, EPA Energy Star

...read more.

Conclusion

Justification of chosen solution

For my RDBMS (Relational Database Management System) I have chosen to use Microsoft access this is because it is very efficient and easy to use also lots of other companies use this application so in a scenario where a table from the database needs transport to another computer, that computer is more likely to have Microsoft access on it other than e.g. paradox or oracle. The computers in the company Games 4 You will have them all networked so that if any data is added, changed or deleted all database tables will have the same affect and the changes will be seen on all computers this is very efficient as well because if the computers where not networked information that is added, needs updating or deleted will be have to done on every computer in the company separately and there will be times where some computers aren’t up to date so it will be inconsistent.

...read more.

This student written piece of work is one of many that can be found in our GCSE Forces and Motion 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
  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work