Scribd
Upload
14 views2 pages

Grade 9 SQL Student Records Project

The Grade 9 SQL Group Project involves students working in groups of three to create a Student Records Management System using SQL. Over four weeks, students will design a database, insert data, and perform various SQL queries, with specific roles assigned to each member. The project culminates in a final submission that includes an SQL script, a report document, and an optional presentation, with grading based on structure, data insertion, query accuracy, and teamwork.

Uploaded by

muj12345a
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
14 views2 pages

Grade 9 SQL Student Records Project

The Grade 9 SQL Group Project involves students working in groups of three to create a Student Records Management System using SQL. Over four weeks, students will design a database, insert data, and perform various SQL queries, with specific roles assigned to each member. The project culminates in a final submission that includes an SQL script, a report document, and an optional presentation, with grading based on structure, data insertion, query accuracy, and teamwork.

Uploaded by

muj12345a
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Grade 9 SQL Group Project: Student Records Management System

Objective:

In this project, students will work in groups of three to design a simple database, insert data, and
use SQL queries to retrieve and analyze information. Each student in the group will take on a
specific role, ensuring collaboration and hands-on experience with SQL concepts.

Project Timeline (4 Weeks):

Week 1: Database Structure & Table Creation

Concepts Covered: Database structure, table creation, primary keys, data types.
Group Tasks:
- Student 1: Creates the database (SchoolDB) and designs the table structure.
- Student 2: Defines appropriate data types and sets up primary keys.
- Student 3: Reviews the structure, ensures all necessary fields are included, and documents
table descriptions.

Week 2: Data Insertion & Basic Queries

Concepts Covered: INSERT INTO, SELECT FROM queries.


Group Tasks:
- Student 1: Inserts at least 10 student records into the Students table.
- Student 2: Writes queries to retrieve all student records.
- Student 3: Writes queries to retrieve students in a specific grade.

Week 3: Filtering & Sorting Data

Concepts Covered: SELECT FROM WHERE, ORDER BY.


Group Tasks:
- Student 1: Writes a query to retrieve students older than 14.
- Student 2: Writes a query to list students in descending order of marks.
- Student 3: Writes a query to display students from a specific grade, sorted alphabetically.

Week 4: Aggregate Functions & Report Generation

Concepts Covered: SUM(), COUNT(), final project documentation.


Group Tasks:
- Student 1: Writes a query to count the total number of students.
- Student 2: Writes a query to find the total marks obtained by all students.
- Student 3: Writes a query to find the average marks of students and compiles the final report.
Final Submission:

1. SQL script (.sql file) with:


- Table creation
- Data insertion
- All queries
2. Report Document explaining:
- Database structure
- Purpose of each query
- Sample query results
3. Presentation (Optional) - Groups may present their project in class.

Grading Criteria (100 points total):

Category Points Description


Database Structure 20 Proper table structure, primary keys, and data types.
Data Insertion 15 Correct use of INSERT INTO statements.
Queries (Filtering & Sorting) 25 Correct use of SELECT FROM WHERE, ORDER BY.
Aggregate Functions 20 Proper implementation of SUM(), COUNT().
Report & Documentation 10 Well-organized explanations and query results.
Teamwork & Participation 10 Each student actively contributes.

Rules & Guidelines:

- All three students must contribute. Each student's role will be assessed based on their individual
tasks.
- Late submissions will result in point deductions.
- Plagiarism (copying directly from the internet) will result in zero marks.

You might also like