LMS_Inserting_data_into_tables.sql

-- Inserting of data started

-- Inserting data into students table

INSERT INTO students (first_name, last_name, email) VALUES
('Aarav', 'Sharma', 'aarav.sharma@example.com'),
('Vihaan', 'Iyer', 'vihaan.iyer@example.com'),
('Aadhya', 'Verma', 'aadhya.verma@example.com'),
('Anaya', 'Patel', 'anaya.patel@example.com'),
('Sai', 'Nair', 'sai.nair@example.com'),
('Riya', 'Gupta', 'riya.gupta@example.com'),
('Ishaan', 'Kumar', 'ishaan.kumar@example.com'),
('Saanvi', 'Singh', 'saanvi.singh@example.com'),
('Reyansh', 'Mehta', 'reyansh.mehta@example.com'),
('Dhruv', 'Reddy', 'dhruv.reddy@example.com'),
('Pooja', 'Chopra', 'pooja.chopra@example.com'),
('Neha', 'Bhatia', 'neha.bhatia@example.com'),
('Kiran', 'Khan', 'kiran.khan@example.com'),
('Arjun', 'Nanda', 'arjun.nanda@example.com'),
('Siddharth', 'Yadav', 'siddharth.yadav@example.com'),
('Tanvi', 'Awasthi', 'tanvi.awasthi@example.com'),
('Nisha', 'Rao', 'nisha.rao@example.com'),
('Aarohi', 'Sethi', 'aarohi.sethi@example.com'),
('Kabir', 'Joshi', 'kabir.joshi@example.com'),
('Rohit', 'Desai', 'rohit.desai@example.com'),
('Kavya', 'Bansal', 'kavya.bansal@example.com'),
('Riyaan', 'Chaudhary', 'riyaan.chaudhary@example.com'),
('Maya', 'Verma', 'maya.verma@example.com'),
('Ayaan', 'Kumar', 'ayaan.kumar@example.com'),
('Simran', 'Jain', 'simran.jain@example.com'),
('Shivam', 'Ahuja', 'shivam.ahuja@example.com'),
('Priya', 'Shukla', 'priya.shukla@example.com'),
('Dev', 'Nair', 'dev.nair@example.com'),
('Sofia', 'Ali', 'sofia.ali@example.com'),
('Avani', 'Saini', 'avani.saini@example.com'),
('Yash', 'Gandhi', 'yash.gandhi@example.com'),
('Vaishali', 'Thakur', 'vaishali.thakur@example.com'),
('Zara', 'Mirza', 'zara.mirza@example.com'),
('Akash', 'Pandey', 'akash.pandey@example.com'),
('Aditi', 'Kaur', 'aditi.kaur@example.com'),
('Krishna', 'Bhatia', 'krishna.bhatia@example.com'),
('Vanya', 'Mehta', 'vanya.mehta@example.com'),
('Advik', 'Khanna', 'advik.khanna@example.com'),
('Saraswati', 'Mishra', 'saraswati.mishra@example.com'),
('Aashvi', 'Saha', 'aashvi.saha@example.com'),
('Om', 'Ghosh', 'om.ghosh@example.com'),
('Vikram', 'Rana', 'vikram.rana@example.com'),
('Lakshmi', 'Ravi', 'lakshmi.ravi@example.com'),
('Devansh', 'Malhotra', 'devansh.malhotra@example.com'),
('Niranjan', 'Dutta', 'niranjan.dutta@example.com'),
('Krisha', 'Ghosh', 'krisha.ghosh@example.com'),
('Arnav', 'Chatterjee', 'arnav.chatterjee@example.com'),
('Mohan', 'Kumar', 'mohan.kumar@example.com'),
('Aditi', 'Sen', 'aditi.sen@example.com'),
('Ravi', 'Kapoor', 'ravi.kapoor@example.com'),
('Suhana', 'Lal', 'suhana.lal@example.com'),
('Anvi', 'Choudhury', 'anvi.choudhury@example.com'),
('Ira', 'Choudhary', 'ira.choudhary@example.com'),
('Akira', 'Reddy', 'akira.reddy@example.com');

-- Inserting data into students table finished
-- Inserting data into instructors table

