The United Kingdom awarding body Essay Example for Free

The United Kingdom awarding body EssayI excite been asked to design a trunk for the United Kingdom Awarding Body (UKAB), an imaginary exam board. This system is going to be use for the monitoring of its post-examination re-marks. System Specification The system specification deprivations to store the hobby selective in progress toation Candidate give Candidate physique bone marrow bend Subject write Code legitimate mark Re-mark mark Whether the totality requested the return of the script It was also necessary to store the grade boundaries for apiece of the subjects. For the system I was asked to build the sideline table was provided for the grade boundaries of distrisolelyively subjectSubject Reference ground level Boundaries (%) Code A B C D E 01325 75 67 60 54 48 20094 70 60 50 40 30 28181 90 78 66 54 42 54821 85 79 74 64 55 64773 68 60 52 46 40 The system mandatory to be able to produce hard copies of the following A daily distinguish of any re-marks completed whe re a mark permute has affected the grade A daily list of any re-marks belt up outstanding, i. e. that bind not been completed within a three-week period A list of re-marks that have been requested for a particular subject A list of re-marks that have been requested from a particular centre.The system also needed to be able to produce documents which could be returned to the centre giving the results of the re-marking. The document needed to head the UKAB logo and also the following details totality repress (integer) Candidate name (string) Candidate number (integer) Subject Reference Code (integer) pilot Mark (integer) overlord horizontal surface ( text edition) Either the re-mark mark and grade, if changed, or a sentence to say that there has been no change (integer/text) Processes The user of the system would need to be able to carry out the following processes Record information about aspects.Amend/delete information about aspects Record re-marks Query so as to ob tain the information for the hard copies which I listed above. Firstly I needed to use the information requirements to start to design the entities and attri neverthelesses that I would use in the system. Following is a brainstorm of the ideas I used to come to the beginning(a) draft of the entities and attributes Initial Entities After this brainstorming I decided to start with the following 3 entities Candidate(Candidate Name, Candidate Number, Centre Number, Subject Reference Code, Original Mark, Re-mark mark, Requested) Subject (Subject Reference Code, A, B, C, D, E).Centre (Centre Number, Centre Name, Centre Address) Where the underlined attributes represent the primitive keys within from each one entity. In the panorama entity I decided to use both digestdidate number and also centre number as a joint freshman key as candidate numbers were scarce unique to their centre. This would mean that there could be multiple candidates with the same candidate number however the candidate number and centre number combined would always be unique. For the subject entity, subject name and address tag was the only sensible basichand key as it was the only unique attribute in the entity.Centre Number is both a primary key in the centre entity and also a impertinent key in the candidate entity. Another foreign key in this initial model is subject reference law in the candidate entity. selective information Types Candidate Name text 20 Candidate Number integer Centre Number long integer Subject Name text 15 Subject Reference Code long integer Original Mark integer Original Grade text 1 Re-mark Mark integer Re-mark Grade text 1 A integer B integer C integer D integer E integer Centre Name text 20 Centre Address 200 For each of the field I altered the length of each field appropriately.I did this by either substitution from long integer to integer, or changing the maximum number of characters in each field. In this way I was able to save on the office that t he database used. Following is the reasons for choosing the data types for some of the fields I used in the database Candidate Name I limited the field length to 20 characters as this would be long enough to cater for any name but yet saves space as less space has to be set deflexion for each record. Candidate Number as candidate number is only 4 digits long there would be no way in which it would occur the maximum length an integer would provide.Therefore I chose to decrease the field length to integer so as to save space. Centre Number I was not able to decrease the size of this field as Centre Number is a 5 digit number and therefore can give-up the ghost the maximum length of an integer of 32768. Subject Reference Code this field again used long integer as its data type payable to it being a 5 digit code. To ensure that the field could start with a 0 I altered the properties of the field as below Original Grade I decreased the length of this field to 1. The grade would alway s only be a 1 garner grade such as, A or B.Therefore I was able to decrease the length of this field to 1 at no consequence. Re-mark Mark I changed this to integer as it was only a 2 digit number. Centre Address I changed this to 200 characters as an address can be quite long. However I did not change the data type to memo which would have provided more space as it would make the system slower and the extra space would not have been needed First Normal model I realized that having the candidates and also the re-marks in the same table, that I would be unnecessarily duplicating data within the system.I therefore decided to fragment the entity up into two separate entities, candidate and re-mark. So my new entity list looked as below Candidate (Candidate Name, Candidate Number, Centre Number) Re-mark (Subject Name, Subject Reference Code, Candidate Number, Centre Number, Original Mark, Original Grade, Re-mark mark, Re-mark Grade, Requested) Subject (Subject Reference Code, A, B, C, D, E) Centre (Centre Number, Centre Name, Centre Address) The new entity remark has a abstruse primary key consisting of, subject reference code, candidate number, and centre number.This was the only combination of attributes within this entity which would ensure that it was always unique. Also in this way I was able to ensure that all of my tables were in eldest normal form, satisfying the criteria of eliminating duplicative fields within the same table. By making the re-mark table a sub-form of candidate through the use of a one to umpteen relationship between the two, I was able to have multiple re-marks for each candidate without having to break the first normal form which I need to adhere to. Second Normal FormFor a table to fulfill the requirements to be in second normal form, all of the non-key attributes within the entity must be functionally dependant upon the primary key of the table. All of my entities satisfied these criteria so therefore no changes needed to be mad e. Third Normal Form For a table to fulfill the requirements to be in third normal form, it must first be in first and also second normal form. On top of the requirements for the first two forms, it must also be ensured that no non-key attributes are dependant upon other non-key attributes.My database already satisfies this requirement and can therefore be said to be in third normal form. As my database fulfills all of the requirements to be in first, second and third normal form my database has now been normalized. Relationships After designing the entities my table will use while considering the normalization of my tables I have now come up with the following relationships Above is a screenshot of my relationships that I have nominated in access.As can be noted there are no many to many relationships as I have eliminated them through the normalization process. Software For this project I am going to be using Microsoft Access, as well as some coding within ocular Basic which I wi ll implement into the database. I have chosen to use the following combination as it is an easy way to set up tables and the initial database, but also allows me to utilize the power of a programming language such as Visual Basic so I can fine tune and customize the user interface and other aspects of the database.I have chosen to use a package to create the initial database as opposed to programming the whole database as programming the whole database from the start is a larger task which I would not have been able to accomplish with my current understanding of programming. Also for this particular project the extra power that a programmed database could offer was not needed as the resolve could be provided in a fairly simplistic form. My other briny option for creating this database was to use Delphi, which is a form of Pascal.I have already covered most of the Pascal syntax and it would have been the best alternative choice, however I did not do this for the reasons above. On to p of this I wanted to expand my knowledge of systems creation by experimenting with Visual Basic and also Access. nastyware The ironware which I will be initially creating my solution on is my home PC. This PC was built by me and therefore I am very familiar with the hardware that I will be using. The hardware is of a medium to high specification AMD Athlon XP 1800+ (clocked at 1533 MHz) 512 MB DDR PC2100 RAM.40 GB Hard drive However I wanted to ensure that the computer software that I was creating would work on a PC of lower specification so that anyone that was using it would not be forced to upgrade their systems to use my database. I therefore did some testing on the PCs at my College which were of a lower specification Intel Pentium III 800 MHz 128 MB SD RAM 10 GB Hard drive Design Tables Following are screen shots of the tables in my database Candidate Design View As can be seen in the properties of the candidate name attribute, I have changed the field size to 20.Also it c an be seen that the primary key is a composite one made up of candidate number and centre number. Candidate Table View Centre Design View In the above view, the focus is on the centre number attribute, as can be seen the field size is set to long integer, also for the format I have altered it to 00000. This represents the number of digits that I was to be shown at any time, this is a work around of the problem that if a centre number begins with a zero accordingly it will still be kept. The primary key for this entity is Centre Number. Centre Table View The test data included 3 centres.So as to show the full address of each centre I have had to increase the height of each record within the table. Re-mark Design View As can be seen for this table the primary key is a composite one comprising of subject reference code, candidate number and centre number. Re-mark Table View Here is all of the test data for my database, it may be noted that there are more than 15 re-marks (the correspo nding number of candidates). This is because I have given some candidates a number of re-marks so as to be able to test the effects of more than one re-mark per candidate.Subject Design ViewIn the subject table I have given the primary key to the only unique attribute within the entity which is subject reference code. Subject Table View As can be seen for each grade boundary I have just given the singular value as opposed to the actual bounds for each grade. This is so as to make coding for the user interface easier later on in the solution. Validation Rules In the specification there were a a couple of(prenominal) expressions by which some of the data needed to adhere to, these were 1. Candidate Numbers are of 4 digits and will be unique within any centre, but not between centres. The solution should ensure that this is allowed for.2. Centre numbers are allocated within the range 10000 to 80000 and are unique. 3. Subject Reference Codes are 5 numeric digits. The following are the validation rules that I used to ensure that my data was correct. 1. For the candidate numbers I used the following validation rule (0) And (10000). This allowed for the numbers from 0001 up to 9999. 2. For the centre numbers I used the following validation rule (9999) And (80001). This allowed for the numbers 10000 to 80000. 3. For the subject reference codes I used the following validation rule (0) And (100000). This allowed for any 5 digit code.Other validation codes that I used include 1. (=0) And (=100) for the original mark and re-mark mark attributes. This ensured that either mark was expressed out of 100. 2. (=A) Or (=B) Or (=C) Or (=D) Or (=E) Or (=U) for original grade and re-mark grade, this ensure that each was a valid grade. Queries The first query that I needed to create needed to show any outstanding re-marks. Outstanding was defined as 3 weeks after it was received. This led to me needing to change the design of the re-mark table slightly. I needed to add an attri bute (date received) so as to keep record of the date that it was received.After this the re-mark entity looked as follows Re-mark (Subject Name, Subject Reference Code, Candidate Number, Centre Number, Original Mark, Original Grade, Re-mark mark, Re-mark Grade, Requested, Date Received) Forms Main To make the design as user friendly as possible, I have split it into 2 sections of input and output. This way it is easy for the user to distinguish between the two uses of the system. For all of my forms I have included an consequence button in the bottom right of each form. I have kept this constant to stay in line with the element of least surprise design. advanced Centre Similarly to the new centre button, the new subject button opens at a new record. The screenshot is of the subject form. New Re-marks The new re-mark button unlike the first two buttons does not open at a new record. This is because it is more likely that the user will be inputting a user from an existing centre and therefore it would make more sense for the user to scroll through the centres. A small feature that I have included in this form is to improve the user interface of the system. It will input a code from a subject name or a subject name from a code automatically.I used the following code to achieve this effect. This code changes a subject name into code, it can be noted that this happens on exit of the subject_name field. For the opposite effect I used very similar code Above is a small clip of how this code works, it follows on similarly for each code. Again this code takes place on exit of the subject_reference_code field. Re-mark Results For this particular form I have locked many of the fields, this is because it will be used to input the re-mark results from antecedently submitted papers. The locked fields are coloured in grey.Another feature which is used in this table is an auto-grading system, where the system calculates the grade from the mark entered. This feature also tak es into love the different subjects as each has different grade boundaries. The code is as follows End Sub Where the grade boundaries are actually on the table but are hidden as shown Each of these fields contains the grade boundaries from the subject table. They change in accordance to the subject reference code which is also on the table. This feature is put in place to increase the efficiency of the system for the end user.It may also be noted that when the re_mark_mark field is exited the re_mark_date field becomes capable to todays date. The field was like the grade boundary fields hidden on the form. bailiwicks The following are the discovers which I included to provide hard copies for the end user. to a lower place I have listed the names of each of these reports and have also printed out examples of each report. Each example is clipped onto the end of this report the page number will be included next to the report name beneath Grade Changes (pg ) Outstanding Re-marks (p g ) Subject Report (pg ) Centre Report (pg ) Candidate Report (pg ).Each of these reports simply used the queries that I had already constructed. However the candidate report posed a small problem, the specification stated that it would like to show the grade change or if no grade change had been made, then it would like a sentence stating that there was no change. This meant that I would need to create two separate reports and then create some code which could go to the necessary report when I had inputted the details for the report. Test Purpose of test information Used or Action Taken Expected Result Actual Result 1 guarantee that main form loads pawl main form button Switchboard form displayed.Form opened 2 hinderance New Centre form Opens Click New Centre dismission New Centre form at new record Form opened 3 Check New Subject form Opens Click New Subject Button New Subject form at new record Form opened 4 Check New Re-marks form opens Click New Re-marks Button New Re-mark form at first record Form opened 5 Check grade changes report opens Click Grade Changes Button Grade changes report preview Preview opened 6 Check outstanding re-marks report opens Click outstanding re-marks button Outstanding re-marks report preview Preview opened 7 Check subject report opens Click subject report button Pop up boxwood then report preview.After entering criteria, opened 8 Check centre report opens Click centre report button Pop up box then report preview After entering criteria, opened 9 Check candidate report opens Click candidate report button 3 popup boxes then one of 2 reports After entering criteria, opened 10 Check exit button Click exit button Form closes Form closed 11 Check auto grade feature for original mark precede mark Equivalent grade is generated Grade generated 12 Check auto grade feature for re-mark mark Insert mark Equivalent grade is generated Grade generated 13 Check validation rule for candidate number Insert 5 digit code.Rejection of the code Rejected 14 Check validation rule for centre number Insert number larger than 80000 Rejection of the code Rejected 15 Check Validation for subject reference code Insert 6 digit code Rejection of the code Rejected 16 Check validation for original mark Insert number larger than 100 Rejection of the number Rejected 17 Check validation code for re-mark mark Insert number larger than 100 Rejection of the number Rejected 18 Check validation code for original grade Insert the letter G Rejection of the letter Rejected 19 Check validation code for re-mark grade Insert the letter H Rejection of the letter.Rejected 20 Check auto subject reference code feature Insert word business Generation of the code 20094 Generated 21 Check auto subject name feature Insert code 01325 Generation of word Art Generated 22 political machine date feature Enter date field Generation of todays date Generated 23 Check that Auto grade feature works for alterations Change an existing mark Regeneration of grade to n ew grade Generated 24 Check validation of dates Insert rudiment into date received Rejection of date Rejected 25 Check that Duplicate Centre Numbers cannot be inputted Insert 66528 in new record Rejection of data Rejected.