H446 OCR A-Level 1.3.2 Databases and SQL

Introduce your students to databases and SQL / SQLite and build their knowledge through to a mini-project which uses their existing knowledge of Python and Tkinter.

1.3.2a - Database Concepts

• Flat file databases
• Entity identifiers
• Indexing
• Primary, Secondary, and Foreign keys
• Relational databases

1.3.2b - Database Normalisation

• Relational DB design
• Relationships and ERD
• Referential integrity
• Linking DB tables / Link tables
• Normalisation - reasons and 1NF, 2NF, 3NF

1.3.2c Transaction Processing

• Capturing Information
• ACID
• Record locking
• Redundancy

1.3.2d SQL

• SELECT FROM WHERE
• Conditions
• Sorting
• Dot notation
• JOIN
• Data types
• ALTER / UPDATE / DELETE / DROP

SQL Worksheets

1. Customer database: Import provided flat-file database and query it
2. James Bond movies: Import provided flat-file database and query it. Note: this resource is available separately from my TES store
3. High Scores: Import provided relational database and query it
4. Marvel Cinematic Universe: examine provided SQL to create a new database
5. Mini-project: plan and create a relational database and use Python and Tkinter to build an interface. Note: this project expects students to have a basic knowledge of Tkinter and independently research how to implement SQLite 3 in Python. No support files are provided for this activity.