INSERT INTO instructors (first_name, last_name, specialization) VALUES
('Ravi', 'Sharma', 'Mathematics'),
('Hikaru', 'Tanaka', 'Physics'),
('Aishwarya', 'Patel', 'Computer Science'),
('Elena', 'Ivanova', 'Biology'),
('Sofia', 'Kumar', 'Chemistry'),
('Kenji', 'Sato', 'History'),
('James', 'Smith', 'Literature'),
('Priya', 'Verma', 'Economics'),
('Igor', 'Petrov', 'Geography'),
('Akiko', 'Yamamoto', 'Art');

-- Inserting data into instructors table finished
-- Inserting data into courses table

INSERT INTO courses (title, course_description, duration_in_minutes, instructor_id) VALUES
('Introduction to Painting', 'A beginner course on the fundamentals of painting.', 120, 1),
('Python Programming Basics', 'Learn the basics of Python programming.', 150, 2),
('Meditation for Beginners', 'An introduction to meditation techniques.', 60, 3),
('Advanced Digital Art', 'Explore advanced techniques in digital art creation.', 180, 4),
('JavaScript Essentials', 'Essential JavaScript for web development.', 120, NULL),
('Mindfulness Meditation', 'Learn mindfulness techniques to reduce stress.', 90, 5),
('Graphic Design Fundamentals', 'Understanding the principles of graphic design.', 150, 6),
('Introduction to Data Structures', 'Learn about data structures in programming.', 180, NULL),
('Art Therapy Techniques', 'Using art for therapeutic purposes.', 120, 7),
('Meditative Practices for Everyday Life', 'Incorporating meditation into daily routines.', 90, NULL),
('Web Development with HTML & CSS', 'Learn to create beautiful web pages.', 150, 8),
('Creativity Boosting Techniques', 'Techniques to enhance creativity in art and life.', 90, NULL);

-- Inserting data into courses table finished
-- Inserting data into enrollments table

