• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Design Section – Gcse Ict Coursework Two – Database Project AndrÉ Skepple-Garraway – Candidate No.

Extracts from this document...


Design Section - GCSE ICT Coursework Two - Database Project Andr� Skepple-Garraway - Candidate No. 8218 1st April 2002 Form Designs Members Information Design and Field Definitions Table Field Name Data Type Field Size Validation Description Customer ID Text 7 Input mask: LL00\0900 Members chosen ID number Surname 20 -- Members Surname (Alphabetic order) Forename 50 Members Forename Telephone 13 Input mask: 0\ 20\-0000\-0000 Member's telephone number Gender 1 Input mask: L "M" or "F" Member's gender (M or F) Date Joined Date/Time -- Default value:=Date() Date Member joined. For a new member has today's date (=Date()) Date of Birth -- Member's Date of Birth Address Text 50 Member's address Post Code 8 Input mask: La09\ 0LL Member's post code Town 20 -- Member's town Borough Member's borough Video Information Design and Field Definitions Field Name Data Type Field Size Validation Description ID Number Text 12 Input mask: L\-000\-0000\-L Video's ID number given by the store for easy search and classification. ...read more.


Member Information Customer ID -- Yes -- Video Rental Information Video ID -- Video Name -- Loan ID -- Cost of Rental -- Issue Date -- Returned "No" No -- Date Due -- Yes Date Due: [Issue Date]+2 Days Overdue -- Days Overdue: DateDiff("d",[Date Due],Date()) Overdue Cost -- Overdue cost: [Days Overdue]*[Cost of rental] Date of Birth Form Design and Query Design Table Description Table Name Field Name Search Criteria Automatically searches for members born after 1st January 1980 Member Information Customer ID -- Surname Forename Date of Birth >#01/01/1980# Video Rental Information Form Design and Field Definitions Table Field name Data type Field size Validation Description Video ID Text 12 Input mask: L\-000\-0000\-L The video's ID number given by the store Video Name 50 -- The video's title VHS or DVD 3 Input mask: LLL The video's format Loan ID 5 Input mask: LL000 The ID number of the loan according to the member and video and kept as reference of issues. ...read more.


Overdue Rentals Entity Relationships Final Form Designs Main Menu Rentals Menu Membership Menu Member Information Video Database 1980's Club Rental Information Overdue Rentals Test Plan Designs User Requirement How It will be tested Members details be able to update easily System testing - allow users to edit database Show the price of rentals and can automatically update and indicate staff when video is overdue on the day and every other day System testing - allow users to access Overdue Rentals form. Staff can easily search to find member information for overdue video rentals and the member's information. Able to print hard copies for manual backup System testing - allow users to print records and reports Can be saved and stored for backup System testing - work through forms and save databases System Flowchart - Entering new members Renting a video Entering new video's Overdue Video's ...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 Internet 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 Internet essays

  1. Compare two search engines on the internet.

    possibly for the news, whose language may be suitable for more mature people. This is not the same, however for 'Ask Jeeves'. The language on there is suitable for young people as well as older people. As there is no news headlines etc.

  2. Design and create a website for a company of my choice. I have decided ...

    I have also given details about the cost for buying and the cost of hiring these products. I have set it out like this because it shows how much the company earns from these items. I have designed a spreadsheet to show the stock details of the company "Belle Du Jour".

  1. Evaluation of Two Commercial Multimedia products. oth products are professional animations which have ...

    easy to understand and appropriate for my target audience so that they can enjoy the story. Characters and objects: This animation has got six different characters and used a lot of objects. The number of characters are appropriate as they not too much which makes the animation crowdy and audience

  2. Moral panics – video nasties

    This deviant act dominated the newspaper headlines and created a panic. This murder was portrayed as a horrific act in the press and symbolized the degeneration of modern British society. The Bulger case was used, by the media, to symbolise all what was wrong with Britain.

  1. Website Business Report - A report for the directors of Top Gear plc -

    and secondary (desk). For my primary research I was a member of a market research group. Other members of my group included Mark Bain, Ben Gardner, Tom Ellard, Ben Bailey and Daniel Corcoran. Together, as a group, we created a questionnaire for members of the public to give us information

  2. Adults and ICT.

    Now that he has started using Microsoft Excel, he can do his work quicker and doesn't have to waste time. Despite all these advantages of Microsoft Excel, there are also disadvantages to this software. For example, there are lots and lots of different facilities that cannot be used by most people.

  1. Ict Report Template

    Why is my chosen ICT solution a sensible way of solving this problem I have chosen alternative solution 2 because it is a simple idea and it is the most obvious idea to create a website and publish it onto the (World Wide Web).

  2. Setting up a good video shop.

    so our planned sales fore cast is shown on the graph below: - Predicted Sales forecast for First Year As you can see we are expecting to see a greater demand in December time for Christmas, then average for the normal months- then a rise again for Easter- Jun/Jul are

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