# 2.1 Assignment

course: Academy — 65-GENAI-for-Engineers
module: Academy/65-GENAI-for-Engineers
type: pdf
source_url: https://personal-learn.armco.dev/files/Academy/65-GENAI-for-Engineers/assignments/2.1_Assignment__Introduction_to_Relational_Databases/2.1_Assignment.pdf
pages: 1

---
[page 1]
2.1 Assignment Questions 
 Short Answer / Conceptual Questions 
 1.  Describe what makes a database "relational" and give an example of a real-world 
 system that would use one. 
 2.  Explain the difference between a primary key and a foreign key. 
 3.  Why is normalization important in relational databases? 
 Hands-On / Practical Tasks 
 4.  Design a basic relational schema for a school database with the following tables: 
 Students, Courses, Enrollments. 
 ○  Specify primary and foreign keys. 
 ○  Draw an ER diagram or describe relationships in writing. 
 5.  Using a sample RDBMS (e.g., SQLite, MySQL, or PostgreSQL), create the tables from 
 your schema above and insert at least 3 rows into each. 
 6.  Write SQL queries for the following: 
 a. Select all students enrolled in "Mathematics". 
 b. List all courses with more than 2 students enrolled. 
 c. Find the student(s) with the highest number of enrolled courses.