GE-DBMS 2024 Practice Questions PDF

10/20/24, 2:10 PM GE-DBMS 2024 GE-DBMS RefClassroom 1-Navathe.pdf 2024 Open Page 1 of 1,273 Stream Classwor...

10/20/24, 2:10 PM GE-DBMS 2024 GE-DBMS RefClassroom 1-Navathe.pdf 2024 Open Page 1 of 1,273 Stream Classwork People GE-DBMS 2024 rashmi yadav posted a new assignment: Queries 19-26 Due 23:59 Posted 17 Oct Assigned 19. Display the vacant seats for each society. 20. Increment Total Seats of each society by 10%. 21. Add the enrollment fees paid ('yes'/'No') field in the enrollment table. 22. Update date of enrollment of society id 'sl' to 2018-01-15', 's2' to the current date and 's3' to “2018-01-02'. 23. Create a view to keep track of society names with the total number of students enrolled in it. 24. Find student names enrolled in all the societies. 25. Count the number of societies with more than 5 students enrolled in it. 26. Add column Mobile number in student table with default value 9999999999’. Add class comment… rashmi yadav posted a new assignment: Queries 15-18 Due 13 Oct, 23:59 Posted 4 Oct Handed in 15 (a). Find names of all students who have enrolled in any society. (b). Find the society names in which at least one student has enrolled. 16. Find names of students who are enrolled in any of the three societies 'Debating', 'Dancing' and ‘Sashakt’. 17. Find society names such that its mentor has a name with 'Gupta' in it. 18. Find the society names in which the number of enrolled students is only 10% of its capacity. Page 1 / 1,273 https://classroom.google.com/u/0/c/NzA3MjQ0MzY1NTEw 1/5 10/20/24, 2:10 PM GE-DBMS 2024 Ref Add 1-Navathe.pdf class comment… Open Page 1 of 1,273 rashmi yadav posted a new assignment: Query 10-14 Due 29 Sept, 23:59 Posted 20 Sept Handed in 10. Find the name of the most popular society (on the basis of enrolled students) 11. Find the name of two least popular societies (on the basis of enrolled students) 12. Find the students names who are not enrolled in any society. 13. Find the students names enrolled in at least two societies. 14. Find society names in which maximum students are enrolled. 1 class comment Ayushi Gupta 29 Sept Ayushi Bsc botany hons 23/45041 Add class comment… rashmi yadav posted a new assignment: Inserting Records in T… Due 15 Sept, 12:01 Posted 6 Sept (Edited 14 Sept) Missing In the Student-Society database, insert at least 5 records in each table. 1 class comment PRIYANSH 15 Sept Priyansh nand 23/61002 Philosophy hons Add class comment… rashmi yadav posted a new assignment: Query 6-9 Due 15 Sept, 23:59 Posted 6 Sept (Edited 14 Sept) Page / 1,273 Handed in https://classroom.google.com/u/0/c/NzA3MjQ0MzY1NTEw 2/5 10/20/24, 2:10 PM GE-DBMS 2024 Q6. Find society details with more than N TotalSeats where N is to be input by the user Q7. Update Ref society table for the mentor name of a specific 1-Navathe.pdf Open society Q8. Find society names in which more than five students have enrolled Q9. Find the name of the youngest student enrolled in society 'NSS'. Page 1 of 1,273 1 class comment Ayushi Gupta 15 Sept Bsc botany hons 23/45041 Add class comment… rashmi yadav posted a new assignment: Query 1-5 Due 15 Sept, 12:01 Posted 6 Sept (Edited 14 Sept) Missing Q1. Retrieve names of students enrolled in any society. Q2. Retrieve all society names. Q3. Retrieve student's names starting with the letter 'A'. Q4. Retrieve student's details studying in course 'Computer Science' or 'Chemistry'. Q5. Retrieve student's names who roll number starts with 'X' or 'Z' and ends with '9'. 1 class comment PRIYANSH 15 Sept Priyansh nand 23/61002 Philosophy hons Add class comment… rashmi yadav posted a new assignment: Creating Database Due 15 Sept, 12:01 Posted 6 Sept (Edited 14 Sept) Missing Create and use the following student-society database schema for a college. STUDENT Roll No Char(6) StudentName Varchar(20) Course Varchar(10) DOB Date SOCIETY Page / 1,273 https://classroom.google.com/u/0/c/NzA3MjQ0MzY1NTEw 3/5 10/20/24, 2:10 PM GE-DBMS 2024 SocID Char(6) SocNameRefVarchar(20) 1-Navathe.pdf Open MentorName Varchar(15)TotalSeats Unsigned int Page 1 of 1,273 ENROLLMENT Roll No Char(6) SID Char(6) DateOfEnrollment Date Here Rollno (ENROLLMENT) and SID (ENROLLMENT) are foreign keys 2 class comments PRIYANSH 15 Sept Priyansh nand 23/61002 Philosophy hons Add class comment… rashmi yadav posted a new material: Reference 3- Murach J. Murach's MySQL… Posted 20 Aug Ref 3-Murach.pdf PDF Add class comment… rashmi yadav posted a new material: Reference 1- Elmasri, R., Navathe, B. S. F… Posted 20 Aug Ref 1-Navathe.pdf PDF Add class comment… Page / 1,273 https://classroom.google.com/u/0/c/NzA3MjQ0MzY1NTEw 4/5 10/20/24, 2:10 PM GE-DBMS 2024 Refrashmi 1-Navathe.pdf Open yadav posted a new material: Guidelines Page 1 of 1,273 Posted 20 Aug Guidelines.pdf PDF Add class comment… Page / 1,273 https://classroom.google.com/u/0/c/NzA3MjQ0MzY1NTEw 5/5