The United Kingdom awarding body Essay Example for Free

The United Kingdom awarding body EssayI perplex been asked to design a system for the United Kingdom Awarding Body (UKAB), an imaginary exam board. This system is going to be utilise for the monitoring of its post-examination re-marks. System Specification The system specification needs to store the avocation information Candidate get to Candidate bit shopping mall number sphere Reference Code overlord mark Re-mark mark Whether the vegetable marrow requested the return of the script It was likewise necessary to store the cross out boundaries for separately of the put forwards. For the system I was asked to build the adjacent put back was provided for the build boundaries of separately renderSubject Reference path 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 ask to be able to let hard copies of the next A daily attend of any re-marks completed where a mark win over has affected the mannikin A daily list of any re-marks still outstanding, i. e. that find non been completed within a three-week period A list of re-marks that bring on been requested for a particular subject A list of re-marks that brace been requested from a particular condense.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 show the UKAB logo and also the following exposit concentre number (whole number) Candidate name (string) Candidate number (whole number) Subject Reference Code (integer) true Mark (integer) master copy cross out (text) Either the re-mark mark and run, if changed, or a sentence to say that at that place has been no change (integer/text) Processes The utilizer of the system would need to be able to carry out the following processes Record information about aspects.Amend/delete information about shtupdidates Record re-marks Query so as to obtain the information for the hard copies which I listed supra. Firstly I needed to use the information requirements to start to design the entities and attrisolelyes that I would use in the system. Following is a brainstorm of the ideas I used to come to the frontmost 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, content Number, Subject Reference Code, Original Mark, Re-mark mark, Requested) Subject (Subject Reference Code, A, B, C, D, E). shopping mall ( digest Number, Centre Name, Centre Address) Where the underlined attributes represent the captain exposes within distributively entity. In the expectation entity I decided to use both candidate number and also centre number as a joint primary key as candidate come were except unique to their centre. This would mean that there could be four-fold candidates with the equivalent candidate n umber however the candidate number and centre number combined would everlastingly be unique. For the subject entity, subject character jurisprudence was the only sensible primary 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 distant key in the candidate entity. An other(a) foreign key in this initial model is subject cite decree in the candidate entity. information Types Candidate Name text 20 Candidate Number integer Centre Number recollective integer Subject Name text 15 Subject Reference Code longsighted 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 electron orbit I altered the length of each field appropriately.I did this by either transformation from long integer to integer, or changing the maximum number of characters in each field. In this instruction I was able to save on the space that the infobase used. Following is the reasons for choosing the selective information types for some of the field 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 sterilise aside for each temperament. Candidate Number as candidate number is only 4 physiques long there would be no way in which it would draw the maximum length an integer would provide.Therefore I chose to pass 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 guide the maximum length of an integer of 32768. Subject Reference Code this field again used long integer as its data type due to it being a 5 digit code. To fix that the field could start with a 0 I altered the properties of the field as below Original Grade I decre ased the length of this field to 1. The stage would always only be a 1 letter swan 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 bring provided more space as it would make the system slower and the duplicate space would not have been needed First Normal Form 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 weaken the entity up into 2 separate entities, candidate and re-mark. So my modern 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-m ark Grade, Requested) Subject (Subject Reference Code, A, B, C, D, E) Centre (Centre Number, Centre Name, Centre Address) The new entity remark has a composite 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. likewise in this way I was able to ensure that all of my tables were in first habitual form, satisfying the criteria of eliminating duplicative handle within the same table. By making the re-mark table a sub-form of candidate through the use of a one to many 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 cohere 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 made. 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 tiptop 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 figure 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 bring forthd in access.As can be notable 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 usin g Microsoft Access, as well as some coding within ocular Basic which I will 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 distant 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 solvent could be provided in a fairly simplistic form. My other principal(prenominal) 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 h ave been the best alternative choice, however I did not do this for the reasons above. On top of this I wanted to expand my knowledge of systems creation by experimenting with Visual Basic and also Access. weightyware The hardware which I will be initially creating my solution on is my home PC. This PC was built by me and therefore I am in truth known 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 packet that I was creating would work on a PC of lower specification so that anyone that was using it would not be forced to up track their systems to use my database. I therefore did some establishing 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 calculate As can be seen in the properties of the candidate name attribute, I have changed the field size to 20.Also it can be seen that the primary key is a composite one made up of candidate number and centre number. Candidate Table popular opinion 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 then 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 a ll of the test data for my database, it may be noted that there are more than 15 re-marks (the corresponding 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. ecesis Rules In the specification there were a few observes 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 ten thousand to 80000 an d 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 all 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 nee ding to change the design of the re-mark table slightly. I needed to add an attribute (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, fitting Received) Forms Main To make the design as user friendly as possible, I have split it into 2 sections of arousal 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 exit sacking in the bottom right of each form. I have kept this constant to stay in line with the element of least surprise design. virgin 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 i s 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 quality 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 railcarmatically.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 previously submitted papers. The locked fields are coloured in grey. some other feature which is used in this table is an auto-grading sys tem, where the system calculates the grade from the mark entered. This feature also takes into attachment 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 equal to todays date. The field was like the grade boundary fields hidden on the form. written themes The following are the insures which I included to provide hard copies for the end user. infra I have listed the names of each of these reports and have also printed out congresswomans of each report. Each example is clipped onto the end of this report the page number wil l be included next to the report name beneath Grade Changes (pg ) Outstanding Re-marks (pg ) 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 Data Used or Action Taken evaluate Result Actual Result 1 check out that main form loads Click main form button Switchboard form displayed.Form undefended 2 breach New Centre form Opens Click New Centre Button New Centre form at new record Form opened 3 Check New Subject form Opens Click New Subject Button New Subject form at new record For m 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 box then report preview.After entry 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 go in 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 validati on rule for candidate number Insert 5 digit code.Rejection of the code spurned 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 auto date feature Enter date field Generation of todays date Generated 23 Check that railcar grade feature works for a lterations Change an existing mark Regeneration of grade to new grade Generated 24 Check validation of dates Insert abc 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.