Scribd
Upload
4 views

Grade10_SQL_Group_Project

The Grade 10 SQL Group Project involves creating a Library Management System database in groups of three, focusing on advanced SQL concepts over a four-week timeline. Each week covers specific tasks such as database structure, data insertion, joining tables, and using aggregate functions, with defined roles for each student. The final submission includes an SQL script, a report document, and an optional presentation, with grading criteria based on various aspects of the project.

Uploaded by

masalayyan
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
4 views

Grade10_SQL_Group_Project

The Grade 10 SQL Group Project involves creating a Library Management System database in groups of three, focusing on advanced SQL concepts over a four-week timeline. Each week covers specific tasks such as database structure, data insertion, joining tables, and using aggregate functions, with defined roles for each student. The final submission includes an SQL script, a report document, and an optional presentation, with grading criteria based on various aspects of the project.

Uploaded by

masalayyan
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
You are on page 1/ 2

Grade 10 SQL Group Project: Library Management System

Objective:

Students will work in groups of three to create a database for a library system. They will learn
advanced SQL concepts, including filtering data, renaming fields, joining tables, and using
aggregate functions. Each student will have a specific role to ensure active participation.

Project Timeline (4 Weeks):

Week 1: Database Structure & Table Creation

Concepts Covered: Table creation, primary keys, foreign keys, data types.
Group Tasks:
- Student 1: Creates the database (LibraryDB) and defines tables (Books, Members,
BorrowedBooks).
- Student 2: Ensures relationships between tables using primary and foreign keys.
- Student 3: Documents the database structure and data types.

Week 2: Data Insertion & Basic Queries

Concepts Covered: SELECT FROM WHERE, BETWEEN, ORDER BY, LIMIT.


Group Tasks:
- Student 1: Inserts at least 10 records into each table.
- Student 2: Writes queries to retrieve books published between two years using BETWEEN.
- Student 3: Writes queries to list books alphabetically and fetch the top 5 latest books using
LIMIT.

Week 3: Renaming Fields & Joining Tables

Concepts Covered: AS (aliasing), JOIN (inner join, left join).


Group Tasks:
- Student 1: Renames column headers in query results for clarity using AS.
- Student 2: Joins BorrowedBooks and Members tables to display which members borrowed
books.
- Student 3: Joins Books and BorrowedBooks tables to show book titles along with borrower
names.

Week 4: Aggregate Functions & Data Grouping

Concepts Covered: COUNT(), GROUP BY, HAVING.


Group Tasks:
- Student 1: Counts how many books are borrowed in total.
- Student 2: Groups books by category and counts how many books exist in each category using
GROUP BY.
- Student 3: Filters book categories with more than 5 books using HAVING.

Final Submission:

1. SQL script (.sql file) with:


- Table creation
- Data insertion
- Queries using filtering, ordering, joins, and aggregation
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 and foreign keys.
Data Insertion 15 Correct use of INSERT INTO statements.
Filtering & Ordering 15 Proper use of WHERE, BETWEEN, ORDER BY, LIMIT.
Joins & Renaming 20 Correct implementation of AS and JOIN.
Grouping & Aggregates 20 Use of COUNT(), GROUP BY, HAVING.
Report & Documentation 10 Well-organized explanations and query results.

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