SB1 Using a Database

BA2 explain the purpose and target audience for an example database and differentiate between data and information

STARTER:

What type of website is the iTunes Store...? Discuss with your partner

• How is it used?
• What is it used for?
• How is it different to a 'normal' website?

18061954

What does this number mean?

KEY TERMS: Is this number currently DATA or INFORMATION? What would help it change into one or the other...?

TASK 1:

 

‘Flesh out’ this scenario. Who are their customers? What sort of clothes do their customers like? Why do their customers need/want a personal shopper?

 

Decide on an audience profile and fill in the Audience Profile Form.doc (O:\ICT\GCSE ICT Year 10 2013\SB1 FEN\Lesson 1 Using a database).

 

Save this profile in your user area. (Create a new folder called SB1 for this block of work).

TASK 2: Adding

 

Copy & Paste the Database "fashion_V2000" to your own area!

 

Have a go at adding at least 3 new clothes items and 2 new suppliers.

 

Does this work first time? If not, why not? What did you do about it?

Screenshot the records you have added and paste them into a new document, explaining how you went about doing this and also answering the questions above if appropriate.

Save this as Database Theory

TASK 3: Searching

The following people have approached your online personal shopper Clothes4U business and have requested that you find them clothing items:

• Mrs Brown wants an evening dress. Her budget is £500, but she hope to get away with spending less.
• Jon wants to spend his birthday money (£100) on an item of sports gear. 
• Anja needs a list of the email addresses and phone numbers of companies that stock T-shirts.

Add these 6 screenshots to your ongoing document

 

MAKE SURE YOU HAVE ALL 3 SAVED!

KEY TERMS:

• Flat File Database and Relational Database - what do they mean?
• Validation - how does it work? what does it do?

TASK 4: Reporting

Create 3 reports that present the results of your queries in a more formal way. Consider:

• Lost data/headings
• Layout - Portrait or Landscape?
• Suitable Title for each - "Report to show..."
• Try to get your reports to fit to one page (width ways at least)

TASK 5: Customising

Find a suitable image from the internet and add this to the header of your Report(s).

When the reports are suitbale to print, print all three.

Complete any outstanding screenshots/annotations in your ongoing document and print this too.

EXT:

Explain in detail how different search criteria works:

• =100
• < or > 100
• <= or => 100
• Between 50 And 100
• Like "*T-Shirt*"

Also explain the significance of searching across a Relational Database

You should have:

1. Audience Profile Form
2. Screenshots (including Adding Data, Errors, Queries) plus annotation
3. Three completed reports
4. Search criteria definitions
5. Homework

HWK:

ShowMyHomework.co.uk - Uses of a Database