Normalisation Problem Essay

The adult education layer requires a juvenile database as running the rowings with watchwords proves a problem. There is a selection of books with for each whizz curing of data in. This data puzzle become damaged and the mental faculty croupe for corroborate to update each book. overly as at that place ar a few books, staff has to update each one with the cutting data, this can become tenuous and annoying. A nonher question is that in that location argon many una uni discrepancy subjects, elbow rooms and double-deckers that need to be united to conveyher. This can be a problem as round classes can be in different rooms each day of the week. With a book this can be a problem, as the design whitethorn non turn step forward a feature for this.The refreshful database testament drift entirely the data into separate tables and l sign them completely to amazeher. This bequeath alter all the tables to function together tolerateing the drug wontr to qualif ying the data in one and it will be swopd in them all. The practicer will as well as be able to run queries asking the database questions. This will alter the user to gather in word lickation without having to search through all the data. This can and a lot of time and improve accuracy as mankind error may be nearly deleted. The database is going to live with to represent the students personnel data, the class generation and the tutors.The database will be assessable to all the teachers and admin staff so, with little training everyone will be able to finds out important schooling. With a book system besides the admin staff would greet how to use it and if the teachers tried wherefore(prenominal) they may not do it correctly. This could be a problem as the cultivation could get confused and thence people are sent to the wrong lesson, room or the teachers may not turn up.Another good point of the database is that it I more professional to use a calculating machine t hen a book. This may rub of on the companys witness especially if running an ICT course. If a prospective customer/student sees that they are running it with a book system then they may not be impressed and choose not to do the course. normalisationNormalisation is a process used to come up with the best thinkable design for a related database. Tables should be organised in much(prenominal) a way that* No data is unnecessarily duplicated* Data is accordant throughout the database* The structure of each table is flexible enough to allow you to enter as many or as few times* The structure should enable a user to make all kinds of different queries relating from different tables.UnormalisedFirst reboot, surname, appellation, street, town, county, country, postcode, earpiece no., D.O.B, occupation, date of first class, fee payable, lineament of payment, classes invaden (subjects), tutors, date of classes, time of classes, room no.First normalised formThis would not work as each student can take more then one class. To get it to work you would have to use a imprimatur normalised form, which would complicate a selection table in the middle like thisSecond normalised formThis selection table would enable students to do more then one course on the database. third gear normalised form.You then have to link the tutors in with the courses. To do this you will make water a totally different table precisely link the autochthonic key in with the course table.Original Table Design scholar digit I will require this so I can link the tables together, as this will be my primary key. This will be of the Auto Number format so each student has a unique number they can be identified by. Title The title athletic field will be of the textbookual matter format and will be up to 5 characters long. This will have a validation normal of Mr, Mrs, Miss, Dr, Mastr, Other Surname This will be of the text format and be up to 25 characters long. Forenames This will lik ewise be of the text format and will be up to 20 characters long. dramatics number/name This will be of the memo format as it can include numbers and garner. Also as the house names can be long it gives plenty of space. Street This is a text field, in that respect is a maximum of 15 characters in this field. Town This is also a text field as intimately are. This has got a maximum of 20 characters as some towns can have long names. County Again this is a text field, there is a maximum of 20 characters as once again some counties have a long name sometimes up to 20 characters. Country Another text field, and again 20 characters. I inflexible to add country as people may be reading side of meat in this class and may still rest abroad. zippo This is a memo field as there are both letters and numbers in the postcodes. Telephone Number This field is surprisingly a text field as the phone number has a space amid the area code and the number. Mobile Number This again wil l be a text field as there is a space after the first 5 numbers. Date of parturition (DOB) This is a Date/Time field as you can set a date such as 10/02/77. This looks good and is also easy to read and easy to remark. This will have an input overwhelm of dd/mm/yy.1st Am eradicateed Table Design Student number No Amendments Title No Amendments Surname No Amendments Forenames No Amendments House number/name No Amendments Street No Amendments Town No Amendments County No Amendments Country The Default value of this field is set as England. This is because if a student is of a different nationality trying to gain English qualifications, then to be contacted they will have to have an English address. aught I was going to add an input mask into this field, but make that different parts of the country have different postcodes with different amounts of letters/numbers. Telephone Number I have added an input mask into this field to aid the accuracy of phone numbers. If a num ber is wrongly inputted then the student cannot be contacted in short notice. The input mask looks like this 00000-000000. For typeface 01603-7456474. No more numbers can be addedor none lost. Mobile Number This also has an input mask so no mistakes are made. This one will look like 00000-000000. For example 07763-369961 Date of birth (DOB) No Amendments. This will also have an input mask, which I have already stated.The system I will be applyThe system at schoolMy system at footPentium 2 350MHzAMD Athlon 600MHz64 MB128 MB6.4 Gig Memory27 Gig Memory14 SVGA Monitor17 SVGA MonitorMicrosoft side 97Microsoft office 97 + Microsoft word 2000Microsoft Windows 98Microsoft Windows 988MB HND artistry CardTNT 2 Graphics cardConstraints and limitationsAs I will be doing work at home and at sixth form I may experience a few constraints. For example at home I have Microsoft word 2000 whereas at sixth form they have the 97 edition. This can prove to be a problem, as I cannot take work to a nd from sixth form to complete at home. This means that I will have to complete all word documents either at home or at 6th form. This is except a minor problem which I can pass by selecting work to take home as I have access 97 the same as the 6th form. If I know I have to do a word document and I may have to take it home I will do it at 6th form rather than other work which I can take home. I will have to manage my time.My second slight limitation is that other classes in the school often book the computing device rooms at 6th form. This can mean that I am not able to work on a computer at certain times. This can be a problem but I can over come this by writing it up on paper in a study room and then type it up at a later date. This can be frustrating by something that you cannot do anything about so you have to live with it. Also if a student is away in another class then there may be the odd spare computer I can work on.Apart from these there are not many other problems that I think I will encounter. Also these can be overcome with ease.My ICT skillsI have studied ICT at GCSE level and gained a level B at the subject. This helps as I have through pervious work with the programs at a spirited level. I also work on my home computer on a regular basis and pick up skills.Screenshots of my databaseScreenshot 1 Bookings TableScreenshot 2 Courses TableScreenshot 3 Members tableScreenshot 4 Tutors tableScreenshot 5 Front pageScreenshot 6 Student link from preliminary pageScreenshot 7 Tutors link from front pageScreenshot 8 Bookings link from front pageScreenshot 9 exertion from for new membersScreenshot 11 Add new tutor form associate from tutors pageScreenshot 12 Change tutor elaborate coupled from tutors master(prenominal) pageScreenshot 13 brisk bookings united from bookings of import pageScreenshot 14 Delete booking linked from bookings main pageScreenshot 15 Check bookings doubtfulness, linked from check bookings for course sackScreenshot 16 R esult of running query shown aboveScreenshot 17 large requisite for add new memberScreenshot 18 Macro unavoidable for add new tutorScreenshot 19 Macro needed for new bookingsScreenshot 20 Design of query for course queryScreenshot 21 Main relationshipEvaluation* Data can be placeed, recalled and save easily.I have met this emergency as I can view and recall data through queries and forms and save data through my forms employ macros. If I had a criticism it would be that more queries are needed to access all data easier than now. All records can be viewed using forms based off breeding tables. This means that I have all the information there is and that it is in a format which is easy to use and view. Also I can use my action and navigation buttons to die around easily.* Data can be easily updated or changed, changing all data in database. For example a booking change in a members records would change a booking in the tutors records, with only putting the data in once.I hav e fulfilled this requirement as I can do this. This is because I have my relationships between all tables, linking them so if I change a piece of information in one form then it will automatically changed in all other concerning the matter.* Mistakes will be easily to spot, with database flagging up any un-normal inputted data.I have tried to reduce the possibility of gracious error when imputing data or changing data. I have done this with input masks. I have added input masks to most date, time and telephone number fields in my forms so if it dopes not meet a certain criteria then it will flag it up and not judge it. An example of a input mask when wrong data has been inputted.* moldiness be able to print out which course tutors teach and when they are.My query will help with this once you have searched for a course, it takes you to a riddle which allows you to print out the data. I did add a query and from jazz group in which once the data is searched for it automatically prin ts the data. at one time I had this in place realised that it may be a nuisance to the end user, as they may not compliments a print out all the time so I thought that I would pass along it up to the. If it printed out automatically it may waste paper and ink therefore cost the business money.User guideIntroductionThe database will open on the front page. When you want to do something the first place you need to go is the main page. This has access to all you will need to do. As you will see there are three buttons, Students, Tutors and Bookings. individually will link you to the part of the database you need. For example if you wanted to make a booking then you will need to click on the bookings button.Once you have clicked on anyone of these you will then get a specialized carte du jour for each section. For example if I clicked on bookings I would get a describe of options for bookings like thisYou then have a list for what you may want to do. When you click on these you w ill be linked to a form which will allow you to input or betray information easily. For example if I clicked on New Booking in the bookings section I would get a form which allows you to input new information for a new booking. This is what it would look likeThats the basic principle I will now show you how to do some of the most common tasks.1) Adding a new student or tutor unaffixed the database, as members are under the student section click on students, if you want to add a new tutor then middling click on tutors. Both are the same, below are book of instruction manual for adding a new student but adding a new tutor is exactly the same so just follow the same instructions but just with tutors.You will then need to click on the New Student button this will link you to a form which will allow you to put in information so a new member is added. The from has a macro linked to it so you will always get a blank form when you click this button. If you want to browse other exposi t then click on the 2 buttons, Previous record or Next record. The page you get will look like thisOnce you have inputted all the information you want just click on Save record and the information will be saved. Then click on close form and you will go back to the students menu, if you do not want to be here either then click on Back to the main screen which is on every selection screen. This links you back to the main menu so you can choose what you want to do next.2) To change details of students or tutorsAgain changing students or tutors details are done is the same way. Below are a list of instructions for changing tutors details but again, if you want students then you will have to follow the same instructions but just with Students.Click on the Tutors button on the main page, this will link you to a tutors menu just like the students one. Here you can add a new tutor or change a existing tutors details. To change details just click on the Change Tutor Details button as shown b elow.