Your question is Primary vs Foreign Keys. Start with the requirements and the two tables on the right.
Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.
Explain the difference between a primary key and a foreign key in SQL.
Use the Airtel customer and subscription tables below to identify the key columns in each table and show how they relate.
table_name, column_name, key_type, references_table, references_columntable_name, then key_type, then column_name| Column | Type | Description |
|---|---|---|
| customer_idPK | INT | Unique customer identifier |
| customer_name | VARCHAR(100) | Customer full name |
| city | VARCHAR(50) | Customer city |
| Column | Type | Description |
|---|---|---|
| subscription_idPK | INT | Unique subscription identifier |
| customer_id | INT | Customer identifier referenced from airtel_customers |
| plan_name | VARCHAR(50) | Subscription plan name |