Scribd
Upload
195 views5 pages

Student Data Management System

The document outlines the creation of two database tables: 'Student' for storing student details and 'Fees' for tracking fee payments in installments. It includes SQL commands for inserting sample data into both tables, as well as instructions for creating forms and reports related to student and fee information. Additionally, it provides SQL queries for displaying data in a specific order and removing students from class 12.

Uploaded by

sahusheersh93
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
195 views5 pages

Student Data Management System

The document outlines the creation of two database tables: 'Student' for storing student details and 'Fees' for tracking fee payments in installments. It includes SQL commands for inserting sample data into both tables, as well as instructions for creating forms and reports related to student and fee information. Additionally, it provides SQL queries for displaying data in a specific order and removing students from class 12.

Uploaded by

sahusheersh93
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

1.

Student Table: for storing student details with class

CREATE TABLE Student (

StudentID INT PRIMARY KEY,

StudentName VARCHAR(50),

Class INT,

DateOfBirth DATE,

Address VARCHAR(100)

);

INSERT INTO Student (StudentID, StudentName, Class, DateOfBirth, Address) VALUES

(1, 'Ravi Kumar', 10, '2005-06-15', '123 DEF Avenue'),

(2, 'Nisha Sharma', 12, '2003-08-20', '456 GHI Boulevard'),

(3, 'Aakash Verma', 11, '2004-04-25', '789 JKL Road');

2. Fees Table : for storing fees deposit by student in 3 installment


CREATE TABLE Fees (
FeeID INT PRIMARY KEY,
StudentID INT,
InstallmentNo INT,
Amount DECIMAL(10, 2),

PaymentDate DATE,
FOREIGN KEY (StudentID) REFERENCES Student(StudentID)
);
INSERT INTO Fees (FeeID, StudentID, InstallmentNo, Amount, PaymentDate) VALUES
(1, 1, 1, 3500, '2025-01-03'),

(2, 1, 2, 3500, '2025-02-03'),


(3, 1, 3, 3500, '2025-03-03'),
(4, 2, 1, 4500, '2025-01-07'),
(5, 2, 2, 4500, '2025-02-07'),

Page 1|5
(6, 2, 3, 4500, '2025-03-07'),
(7, 3, 1, 4000, '2025-01-12'),
(8, 3, 2, 4000, '2025-02-12'),

(9, 3, 3, 4000, '2025-03-12');

1. Student Table: for storing student details with class

2. Fees Table : for storing fees deposit by student in 3 installment

Page 2|5
3. Create a form to storing data in student table.

4. Create a form to store data in fees table with valid student.

Page 3|5
5. Create a report to display student details class wise.

6. Create a report to display daily fees collection

7. Create a report display student data with fees deposited by student

Page 4|5
8. Write a query to display data arranged class wise and name wise.

SELECT * FROM Student


ORDER BY Class, StudentName;

9. Write a query to remove data for class 12 students.

DELETE FROM Student


WHERE Class = 12;

Page 5|5

You might also like