Databases - PowerPoint PPT Presentation

databases n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Databases PowerPoint Presentation
play fullscreen
1 / 10
Databases
104 Views
Download Presentation
justin
Download Presentation

Databases

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Databases Lesson 1

  2. Anagrams S E A A D T B A D I F E L C R O D E R N O I T A I L D A V

  3. Starter • Play the whodunnit game to have a go at a database. • www.cherwell.oxon.sch.uk/subjects/ict/whodunnit/

  4. Objectives • From the spec: “describe a database as a persistent organised store of data” “explain the use of data handling software to create, maintain and interrogate a database.” “describe methods of validating data as it is input” • Learn the basics of databases ALL: Know what a database is (Grade D) MOST: Be able to explain record and field (Grade C/B) SOME: Be able to explore validation techniques (Grade A/A*)

  5. The Brief • A local doctor’s surgery require a system to store the details of their patients so that they know their contact details and basic medical details. • They would also like to be able to set up appointments for patients and give a daily list to each of their doctors. • The system will be used by the receptionist who is employed for her friendly personal skills rather than her IT skills so it should be user friendly.

  6. Task • Load Access. • We are going to complete the first part of the brief by making a table to store the names and details of the patients of the doctor’s surgery. • Design your own table. You should have at least 5 fields. 10 fields is better.

  7. Robust Data? • Try to ensure that people can’t enter inappropriate data by: • Choosing the correct data type • Adding an input mask • Changing the field size • Adding a lookup • Setting it to be required or not • Adding a default value to speed up data entry and to give people an example • Adding a validation rule

  8. Mini-Plenary ALL: Know what a database is (Grade D) MOST: Be able to explain record and field (Grade C/B) SOME: Be able to explore validation techniques (Grade A/A*) Students will be PICKED ON to discuss their progress against these objectives

  9. Data Entry • Add some recordsto your database in the table view. • You should aim for about 20 records. • While you do this you should reflect on the quality of your validations, input masks and data types. • You will be asked questions about this at the end of the lesson! FINISHED? Try some queries

  10. Plenary • Edmodo questions: • What is: • A database? • Field? • Record? • Why might using an input mask of LL0 0LL for a postcode not be suitable for some customers? • Which is the most effective validation technique you have used and why?