week 5

Learning aim C: Develop and test a relational database

Software tools and techniques to develop a relational database

 

Create and edit:

● single and multiple table structures with appropriate field characteristics, including

o field names

o field data types, e.g. alphabetic (text and memo), numeric (number, currency, and date/time), alphanumeric (text and memo), logical (yes/no and true/false), web (hyperlink), lookup wizards

o field sizes (e.g. byte, integer, long integer, single, double and decimal)

o field formats (e.g. fixed and decimal places)

o default values

 

● validation rules and text, which applies to a range, format and length for different data types including input masks

 

● indexing (e.g. primary key, foreign key)

 

● create new records (e.g. populate tables with data manually or import a data set from an external source (text file or spreadsheet))

 

● edit and delete existing records of data

 

● create, edit and delete relationships

 

● use wizards.

 


Last Updated
2021-03-25 16:19:52
English and Maths

English


Sentences with different forms: statement, question, exclamation, command


Organising Information: Organise information and ideas into structured and sequenced sentences, paragraphs and whole texts, using a variety of linguistic and structural features to support cohesion and overall coherence.


Sentence Structure: Use a range of sentence structures for clarity, purpose and effect, with accurate punctuation and spelling.


Maths


Analysis of information: Interpreting Results, Drawing conclusions from data, Comparing data


Money: Budgeting, Estimating, Rounding to nearest pound, using correct symbols, calculating costs using a calculator


Using numbers: Written or mental methods, using a calculator, rounding and estimating, problem solving


Stretch and Challenge

Stretch and Challenge


  • Fast to implement
  • Accessible by default
  • No dependencies
Homework

Homework


Equality and Diversity Calendar
How to's

How 2's Coverage

Anonymous Assessment - Learners assess an anonymous piece of work containing deliberate mistakes against given success criteria.

Just a Minute - At the end of the lesson teachers ask learners to summarise their learning. The comparison of these summaries against learning objectives informs planning.

 



Anonymous Assessment - Learners assess an anonymous piece of work containing deliberate mistakes against given success criteria.

Links to Learning Outcomes

Links to Assessment criteria
 

1C.4 Develop a database with a realistic data set with guidance, including:

● a single table structure

● a data-entry form.

2C.P4 Develop a relational database with a realistic data set, which includes:

● two tables

● sort records

● data-entry forms.

2C.P5 Test the functionality and purpose of the relational database for functionality, repairing any faults.*

2C.M3 Develop the database demonstrating awareness of users’ requirements and accuracy. To include:

● customised dataentry forms

● queries and output data reports

● onscreen navigation and guidance

2C.M4 Gather feedback from others and use it to improve the database and test any additional functionality, repairing any faults.*

2C.D3 Refine the database solution using automated tools and techniques to improve productivity, accuracy and the presentation of output data, taking account of user feedback.* 1C.5 Test the functionality of the database and repair any faults with guidance.*

 

 

 

Files that support this week

| | | | |
Week 4←
PrevWeek 5←
PrevWeek 6←
Prev→
Next