Databases Lesson 1
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
Starter • Play the whodunnit game to have a go at a database. • www.cherwell.oxon.sch.uk/subjects/ict/whodunnit/
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*)
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.
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.
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
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
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
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?