• 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. The Computer and Video Game Environment

    they should be exposed to violence and aggressive role play in games are not new but something that parents have to come to terms with in their own way. * An added dimension of the issue is that obesity in children is increasingly causing additional worries about ensuring that children

  2. Ict Report Template

    I will use Microsoft excel to create a spreadsheet and input prices of the products into the spreadsheet. Check in the Gcse folder alternatively check on the website and see if it has been published. Product images Images Get a picture from the internet and save into images folder in Dreamweaver.

  1. How I use ICT

    This is very useful to me because whenever I'm tired and cannot go downstairs to the fridge I can get a drink or a snack out of my fridge. Also when I wake up or wake up in the night gasping of thirst I can have a drink.

  2. 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.

  1. 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.

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

    Yes No 10. Does your computer have acrobat reader so you can read downloaded information? Yes No 12. Would you like the website to have a help section? Yes No 13. Would you like contact details of the company? Yes No 14. Is your computer connected to a printer?

  1. 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

  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.

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