1 / 10

Databases

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:

justin
Download Presentation

Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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?

More Related