Relational Databases Explain the term entities, PPT, The importance of SEN: Reinforce Why does a database have attributes and worksheet, organising and key terms and to be complex? 2 (e) understand the relationships database file finding files in a words relationship between What can be achieved by a database, how can entities and tables Group work; create a G&T: Explain the valid relationship within a that be linked to diagram for an example terms in detail and database? school or life? (f) understand the database given using link to diagram components of a entities and relationships Compatibility and relational database, relationships such as tables, forms, Explain the key queries, reports and components of a modules database (f) Demonstrate database with key components Worksheet; mix and match the descriptions with the keywords Key Fields and Whole class; example PPT, What is the SEN: Key terms Why do we need to validate Validation database design given to worksheets, importance of and explanation of the data within a database? 2 students with different database validation as validating data (g) understand the use Which is more important a data types and validation design, video humans and of logical operators in G&T: Define the PK or a FK? computers? framing database Video; explanation of PK terms ‘data queries and FK and redundancy’ ‘data validation’ (h) explain the use of Pair Work; Identify and with examples of key fields to connect discuss the different data each tables and avoid data types used by a redundancy database (using example) (i) describe methods of validating data as it is Pair Work; identify and input discuss the different validation rules that can apply to fields (using example)
2 Relational Databases (e) understand the relationship between entities and tables (f) understand the components of a relational database, such as tables, forms, queries, reports and modules Explain the term entities, attributes and relationships Group work; create a diagram for an example database given using entities and relationships Explain the key components of a database (f) Demonstrate database with key components Worksheet; mix and match the descriptions with the keywords PPT, worksheet, database file The importance of organising and finding files in a database, how can that be linked to school or life? Compatibility and relationships SEN: Reinforce key terms and words G&T: Explain the terms in detail and link to diagram Why does a database have to be complex? What can be achieved by a valid relationship within a database? 2 Key Fields and Validation (g) understand the use of logical operators in framing database queries (h) explain the use of key fields to connect tables and avoid data redundancy (i) describe methods of validating data as it is input Whole class; example database design given to students with different data types and validation Video; explanation of PK and FK Pair Work; Identify and discuss the different data types used by a database (using example) Pair Work; identify and discuss the different validation rules that can apply to fields (using example) PPT, worksheets, database design, video What is the importance of validation as humans and computers? SEN: Key terms and explanation of validating data G&T: Define the terms ‘data redundancy’ and ‘data validation’ with examples of each Why do we need to validate the data within a database? Which is more important a PK or a FK?