In this video series, I will be covering the first of two papers that make up the 2020 BTEC Level 3 database exam. I will be taking each task at a time and providing a walk-through of how you could tackle the question. I will provide suggestions and reasons as to why you need to implement elements within the structure of the database and how you go about building the evidence for your exam.
In this part 2 video, I will look at the creation of the tables and structures between them. I cover the establishment of the relationships between the tables using foreign and primary keys. Also covered in this video are the required screenshot deliverables of;
- Presence Checks
- Lookup Tables
- Value Lookups
- Format Checks
- Table Lookups
#MyStudentSite #DatabaseExam #BTEC
