Alternative Solutions
An alternative solution to database is word processor or spreadsheet. Tables could be created to store the details of students. The logo could be placed on the document too. Searches could be performed and the document could also be password protected. However, mistakes can be made since there are no validation rules.
Database is ideal to make the registers on for many reasons. Firstly, validation checks like presence checks, length checks and character type checks limit the users’ mistakes. Queries can be made to search for data meeting a certain criteria. Forms and reports can be prepared almost instantly. Files can be linked together so that if one file is updated the other files dependant on that file will also automatically be updated. The addition, deletion and editing of data is simple. The database can be password protected to allow certain people to access the database tables.
Why ICT is a sensible way of solving this problem
ICT is a sensible way of solving this problem for many reasons.
Instead of a computerised filing system, filing cabinets would have to be used. This wastes space and delays time since searching can take time. Duplicates of
Mistakes on a hand written system are likely and the system would have to be rewritten, which will waste time or correction fluid will be have to used making the system look messy and unprofessional. This is not a problem on a computerised system, since things can simply be deleted. A computerised system would save time, would look far more presentable than a paper based one and be more accurate. Saving a computerised system is fast and easy. However, a paper based system would need to be filed away safely. Changes would be easier on a computerised system instead of using correction fluid on the paper based one. Illegible handwriting would be hard to read and could create errors and confusion.
Quantitative Objectives
My objectives of this task are the following.
- To create a database, which stores student’s details
- To create a database, which also acts as an attendance record.
- To make the database password protected
- To enable the user to create reports
- To enable the user to run forms
- To enable the user to create queries
- To link tables so that if changes are made in one table, the changes are clear in the other too.
- To make the system easy to read and clear
- To save the database on the appropriate backing storage.
- To include the tuition logo in the system
- Searching on the system should be easy
- To make the forms include buttons linking from one record to another.
Analysis
Input
I will create data capture forms to require the following information:
- Student’s first name
- Student’s last name
- Student’s address
- Student’s postcode
- Student’s home telephone number
- Student’s mobile number
- Student’s email address
- Student’s predicted results
- Student’s current results
- Teacher’s first name
- Teacher’s surname
- Teacher’s telephone number
- Teacher’s email address
- Teacher’s subject
These forms will be handed to all the students enrolled for the tuition and the teachers too. Once completed, the information will be typed in the database using a keyboard. To save memory, codes will be used when entering the data into the database to shorten long words. For example ‘Rd’ will be used instead of Road and ‘St’ instead of Street. The information will be verified by the person who typed in these details by checking the data entered against the forms.
Process
The database would validate the information by using range, format and presence checks. These checks would make sure that the right type of information is entered, that it is in the right format and that it is even entered. However, it will not check the accuracy of the data and this can only be done by proof reading the data entered against the forms. The computer will process the information in design view by changing it to the database view. It will also set up relationships between the tables, create forms, queries and also create reports.
Output
The output of the database would be viewing the tables, forms, query results and reports on the monitor. Also, the student reports will be printed off and read as a hard copy. These will be printed on A4 white paper in landscape view. After printing off the student’s reports and creating the database, I will create another data capture form to highlight any mistakes I have made or any improvements I could make to the database. This form would be sent to the management and teachers as a means of feedback.
Backup
The user of the database should save the database as soon changes are made to avoid the loss of data. The database would need to be saved on the hard disk of the computer. Apart from saving on internal memory, it should be saved on external memory like USB memory stick and CD-RW’s. USB memory sticks come with a range of memories like 512MB or 1GB. I would recommend for the user to make use of the 1 GB memory stick since there is more memory on it and therefore more data can be saved on it. A CD-RW is preferable to use because it can save 700MB of data and this data can be deleted and changed unlike a CD-R. The USB memory stick and CD-RW should be kept safely and away from the original system. As soon updates are available, the database should be saved on both the internal and the external memory. The updated database should also be emailed to the company’s email address as soon as possible as a means of backup.
Security
The users should be asked for their usernames and passwords when accessing the computers. These passwords and usernames should be changed after every three months to avoid hackers. The database should be password protected too. Hard copies of reports on students should be kept in a locked filing cabinet away from the computers. The rooms with the computers and filing cabinet should have a security and fire alarm in it. The doors should be kept locked when there is no teacher present there. The hardware should have security labels on them in case of a theft. An antivirus software should be installed in the computer to prevent viruses from entering the computer system. A network monitoring system should be installed to protect the network.
Software
To create and use the database, the following software will be required:
- Microsoft Access
Access is the preferred software over other types of software because of its capability to create complex searches called queries, produce reports, and convenient data entry forms. The database created on Access can also be made relational to link files together and further improve it. Mistakes are limited because of the many and useful validation checks like presence checks, length checks and character type or format checks. The database can also be made password protected to ensure its security.
- Symantec Norton Antivirus Software and Firewall 2007
This software helps prevent viruses which can corrupt data from coming on to the computer system.
- The Multi Router Traffic Grapher
This software monitors the traffic load on network links
Hardware
To create and use the database, the following hardware will be required:
3 Packard Bell Istart 1360 desktop PC - AMD Athlon 64 3200+ processor (with Microsoft Windows XP Home Edition, 512MB DDR RAM, 80GB hard disk drive)
3 17” Sony Flat Panel Monitor
3 keyboards
3 mice
Inkjet printer
Hub
Cables
A large memory of the computer is needed to save the database. Three computers will be needed for both teachers and receptionist or network manager and will be networked together. To network the computers, a hub and cables are needed. Since all the computers will be networked, only one printer is needed. This printer should be an inkjet one because it produces decent quality printouts at a reasonable price.
Flow Chart
No
Yes
Yes
No
Design
Subtasks
Below is a list of subtasks together with the estimated duration and start dates.
The database should have 3 tables. One table should store the student’s details. The other, the teacher’s details and the last should act as an attendance record.
This is the design for the Student Details table.
The field length of a field is valuable since it is a waste of memory even if not used. Validation helps to ensure fewer mistakes are made in the database.
Below is the design of the Teacher Details table.
The field length of a field is valuable since it is a waste of memory even if not used. Validation helps to ensure fewer mistakes are made in the database. Dropdown menus save the user time for typing data over again. It also ensures fewer mistakes are made.
This is the design of the Attendance Record (Term 1).
The field type ‘Yes/No’ creates a tick box, where the teacher can tick the box to indicate the pupil is present in class and can leave it blank if absent.
Student Details Form:
Teacher Details Form:
Student Details Report:
Teacher Details Report:
Relationship Diagram:
User Comments
This is what Mr. Amir Khan thought of the initial design of the database.
The changes made to the initial design were made in green pen to make it the final design.
Test Plan
A test plan was designed. Once the database is created, these tests need to be carried out to ensure the database works correctly.
Implementation
Evidence of Error Correction
The screenshot below is of the ‘Student Details” form. The error I found on it was that the text boxes were too small to fit the text into. For this reason, I made all the text boxes larger so that the text would be able to fit into them.
This screenshot shows the Teacher Details form. The same mistakes were found on it. The text boxes were all too small for text to be read in.
This screenshot shows the layout of the Student Details form after I made the changes to it. I made all the text boxes larger so that the data can fit within it. The name box was made extra large so that long, foreign names will also be able to fit within it.
I also corrected the Teacher Details form because it had the same mistakes.
Test Plan
Evidence of Problem Solutions
This screenshot shows the Student Details Report.
This screenshot shows the Teacher Details form.
The user found that there was no ‘Exit Form’ control button and thought this was necessary. Below is a screenshot of the Student Details form including this ‘Exit Form’ control button.
Evaluation
The objectives set for this task were:
- To create a database, which stores student’s details
- To create a database, which also acts as an attendance record.
- To make the database password protected
- To enable the user to create reports
- To enable the user to create forms
- To enable the user to create queries
- To link tables so that if changes are made in one table, the changes are clear in the other too.
- To make the system easy to read and clear
- To save the database on the appropriate backing storage.
- To include the tuition logo in the system
- Searching on the system should be easy
- To make the forms include buttons linking from one record to another.
I was able to achieve the first two objectives which were to create the database to store student details and act as an attendance record or register. The database was password protected, as shown above. The user could easily make reports, forms and run queries. I have also made and given examples of each. I had linked tables by making relationships so that when a change was made on one table, the change would be apparent on the other too. This was shown above. The system was easy to read and clear, in my opinion. The database was saved on the user’s email account, USB device, CD-RW and internal memory too. Computers in the tuition centre are all connected via a hub and router. This way if one computer fails, the other computers and other external memory still hold the database system. The tuition logo was put on the forms and reports presentably. Searching can be easy through running queries. Lastly, the forms did include buttons so that the records linked to one another.
User Comments:
I then created a control button which would link the forms to queries. Evidence of this is shown below.