# 3.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/3.1_Assignment__Introduction_to_Databases_&_Queries/3.1_Assignment.pdf
pages: 1

---
[page 1]
Assignment / Activity: Apply What You've Learned 
 Activity Title: Build & Query a Simple Student Database 
 Instructions  : 
 Use any online SQL editor like  https://sqliteonline.com  or  https://sqlfiddle.com  to complete the 
 following tasks: 
 Q1. Create a table called  Students  with the following  fields: 
 ●  id  (INTEGER, Primary Key) 
 ●  name  (TEXT) 
 ●  grade  (INTEGER) 
 Q2. Insert 3 student records into the  Students  table. 
 Example: 
 sql 
 CopyEdit 
 INSERT INTO Students (id, name, grade) VALUES (1, 'Aman', 95); 
 Q3. Write a query to fetch names of students who scored above 90. 
 Q4. Add another table called  Courses  with: 
 ●  course_id  (INTEGER, Primary Key) 
 ●  course_name  (TEXT) 
 Insert 2 course records. 
 Q5. Create a JOIN query to display student names along with their course names using a 
 third table called  Enrollments  that contains: 
 ●  student_id 
 ●  course_id