• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13

Making a relationship database for Beardwood High School.

Extracts from this document...

Introduction

Implementation To make a relationship database for Beardwood High School, Microsoft XP Access was used. This was done by selecting "Start" from the menu and then "Programs" and then "Microsoft Access" as shown on the screen print below: As soon as Microsoft Access was chosen, the software was open and from there a "Blank Database" was selected. After the blank database was selected an option message bar appeared which gave me the option to name the database and where to save it as shown below on the screen print The new blank database was saved as "Library System" in the "A2 ICT Coursework Folder". As soon as the A2 ICT coursework folder was chosen I created another folder naming it "Project" which will store all my database project work only. Also in that A2 ICT coursework folder I also created other folders which would hold my other parts of my coursework such as Analysis, Design, Implementation and Testing work. By creating these folders it's a standard way of working which will save me a lot of time and my files that I want to access will be easy to find as they are stored in folders. As soon as saved the new blank database I first started to create my main tables which contain valuable information for the system to work. ...read more.

Middle

There is also a validation set for the Date of Birth field which means that anybody between the age of 11 and 16 will be a working data that will be accepted. And if the wrong date of birth is inputted into the system an error message will appear informing the user to enter a valid date of birth that is accepted within the criteria set. Year Group The year group has been validated so that it only allows any year to be entered from year 7 up to year 11. If any data under year 7 or above 11 is inputted it will be rejected and an error message will appear automatically informing the user to enter a valid year group between year 7 and year 11 Town County For the town and county a default value has been entered because everybody who attends Beardwood School lives in Blackburn. Therefore every time a new record needs to be made for a student the end user will not need to repetitive type every single time Blackburn in the town field which means Blackburn will be automatically present every time a new record is made. This means that it saves on input time and also limits the chances of error being inputted in to the system Post Code the post code was also given ...read more.

Conclusion

Price of Book For the price of book the format was changed to currency and a validation rule was set for the price of the book to be more than �0.00 as no more than cost less than Number of Rentals Validations for Payments PaymentID BorrowerID Payment amount After all the validation were set up for all the tables. The next step was to create a relationship between the tables and this was done by clicking the relationship button on the main screen which looks like as shown on the screen print From the relationship above it shows 1 to many relationship between Borrower and Payments because one borrower can make many payments whereas a payment can be only be made by a specific borrower. After I created my relationships I then started to create data entry forms because entering data into the tables does not look professional and can be confusing. And also by creating data entry forms I am meeting one of the end users requirements that the "system should be user friendly and easy to use" The first form that was created was the borrower form and a wizard was used to create the forms as it much quicker to create forms from wizards rather than designing and making your own. This how the borrower's data entry form looks like Usama Khan ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level Information Systems and Communication section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level Information Systems and Communication essays

  1. Marked by a teacher

    Database Coursework on a Vehicle Rental System: Analysis

    5 star(s)

    obtained from Fred, unclouded by the interviewee's interpretation of subtle cues on the part of the interviewer. However, on the other hand, though, this rigid structure will not allow potentially interesting lines of inquiry to be pursued or followed up on.

  2. Marked by a teacher

    Information Age

    3 star(s)

    recommendations, lists of videos added to friends' pages and other exclusive social features. These features would be made available for all users soon. This website offers streamline services. Besides that games, ITV archive, news, sport, entertaintment, lifestyle, drama, interactive TV guide as well as soaps are provided.

  1. System Analysis and Design Assignment

    Also if the Books File become damaged, lost or is out of order then this will make the librarian's job even more difficult. * Borrowing a Book from the Library There are a number of procedures which must take place in order for a member to borrow a book from the Learning Centre library.

  2. A2 ICT CouseWork

    "All the web pages on the website should be linked together" this test will be done simply by testing if each link in the website works properly. The testing method may differ during the client requirement testing as we shall complete a series of different test's when examining each point,

  1. ict as level coursework

    All product details should transfer on to the invoice. Printed invoice should display correct details 8 When a new customer is registered check if they are automatically transferred to customer details spreadsheet. Add a new customer and check the 'customer details' spread sheet to see if it has been copied there.

  2. Data Processing Task. Mr Peters, the man who runs this particular Samsung store ...

    Currency The balance of the business in pounds. Presence Check Type Check Balance (�) Currency The balance of the business in euros Presence Check Type Check Entities with attributes Business Table Order Table Field Data Type Length Description Validation OrderID Auto Number Long Integer A unique one or two digit code to represent a particular order from a

  1. User Guide to my minibus hire database.

    - Beside the "Model" label there will be a data entry box, type in the model of the minibus in this box. - Beside the "Price per day" label there will be a data entry box, type in the price you wish to charge for hiring out the minibus, this

  2. ICT AS-Level Coursework

    2. The system is very unreliable in that it sometimes doesn't work so they have to have professionals to come and sort out the system. 3. The system is very limited to responses, it can only handle data recollection, taking off stock when it has been sold and giving a final total at the end of the day.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work