Databases

Edit 0 3 …
app_tracking_sheet.pdf

Unit: Databases

Students develop a relational database for stock control.

time (dbl lssn)
 learning outcomes
 teaching activities
 resources
 assessment
 Notes (Cross-Curricular Links, Core Skills, Global Citizenship etc.)
1
 Revise:
  • Basic DB vocab (records, fields, etc).
  • Data types.
 Students:
  • Add fields to tbl_products:
    • Boolean - free delivery for products over certain price.
    • Date/time - sold_since.
    • Attachment - image of product.
    • Lookup wizard - basic component type (input, CPU, output, storage).
 Moodle:
  • DB with single table of products. CHANGE SUPPLIER FIELD LEGTH TO 3!
Dept Website:

1


.
1










Moodle check list
http://moodle.standrews.ac.th/moodle/mod/checklist/view.php?id=23634

Databases Self-assessment

If you understand it and could demonstrate it, check the box. Otherwise, don't.

  1. Level 4
  2. I search for data by sorting and filtering.
  3. I store searches as queries so that I can use them again.
  4. Level 5
  5. I create database tables and choose the correct data type for each field.
  6. I set appropriate field lengths for text fields.
  7. I make queries that search for things using AND, OR, NOT, LIKE, etc.
  8. I create reports to show the results of my queries in a better format.
  9. I save database objects without spaces in the name and with sensible prefixes like tbl_
  10. Level 6
  11. I create data entry forms.
  12. I use boolean (yes/no) fields.
  13. I use the LOOKUP wizard to control what data can be entered.
  14. I control how a form is used (by making it JUST for data entry or JUST for amending, etc).
  15. I validate data to check for obvious errors as it is entered.
  16. I use input masks to help people input data like car registration numbers.
  17. I link other applications to my database (like mail merge to a word processor or active graphs in a presentation).
  18. Level 7
  19. I use queries to find totals.
  20. I derive data at run-time (like finding age from date of birth).
  21. I add summaries to reports.
  22. I control page breaks in reports.
  23. Level 8
  24. I link tables together to make data storage more efficient.
  25. I use append and update queries when managing databases.
  26. I understand that Users can be confused by databases and help them using control panels.
  27. Exceptional Performance
  28. I use pivot tables and charts when I need my database to behave more like a spreadsheet.
  29. My databases can be used by non-ICT specialists because I control (and simplify) what they can see and do at all times.