Activities
A 3.4.4 Worksheet
Instructions: Answer the following questions to the best of your ability. Feature Matching: Match the following distributed database features with their correct definitions: Answers: a) ____, b) ____,...
Activities
A 3.4.4 Worksheet Answers
Data Consistency: Maintaining data consistency is a significant challenge in a distributed database compared to a centralized database because data resides on multiple independent nodes that communicate...
Activities
A 3.3.1 Student Activity
Objective: To gain practical experience using a basic DDL command (CREATE TABLE) to define a simple database table. Instructions: Write a CREATE TABLE Statement: In the text area, write a CREATE TABLE...
Activities
A 3.3.2 Worksheet Answers
Absolutely! Here are the SQL queries and their expected results based on the provided schema: Database Schema: Answers: List all students and the courses they are enrolled in. (Use an INNER JOIN). SQL...
Activities
A 3.3.4 Worksheet
Instructions: Sample Database Schema (Example 1: Students and Grades) Questions (Example 1): Sample Database Schema (Example 2: Sales Data) Questions (Example 2): Here is the SQL that will create the...
Activities
A 3.2.4 Constructing Tables Worksheet Answers
Part 1: Table Analysis Instructions: Analyze the following table designs and identify potential problems. For each table, explain what issues might arise and how the design could be improved. Table 1:...
Activities
A 3.2.4 Constructing tables Worksheet
Part 1: Table Analysis Table 1: Employees EmployeeID (INT) Name (VARCHAR) Department (VARCHAR) Salary (FLOAT) Address (VARCHAR) Phone (VARCHAR) Example records: | 123 | John Smith | Sales | 60000 |...
Activities
A 3.2.3 Data types Worksheet
Part 1: Match 'Em Up Instructions: Match each data description to the most appropriate data type from the list Part 2: Why is it wrong? Instructions: Each situation below describes a bad choice of data...
Activities
A3 Databases
DP Computer Science Topic A3: Databases covers fundamental principles, design (ER, normalisation), and SQL programming for data management. HL extends to NoSQL, data warehouses (characteristics, OLAP,...
Activities
B1 Computational thinking
Topic B1 explores computational thinking: problem specification, key concepts for problem-solving, and depicting solutions....