INSERT INTO Enrollments (student_id, course_id, enrollment_date) VALUES
(5, 1, '2022-03-15'),
(12, 3, '2022-04-20'),
(19, 2, '2022-05-10'),
(7, 4, '2022-06-05'),
(9, 5, '2022-07-12'),
(11, 1, '2022-08-18'),
(23, 6, '2022-09-25'),
(2, 7, '2022-10-30'),
(15, 8, '2022-11-11'),
(27, 12, '2022-12-16'),
(22, 2, '2023-01-22'),
(14, 5, '2023-02-15'),
(1, 1, '2023-03-10'),
(30, 8, '2023-04-17'),
(6, 4, '2023-05-23'),
(28, 10, '2023-06-30'),
(3, 3, '2023-07-14'),
(35, 12, '2023-08-20'),
(8, 1, '2023-09-05'),
(16, 2, '2023-10-11'),
(26, 3, '2023-11-17'),
(13, 4, '2023-12-22'),
(24, 9, '2022-01-10'),
(25, 11, '2022-02-20'),
(4, 1, '2022-03-30'),
(29, 5, '2022-04-25'),
(32, 8, '2022-05-15'),
(10, 7, '2022-06-10'),
(18, 2, '2022-07-28'),
(33, 6, '2022-08-12'),
(20, 4, '2023-01-05'),
(17, 8, '2023-02-12'),
(36, 11, '2023-03-15'),
(21, 10, '2023-04-20'),
(15, 7, '2023-05-18'),
(11, 12, '2023-06-25'),
(38, 9, '2023-07-30'),
(39, 6, '2023-08-14'),
(40, 5, '2023-09-05'),
(31, 4, '2023-10-22'),
(41, 3, '2023-11-17'),
(42, 2, '2023-12-12'),
(34, 8, '2022-01-05'),
(43, 1, '2022-02-25'),
(44, 3, '2022-03-30'),
(45, 12, '2022-04-20'),
(46, 6, '2022-05-15'),
(47, 5, '2022-06-10'),
(48, 7, '2022-07-15'),
(49, 11, '2023-02-10'),
(50, 3, '2023-03-20'),
(51, 4, '2023-04-18'),
(52, 5, '2023-05-25'),
(53, 8, '2023-06-30'),
(54, 9, '2023-07-28'),
(14, 10, '2023-08-12'),
(3, 11, '2023-09-15'),
(1, 12, '2023-10-22'),
(2, 4, '2023-11-17'),
(5, 6, '2023-12-12'),
(17, 2, '2023-01-10'),
(22, 11, '2023-02-25'),
(28, 5, '2023-03-30'),
(13, 3, '2023-04-20'),
(19, 10, '2023-05-15'),
(24, 9, '2023-06-10'),
(32, 8, '2023-07-15'),
(27, 4, '2023-08-12'),
(8, 1, '2023-09-05'),
(9, 12, '2023-10-30'),
(10, 2, '2023-11-15'),
(11, 3, '2023-12-25'),
(12, 6, '2023-01-15'),
(14, 4, '2023-02-12'),
(15, 11, '2023-03-22'),
(16, 5, '2023-04-18'),
(18, 2, '2023-05-10'),
(20, 7, '2023-06-30'),
(21, 8, '2023-07-22'),
(23, 1, '2023-08-28'),
(29, 9, '2023-09-15'),
(30, 10, '2023-10-01'),
(31, 11, '2023-11-15'),
(33, 12, '2023-12-15'),
(34, 6, '2023-01-30'),
(36, 4, '2023-02-18'),
(37, 5, '2023-03-01'),
(38, 2, '2023-04-01'),
(39, 3, '2023-05-05'),
(40, 8, '2023-06-25'),
(41, 1, '2023-07-15'),
(42, 7, '2023-08-10'),
(43, 9, '2023-09-05'),
(44, 10, '2023-10-30'),
(45, 12, '2023-11-15'),
(46, 2, '2023-12-12'),
(47, 3, '2023-01-05'),
(48, 6, '2023-02-25'),
(49, 4, '2023-03-30'),
(50, 5, '2023-04-20'),
(51, 8, '2023-05-15'),
(52, 1, '2023-06-10'),
(53, 3, '2023-07-28'),
(54, 10, '2023-08-12'),
(7, 11, '2023-09-20'),
(9, 2, '2023-10-22'),
(10, 6, '2023-11-17'),
(12, 5, '2023-12-12'),
(3, 4, '2023-01-10'),
(8, 3, '2023-02-20'),
(14, 1, '2023-03-15'),
(19, 8, '2023-04-18'),
(22, 7, '2023-05-22'),
(29, 9, '2023-06-30'),
(1, 2, '2023-07-15'),
(15, 4, '2023-08-12'),
(2, 10, '2023-09-05'),
(6, 11, '2023-10-11'),
(13, 12, '2023-11-17'),
(3, 1, '2023-12-30');

-- Inserting data into enrollments table finished
-- Inserting data into feedback table

INSERT INTO Feedback (course_id, student_id, comment, rating) VALUES
(1, 5, 'Great course! Learned a lot.', 5),
(3, 12, 'Informative and well-structured.', 4),
(2, 19, 'The content was helpful, but it could be improved.', 3),
(4, 7, 'Enjoyed the classes!', 5),
(5, 9, 'Could use more examples.', 3),
(1, 11, 'Excellent course!', 5),
(6, 23, 'Good material, but the pace was slow.', 4),
(7, 2, 'Interesting course!', 4),
(8, 15, 'The instructor was very engaging.', 5),
(12, 27, 'Loved the practical sessions!', 5),
(2, 22, 'Overall good, but some topics were rushed.', 3),
(5, 14, 'The assignments were challenging but useful.', 4),
(1, 1, 'Fantastic experience!', 5),
(8, 30, 'I learned a lot from this course.', 4),
(4, 6, 'Good course but could be more detailed.', 3),
(10, 28, 'Great content and delivery.', 5),
(3, 3, 'Very helpful feedback on assignments.', 4),
(12, 35, 'Well organized and clear.', 5),
(11, 8, 'Content was great, but the quizzes were tough.', 3),
(2, 16, 'Good course material.', 4),
(4, 26, 'Could use more interactive elements.', 3),
(3, 13, 'Very informative, but too theoretical.', 3),
(10, 24, 'Loved the group activities.', 5),
(9, 25, 'Not what I expected.', 2),
(5, 41, 'It was a good overview of the topic.', 4),
(6, 30, 'Helped me improve my skills!', 5),
(7, 38, 'Interesting topics but need more examples.', 3),
(9, 18, 'Great course but too many assignments.', 3),
(8, 37, 'I really enjoyed the hands-on projects.', 5),
(12, 29, 'I learned a lot, thank you!', 4),
(1, 33, 'The course exceeded my expectations!', 5),
(2, 4, 'Too long and detailed for a beginner.', 2);

