-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy path02_seed_data.sql
More file actions
83 lines (50 loc) · 3.57 KB
/
Copy path02_seed_data.sql
File metadata and controls
83 lines (50 loc) · 3.57 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
-- =============================================
-- FEE MANAGEMENT SYSTEM - SEED DATA
-- =============================================
-- Inserts demonstration data for:
-- 1. 25 students
-- 2. 3 administrators
--
-- StudentID is an IDENTITY column, so it is not
-- explicitly inserted.
-- =============================================
-- 1. DEMONSTRATION STUDENT RECORDS
INSERT INTO Students
(Name, Email, Course, TotalFee, PaidAmount, DueDate)
VALUES
('Aarav Sharma', 'student01@feemanagementdemo.com', 'Information Technology', 120000.00, 120000.00, '2026-08-15'),
('Riya Patel', 'student02@feemanagementdemo.com', 'Computer Engineering', 115000.00, 75000.00, '2026-09-30'),
('Aditya Kumar', 'student03@feemanagementdemo.com', 'Electronics Engineering', 110000.00, 110000.00, '2026-08-20'),
('Sneha Deshmukh', 'student04@feemanagementdemo.com', 'Information Technology', 125000.00, 50000.00, '2026-08-31'),
('Rahul Verma', 'student05@feemanagementdemo.com', 'Computer Science', 130000.00, 0.00, '2026-09-25'),
('Priya Mehta', 'student06@feemanagementdemo.com', 'Artificial Intelligence', 140000.00, 140000.00, '2026-08-10'),
('Arjun Singh', 'student07@feemanagementdemo.com', 'Information Technology', 120000.00, 60000.00, '2026-08-25'),
('Ananya Joshi', 'student08@feemanagementdemo.com', 'Computer Engineering', 115000.00, 115000.00, '2026-09-05'),
('Vivek Nair', 'student09@feemanagementdemo.com', 'Mechanical Engineering', 100000.00, 40000.00, '2026-10-15'),
('Kavya Iyer', 'student10@feemanagementdemo.com', 'Information Technology', 125000.00, 0.00, '2026-08-30'),
('Rohan Gupta', 'student11@feemanagementdemo.com', 'Computer Science', 130000.00, 90000.00, '2026-09-20'),
('Ishita Shah', 'student12@feemanagementdemo.com', 'Electronics Engineering', 110000.00, 110000.00, '2026-08-18'),
('Kunal Mishra', 'student13@feemanagementdemo.com', 'Information Technology', 120000.00, 30000.00, '2026-09-10'),
('Neha Kulkarni', 'student14@feemanagementdemo.com', 'Computer Engineering', 115000.00, 50000.00, '2026-10-05'),
('Siddharth Rao', 'student15@feemanagementdemo.com', 'Artificial Intelligence', 140000.00, 70000.00, '2026-09-15'),
('Pooja Agarwal', 'student16@feemanagementdemo.com', 'Information Technology', 125000.00, 125000.00, '2026-08-12'),
('Manish Yadav', 'student17@feemanagementdemo.com', 'Computer Science', 130000.00, 0.00, '2026-08-28'),
('Simran Kaur', 'student18@feemanagementdemo.com', 'Data Science', 135000.00, 80000.00, '2026-10-20'),
('Akash Patil', 'student19@feemanagementdemo.com', 'Information Technology', 120000.00, 120000.00, '2026-09-01'),
('Tanvi Desai', 'student20@feemanagementdemo.com', 'Computer Engineering', 115000.00, 60000.00, '2026-09-12'),
('Yash Thakur', 'student21@feemanagementdemo.com', 'Cyber Security', 135000.00, 0.00, '2026-08-22'),
('Meera Kapoor', 'student22@feemanagementdemo.com', 'Information Technology', 125000.00, 90000.00, '2026-09-18'),
('Dev Malhotra', 'student23@feemanagementdemo.com', 'Artificial Intelligence', 140000.00, 140000.00, '2026-08-05'),
('Nikita Bansal', 'student24@feemanagementdemo.com', 'Data Science', 135000.00, 45000.00, '2026-08-29'),
('Harsh Vora', 'student25@feemanagementdemo.com', 'Computer Science', 130000.00, 65000.00, '2026-10-10');
-- 2. DEMONSTRATION ADMINISTRATOR RECORDS
INSERT INTO Administrators
(Name, Role)
VALUES
('System Administrator', 'ADMIN'),
('Finance Manager', 'ADMIN'),
('Fee Management Officer', 'ADMIN');
-- 3. VERIFY INSERTED ADMINISTRATORS
SELECT *
FROM Administrators
ORDER BY AdminID;