Computer database
Specification
Design
Data flow diagrams
In a data flow diagram, basically it shows how the system moves around. It doesn’t just show you that it also shows you what will happen at each stage and in order it shall happen.
In a data flow diagram you have all different shapes involved they all represent different things for different reasons.
The terminator shape shows a process for e.g. queries
The rectangle were about the data has come from e.g. customer data file.
Last of all the last shape that is included in the data flow diagram is the square shape this represents were the data is stored, we have to have the shapes representing different things because then the data flow diagram wouldn’t mean anything more than what the letters say in the shape.
All data flow diagrams are in order in which they happen, that’s so when people read them they are very clear in what order they are meant to do it.
The only thing the data flow diagrams don’t show are what hardware and software are needed to make what ever you need done.
Top down diagrams
System flow charts
Software resources.
Cost loads less will need to have different things to do with computers to keep the company going these include things like new monitors and some new hardware disks to install.
Hardware resources
In costloadsless business I recommend
That they get a computer that is not too much money, because it will only be used for database purpose. But the computer does need a high memory as the amount of customer’s data being stored is unpredictable. I recommend that it comes in XP edition, it mostly comes on most computers and it is a reasonable to buy, this operating system is new and very much improved, it has a high speed, it is more convenient to use.
-
This computer is £269.99,
-
80 GB Hard Disk Drive. 256MB DDR RAM. Intel Celeron D 351 Processor, 15" TFT Monitor, This computer is a good buy it is including everything but a printer. You have not got to buy it separately and pay more. It includes soundcard. The Operating-System is widows XP that is an updated operating-system it is the most updated system. It has 1 P.C shot number of USB connections is 6.
This computer is only 349.99 and it has, Intel Celeron 356 Processor, 3.33GHz, 533MHz FSB, Microsoft Windows XP Home Edition, 512MB DDR RAM, 80GB Hard Disk Drive, Multi-Format Dual Layer DVD RW Drive, Multi-Format Dual Layer DVD RW Drive, Integrated Graphics, 6 USB Connections, this would be very useful just in case, 1 PCI Slot, 15" TFT Flat Panel Monitor.
I think that the first computer is better because it is cheaper and it is has the same amount of Hard Disk Drive, this is important as costloadsless are on a budget. I think that this computer is more important but in this case we are getting what we pay for, this computer.
The computer I have chosen is the first choice because it has exactly the same memory as my second choice but the second computer is more money, they both have 6 USB Connections. The one thing that costloadsless are looking for is quite a lot of memory, cheap price for the computer. The first choice is exactly that. The second computer has the same memory and same amount of USB connections.
Printers
This printer is 34.99, it also prints 11 pages in black at once and 11 pages in colour, this is really good if you are short for time this saves you printing all your data you need separately. It also allows you to have 100 sheets of paper capacity this would be helpful so you aren’t always applying paper this would save you time. Borderless photo printing, ChromaLife 100 for long lasting prints.
This printer is only 17.99. Whilst looking through the P.C world website I was looking more for price than anything else, on the more information icon I pressed there was no information this shows this was just a basic printer, I am getting what I pay for and this printer I actually found out this is not a good deal at all. The business could buy it and notice that it isn’t what they want and therefore they are wasting money they cannot afford to do! It doesn’t tell us how many sheets’ you can place inside, and how many sheets I can print out at once.
The printer I am going to buy for the business is the first printer, it is more expensive but I am aware what I am paying for and I know I am not wasting my money. It prints 11 pages and I may fit in 100 pieces of paper in the tray.
Software Resources
I will firstly decide what software ‘costloadsless’ will need
-
Anti virus software → So the Computer doesn’t get a virus and lose all the customers data.
-
Access to the database → So the staff can access all the database encase there is a problem
-
Operating system → This may automatically come on the bought computer it is needed because it is updated and it is used more
I will now analyse two different software packages for ‘costloadsless’ to use for their computer. It is important I choice the right one it might be a little more expensive but the more money we spend on the right one it will be more active and better, if you spend little money it might not be that good and a virus may come on it and then delete all the data on the customers.
Microsoft office
-
This Microsoft office is $428.00.Office 2003 Professional includes the following components Word 2003 Excel 2003 Outlook 2003 PowerPoint 2003 Access 2003 Publisher 2003 Outlook 2003 with Business Contact Manager. Using access 2003 they can run the database.
You could use access for the database and word for reports.
-
The product star office 8 is $79.00 this product is a good upgrade from Sun Microsystems. Sun Microsystems Star office 8 is a solid productivity suite that costs a fraction of the price of its main competitor, . Star Office includes the Writer word processor, the Calc spreadsheet maker, the Draw graphics tool, the Base database, and the Impress slide-show application. Like its free and open-source relation Open Office 2, Star Office 8 has plenty of enhancements: new mail-merge and database wizards, better import and export filters for Microsoft Office files, and an Adobe PDF-export tool that now supports hyperlinks, tables of contents, and other essentials. You'll also see a revamped interface, particularly in the Impress presentation program. What's missing? Star Office 8 lacks a contacts manager, an e-mail program, and a photo editor, all of which provides. And while Star Office runs on a variety of operating systems, including Linux, Solaris, and Windows, it eschews Macintosh surprising, given the suite's cross-platform philosophy. But the package price of $100 on or $70 via download makes Star Office 8 a good buy for both different
I have looked at the two different products and I have come to the conclusion of having Microsoft office because it is extremely easy to use it is straightforward I know it is trustworthy because all offices, businesses, and schools use this software. This software is well known and has had no complaints I would rather spend more money than on one and a little on another and not no anything about it, For such a big company like ‘costloadsless’ they should only have the best because they are dealing with a lot of data with all different customers.
A.V.G
This anti virus software is a free download I found using the goggle search engine, you simply press DOWNLOAD NOW! And it will download into your files you run this programme everyday it is up to you to remember or viruses may appear onto your computer, then this could affect your files and data. This programme whilst could pick up a virus and then fail to fully download therefore this again could affect your files. This is not a professional addition this would not compare to a professional addition and it would defiantly not do the same things as the shops one, You just will get a basic programme this addition can defiantly not promise it will check all the computer because it is only a free download and so it might not have the ability to do so.
This anti virus software, is available on the internet by just entering the website www.avast.com the price of this software is £19.99 it has a year subscription and a guarantee.
This is very trust worthy I know this because it has an advertisement of ‘AVAST Antivirus v4.7 is based on the comprehensive ALWIL software since 1988 featuring fast technology incremental updates and advanced multi-layer real-time protection of all infection vectors, it safeguards against virtually all kinds of malware’ This tells me basically that it is a trustworthy and it encourages me to buy it.
My conclusion
I have come to the conclusion of buying the second anti virus software, because it tells me a lot more than the second choice on what it can perform on the ‘costloadless’ computer my second choice doesn’t. It is a lot more professional and is more used in business than Avast.
Operating system
In the computer at ‘costloadsless’ we will need an operating system because it is essential the computer will not work without one. We just need to make sure that we get the right one that will perform to our standards therefore we will not be buying a cheap one it will have to be the best because if the operating system is rubbish then the computer wont be very good and again we are keeping extremely important data/information on this computer and so it will not be a cheap package but it is something that we will have to put aside it is an essential.
Could you please fill this form in, in CAPITAL LETTERS black or blue pen.
Date __/__/__
Name: _________
Surname:___________________
D.O.B __/__/__
12.06.1991
Street name_____________________________________________
County__________________________
Post code________________
E.g. DY3 3bh
Telephone number ______________________________________
E-mail address _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
If your e-mail address is longer than the spaces provided please fill in the box below thank you.
Film…………………………………………………………………………………………
- Please tick the correct box
Romance comedy non-fiction fiction sci-fi action
Other (capital letters please)
Specification
For this ‘costloadsless’ project, there are a lot of documents that I will have to test just incase they don’t work, I will loose all documents if they are not tested. These are the e.g. of my testing these do show weather the process went right or wrong and what I would do if they did go wrong to make sure for the real database that everything goes right as this would be extremely important.
Picture 1.
This is a copy of my application form; a customer shall fill in this for a back up copy and customer shall fill this in when he/she applies to the store just so the store has there information, they can just simply copy the information onto the store computers.
Testing 2
In my document, I have made a form to put customer information this will just put the customers information in and this is an opportunity to check for spelling mistakes, and it will secure the data in the computer, this is used so a ‘costloadsless’ worker can just easily call up a customer, and see his/her data. It is very important that all data is correct just incase a letter has to be sent home.
Testing 3.