• 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. Moral panics – video nasties

    They focused on the difference between innocence and evil and why we as a society let this happen, it suggested the increase of public indifference, lowering family values and increasing isolation, generating massive public guilt and predicting a breakdown in society itself.

  2. The Computer and Video Game Environment

    The Channel Islands' authorities have been under pressure from the UK government to close this loophole. The Jersey government has responded to pressure and issued a policy statement dividing the sector into two categories of business. Economic * Consumers can afford to play and buy gifts.

  1. Ict Report Template

    Check in the Gcse folder alternatively check on the website and see if your information has been published. Products and prices of your product. Excel Will create a spreadsheet of all my products and there prices in a spreadsheet on Excel.

  2. How I use ICT

    This is good because I would normally have to go downstairs to get a drink or snack but with this clever little bit of technology I can stay in my room and have a drink without turning all the lights on and making a noise going down the stairs and

  1. Compare two search engines on the internet.

    Therefore, 'Yahoo!' seems to be attracting a younger audience. So, the main colours that 'Yahoo!' have used include: red, blue, black and purple on a white background. 'Ask Jeeves' has a fairly small title, but a large logo, so you know where you are: This page is quite uncrowded, so nothing needs to be particularly bold.

  2. Setting up a good video shop.

    � Although rentals have traditionally been difficult to calculate, reports that the total income of businesses in the video hire industry was $595 million in 1999/2000. Some see the rental industry as being in a healthy but mature phase; others regard the threats from competing entertainment forms, especially video-on-demand and digital television, leading to an inevitable shake-out for stores.

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

    Yes No 7. Do you want to be able to see links to all pages at all times? Yes No 8. Do you prefer pictures to writing? Yes No 9. Do you like websites to have frames? Yes No 10.

  2. Web design - build a store guide for a department store.

    The monitor displayed my store guide as I was creating it. I used the hard drive to save my work so that I wouldn't loose it. I could of used a scanner or a digital camera to import images that I had scanned or taken photo's of, and imported them

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