Project 1b; Film Database
Introduction This project will be about creating a database for a fictional video shop. I will have the aim to help the staff of this business by creating a database of videos/DVD's using current information from local Video stores, leaflets, newspapers and the internet. The database will help me to find out current information on which video or DVD has which features. The database will function as the basis of finding Videos and DVDs that are currently available in the store. Such a database is much more convenient, than one that is based on paper, since it is much quicker and is less susceptible to human error than a database that is based on paper. If the staff of the video shop did not have a database, severe problems would occur as the staff does not know which films are currently in stock and it is very likely that the needs of customers are not satisfied in time. E.g. a customer requests a movie for her son, but because the staff has not got the information where the video is and which videos are suitable it takes the member of staff about five minutes which results in the customer leaving without purchasing a movie. The following questions could have been asked by a member of staff or a customer that need to be answered by using the database: * Which films are in stock that are not more than three years old? * What action movies are there for my 12-year-old-son? *
The database is created due to need for a programme which could monitor a local youth club, which is responsible for arranging and organising music concerts for bands.
Task 1-User Requirements The database is created due to need for a programme which could monitor a local youth club, which is responsible for arranging and organising music concerts for bands. One of numerous objectives is to be able to store information this is its most basic function. Instead of relying on traditional methods of storing information in physical file folders and cabinets, a database provides digital storage of information as regards to potential bands. Furthermore an additional aspect which is considered vital is information concerning fans that have previously been present at concerts. A key aspect of the database which is essential to the potential success is the functionality, subsequently to search and store data would become effortless with a high-quality database. A database provides easy access to information. Because the information is centralized, the user has no need to look to other applications. All is provided through a singular database, and the information in the database can be used in publications with customer consent and querying a database should produce a quick result. When compared to locating the information manually, users find it a quicker way to gather desired information. Another reasoning behind this method is big advances in database technology allows multiple users to access and update information. This information will then be
Application Packages
Application Packages An application program or package (group of programs) enables the computer to tackle a specific task, such as writing a letter. Word Processing - for writing letters, reports and other documents. Examples: Microsoft Word, Word Perfect, FlexiWrite. Facilities include: easy editing of text, font & size changing, find & replace, spell checker, word count, mail merge (to import text from a database while printing each copy of a document). Data Handling - for creating databases. Examples: Microsoft Access, FlexiData. Facilities include: creation & editing of fields, sorting records and query searching, also ability to display data in graphical and chart form. Graphics Package - for drawing and painting. Examples: Microsoft Paintbrush, Corel PhotoPaint, Paintshop Pro. Facilities include: colour palette, various drawing, painting and editing tools. Desk-Top Publishing (DTP) - for producing posters, leaflets and newspapers. Examples: Microsoft Publisher, Adobe PageMaker. Facilities include: ability to import text and images from other programs or from disk plus ability to position them individually on the page. Usually have some text editing tools included. Spreadsheet Modelling - for producing invoices and cost plans. Can be used to create models, simulations or expert systems for others to use. Examples: Microsoft Excel, Lotus 1-2-3. Facilities include:
Testing database. Test plan 1 I am going to check my data restriction. To do so I am going to add a invalid data in the field price, whish is set in currency data type.
Testing Test plan 1 I am going to check my data restriction. To do so I am going to add a invalid data in the field price, whish is set in currency data type. The expected result that I am hoping for is that the system would prompt out a warning message. Testing 1 in this screen shot above I have opened my external product table where in price I have added a data restriction in price field. I have selected the field where I am going to add an ivalid data type In the screen shot I have change the data type. As soon as I did this the system prompted out that I have inserted an invalid data. This means I have got my resulted result thus meaning that my system works Test plan 2 I am going to check my data restriction. To do so I am going to add a invalid data in the field Delivery date, whish is set in Date data type. The expected result that I am hoping for is that the system would prompt out a warning message. Testing 2 in this screen shot above I have opened my external product table where in price I have added a data restriction in price field. I have selected the field where I am going to add an ivalid data type In the screen shot I have change the data type. As soon as I did this the system prompted out that I have inserted an invalid data. This means I have got my resulted result thus meaning that my system works Test plan 3 I will be testing on my drop
ICT BTEC UNIT 2 - REPORT
I have been assigned the task of an ICT support section of an up and coming web Development Company that dedicates itself to the incorporation of high-resolution graphics and video on web pages. Nevertheless their designs and solutions are restricted by the lack of decent hardware and software which is quickly becoming outdated in such a fast changing industry. They have reached out to me to resolve their predicament by asking me to put together a written report by researching the following * Computer system * Operating system * Video editing software * Web design software By doing this I have to build and appropriate system which is able to construct more complex websites. OPERATING SYSTEM In the table inserted in the next page is a list of 4 types of operating systems including windows vista premium, window XP professional, Linux and windows vista ultimate. In these next paragraphs before the table I will be comparing the four in slightly less detail than the table and give definitions on what each of the components are and what their functions are. So for the hardware side if things the four OS (operating systems) requirements vary quite a lot as the CPU (central processing unit) on vista premium, which is at 1 GHz, (Gigahertz) is a lot more then that of XP professional which is at 300 MHz (Megahertz). The CPU speed is how fast the computer will operate so if
Technical Documentation.
Technical Documentation The spreadsheet that I have designed and produced was made to allow the user to enter new customers details in, and also new stock items as well. It allows the user to enter and process orders that the company receives from customers, and these orders are processed by using an invoice and a transaction file. Initially the invoice is the form where the order is submitted. This is then confirmed and printed off to give to the customer, whilst the order information is transferred and then saved in the sales transaction file. The spreadsheet I have produced is designed to do all of the above as efficiently as possible. Hardware For this spreadsheet to run to its designed capacity, the following items of hardware are required: * A monitor * A keyboard * A mouse * A PC (anything above a specification of 56mb and 128 bit processor will be sufficient, and it must have a CD-Rom drive installed) Software For this spreadsheet to run accordingly, the following item of software will be required: * Microsoft Office 2000, which includes a spreadsheet programme called Microsoft Excel 2000 * Windows 2000 or Windows XP Installing and Configuring the Spreadsheet * Insert the World of Trainers spreadsheet programme CD into the CD Rom drive * Open the CD by opening 'My Documents' and scrolling down to the correct CD-Rom drive location * Copy the file named
Designing a leaflet to advertise an electronics shop.
Haseeb Ali Choudary ICT DTP Coursework Candidate number: 3038 Center number: 11043 IDENTIFICATION Organisation: The name of my organisation is H A C electronics, it is a shop is located in south London, it has been running for 10 years now, it is an electrical repair shop. It repairs electric equipments such as phones, computers, laptops, cameras, DVD player, CD player and many more gadgets. This shop has 6 members of staff. The shop is not that popular, as other shops in that area. Mr Smart will be using my system, he is the manager, he is not that advanced in ICT, but he knows the basics. Problem background: The problem is that the shop is not making enough money and may close down, it does not have as many customers as the other electronic shop, down the road, after a thorough investigation, I have realised that is that the company is to blame for their own downfall, first and foremost they do not have any form of advertisements. Secondly the shops posters in the window are too small, and are hand drawn. Lastly the company are employing one too many workers. Alternative solutions: This company can use Microsoft publisher, to update the shop poster, it can let go of one of its employees. The company can also use publisher to make the leaflets, to hand out. This will make the company look much more professional. H A C electronics can also put more effort in with
computerised spreadsheet for pupil attendance data
Coursework A Teacher's Class Attendance Register And Mark Book Spreadsheet Project Plan GCSE Information, Communication and Technology 2005 NAME OF STUDENT TABLE OF CONTENTS Identify Analysis Design Implementation Evaluation IDENTIFY My friend's class teacher named Dave has to take a register every day and has to keep marks that students have achieved on a regular basis. Dave finds it very hard to keep all his papers organised, as they tend to overflow and get messy. Because of this it can be an agonising process trying to find a students set of results or attendance marks when they are needed. He recently received a new computer from his Dad as a present. My friends wants me to create a computerised spreadsheet for him whereby he could keep attendance of pupils and their grades and also create graphs out of the information to simplify it. The more primitive way to solve this problem would be to create a more organised and effective manual system, like a folder with various sections in it to identify different pupils and grades that they have. However it is not the ideal way of solving this certain problem as it may prove to be just like his previous method. Another way by which the problem could be solved would be to create a spreadsheet system. The types of software packages I am
GUIDELINES TO INSTALL JOOMLA AND XAMPP ON YOUR PC
GUIDELINES TO INSTALL JOOMLA AND XAMPP ON YOUR PC ) Download joomla installer (http://www.joomla.org/download.html) and xampp installer (http://www.apachefriends.org/en/xampp-windows.html) from internet. 2) Install xampp by double click at the xampp installer 3) Choose English as your language. Click OK button. Illustration 1 4) Click Next button on the Illustration 2 Illustration 2 5) Leave the Destination Folder as default setting. Do not change the path (you may change it to any partition if you want). Click Next button on the Illustration 3 Illustration 3 6) The installer will install xampp. Illustration 4 7) Once it finished, click at Finish button Illustration 5 8) Click Yes and Finish button. See the illustration 6 Illustration 6 9) The illustration 7 will appear. Click the Start button on the module Apache and followed by the module MySql Illustration 7 0) Now, we are going to create a database in Mysql. Click at your browser. Here I'm using Internet Explorer. Illustration 8 1) Go to the URL Address and type http://localhost , then press Enter Illustration 9 2) The next illustration will appear. Click at English hyperlink Illustration 10 3) Illustration 11 will appear and click the phpMyAdmin on the left menu (under Tools menu) Illustration 11 4) The next illustration will appear. There is a field to be filled in under My SQL localhost. Key in
Documentation of a database for a sports centre.
Documentation of database Introduction The report is presented to Anna Thomas ("Get Active" Manager). There are many problems that have been stated in the letter from the sports centre. The first problem is the fact that the sports centre has difficulties managing all of the member's details. As there are a lot of members it is difficult to find the information based on the member quickly. It is also difficult to find groups of members and they need to change and check the age of the members (18 and over is an adult). Another problem is that when a member arrives the sports centre need to find and make the membership valid as they are "on site .The best piece of software to use to solve these problems are databases, in this case Microsoft Access. * Validation aims to make sure that data is sensible, reasonable and allowable. It does not check that it is correct. * A Key Field or Primary Key is a field within a database which enables every record to be uniquely identified. * Verification is used to verify that data has been entered into the computer matches the original source data. It does not check that the data is accurate. One way of verification is typing data into the computer twice. The computer automatically compares the two versions and tells the user if they're not the same. When network users change their password, they have to type in the new password twice