-- Inserting data into feedback table finished
-- Inserting data into assignments 

INSERT INTO Assignments (course_id, title, description, due_date) VALUES
(1, 'Assignment 1 for Art Basics', 'Create a simple artwork using basic shapes.', '2022-05-01'),
(1, 'Assignment 2 for Art Basics', 'Write an essay on your favorite artist.', '2022-05-15'),
(1, 'Assignment 3 for Art Basics', 'Submit a color theory project.', '2022-06-01'),

(2, 'Assignment 1 for Python Fundamentals', 'Complete the Python basics tutorial.', '2022-04-15'),
(2, 'Assignment 2 for Python Fundamentals', 'Create a simple calculator app.', '2022-05-10'),
(2, 'Assignment 3 for Python Fundamentals', 'Submit a project on data types.', '2022-06-10'),

(3, 'Assignment 1 for Meditation Techniques', 'Write a reflection on your meditation experience.', '2022-06-15'),
(3, 'Assignment 2 for Meditation Techniques', 'Practice and document 5 different techniques.', '2022-07-01'),
(3, 'Assignment 3 for Meditation Techniques', 'Create a meditation guide.', '2022-07-15'),

(4, 'Assignment 1 for Advanced Drawing', 'Draw a still life from observation.', '2022-08-01'),
(4, 'Assignment 2 for Advanced Drawing', 'Create a self-portrait.', '2022-08-15'),
(4, 'Assignment 3 for Advanced Drawing', 'Submit a perspective drawing.', '2022-09-01'),

(5, 'Assignment 1 for Web Development Basics', 'Build a simple webpage using HTML.', '2022-05-20'),
(5, 'Assignment 2 for Web Development Basics', 'Create a CSS stylesheet for your webpage.', '2022-06-05'),
(5, 'Assignment 3 for Web Development Basics', 'Implement JavaScript interactivity.', '2022-06-20'),

(6, 'Assignment 1 for Graphic Design', 'Design a logo for a fictional company.', '2022-07-01'),
(6, 'Assignment 2 for Graphic Design', 'Create a poster for a community event.', '2022-07-15'),
(6, 'Assignment 3 for Graphic Design', 'Submit a branding guide.', '2022-08-01'),

(7, 'Assignment 1 for Java Programming', 'Write a Java program that prints "Hello, World!"', '2022-08-20'),
(7, 'Assignment 2 for Java Programming', 'Develop a simple Java application for user input.', '2022-09-05'),
(7, 'Assignment 3 for Java Programming', 'Create a mini-project using Java.', '2022-09-15'),

(8, 'Assignment 1 for Creative Writing', 'Write a short story based on a prompt.', '2022-06-10'),
(8, 'Assignment 2 for Creative Writing', 'Submit a poem you wrote.', '2022-06-20'),
(8, 'Assignment 3 for Creative Writing', 'Participate in a writing workshop.', '2022-07-05'),

(9, 'Assignment 1 for Photography Basics', 'Submit three photographs of different subjects.', '2022-06-25'),
(9, 'Assignment 2 for Photography Basics', 'Write a reflection on your photography style.', '2022-07-10'),
(9, 'Assignment 3 for Photography Basics', 'Create a photo essay.', '2022-07-25'),

(10, 'Assignment 1 for Data Science 101', 'Analyze a dataset and present findings.', '2022-08-15'),
(10, 'Assignment 2 for Data Science 101', 'Create a visualization for your analysis.', '2022-08-30'),
(10, 'Assignment 3 for Data Science 101', 'Write a report on your project.', '2022-09-15'),

(11, 'Assignment 1 for Mindfulness Practices', 'Practice mindfulness for a week and journal your experience.', '2022-08-20'),
(11, 'Assignment 2 for Mindfulness Practices', 'Create a mindfulness plan.', '2022-09-05'),
(11, 'Assignment 3 for Mindfulness Practices', 'Submit a video discussing your insights.', '2022-09-15'),

(12, 'Assignment 1 for Advanced Programming', 'Implement a project with advanced algorithms.', '2022-09-01'),
(12, 'Assignment 2 for Advanced Programming', 'Debug and optimize an existing codebase.', '2022-09-15'),
(12, 'Assignment 3 for Advanced Programming', 'Prepare a presentation on your project.', '2022-09-30');

-- Inserting data into assignments  finished
-- Inserting data into grades

INSERT INTO Grades (assignment_id, student_id, grade) VALUES
(1, 5, 'A'),
(1, 12, 'B'),
(1, 19, 'A'),
(1, 7, 'C'),
(1, 9, 'B'),
(1, 11, 'A'),
(1, 23, 'A'),
(1, 2, 'B'),
(1, 15, 'A'),
(1, 27, 'A'),
(2, 5, 'C'),
(2, 12, 'B'),
(2, 19, 'A'),
(2, 7, 'C'),
(2, 9, 'B'),
(2, 11, 'A'),
(2, 23, 'A'),
(2, 2, 'B'),
(2, 15, 'C'),
(2, 27, 'A'),
(3, 5, 'A'),
(3, 12, 'A'),
(3, 19, 'C'),
(3, 7, 'B'),
(3, 9, 'B'),
(3, 11, 'A'),
(3, 23, 'A'),
(3, 2, 'B'),
(3, 15, 'A'),
(3, 27, 'A'),
(4, 5, 'B'),
(4, 12, 'A'),
(4, 19, 'B'),
(4, 7, 'C'),
(4, 9, 'A'),
(4, 11, 'A'),
(4, 23, 'B'),
(4, 2, 'A'),
(4, 15, 'B'),
(4, 27, 'C'),
(5, 5, 'A'),
(5, 12, 'C'),
(5, 19, 'B'),
(5, 7, 'B'),
(5, 9, 'A'),
(5, 11, 'C'),
(5, 23, 'A'),
(5, 2, 'B'),
(5, 15, 'A'),
(5, 27, 'B'),
(6, 5, 'B'),
(6, 12, 'A'),
(6, 19, 'C'),
(6, 7, 'A'),
(6, 9, 'B'),
(6, 11, 'A'),
(6, 23, 'A'),
(6, 2, 'B'),
(6, 15, 'A'),
(6, 27, 'A'),
(7, 5, 'C'),
(7, 12, 'B'),
(7, 19, 'A'),
(7, 7, 'B'),
(7, 9, 'C'),
(7, 11, 'A'),
(7, 23, 'B'),
(7, 2, 'C'),
(7, 15, 'A'),
(7, 27, 'B'),
(8, 5, 'B'),
(8, 12, 'A'),
(8, 19, 'C'),
(8, 7, 'B'),
(8, 9, 'B'),
(8, 11, 'A'),
(8, 23, 'A'),
(8, 2, 'B'),
(8, 15, 'C'),
(8, 27, 'A'),
(9, 5, 'A'),
(9, 12, 'B'),
(9, 19, 'A'),
(9, 7, 'C'),
(9, 9, 'B'),
(9, 11, 'A'),
(9, 23, 'C'),
(9, 2, 'A'),
(9, 15, 'A'),
(9, 27, 'B'),
(10, 5, 'A'),
(10, 12, 'C'),
(10, 19, 'B'),
(10, 7, 'B'),
(10, 9, 'A'),
(10, 11, 'C'),
(10, 23, 'A'),
(10, 2, 'B'),
(10, 15, 'A'),
(10, 27, 'B'),
(11, 5, 'A'),
(11, 12, 'B'),
(11, 19, 'A'),
(11, 7, 'C'),
(11, 9, 'B'),
(11, 11, 'A'),
(11, 23, 'A'),
(11, 2, 'B'),
(11, 15, 'C'),
(11, 27, 'A'),
(12, 5, 'B'),
(12, 12, 'A'),
(12, 19, 'C'),
(12, 7, 'B'),
(12, 9, 'A'),
(12, 11, 'C'),
(12, 23, 'A'),
(12, 2, 'B'),
(12, 15, 'A'),
(12, 27, 'B');

-- Inserting data into grades finished

-- Inserting of data is finished