Skip to main content

Posts

GRADE XII - MYSQL JOIN QUERY ASSIGNMENT

  MYSQL JOINS Given Tables Student(RollNo, Name, Class) Marks(RollNo, Subject, Marks) Questions 1. Write a query using Equi Join to display Student Name and Marks. 2. Write a query using Equi Join to display all columns from both tables where RollNo matches. 3. Write a query using NATURAL JOIN to display all matching records. 4. Write a query using NATURAL JOIN to display Name, Subject, and Marks. 5. Write a query to display all possible combinations of Student and Marks using Cartesian Product. 6. Write a query using Cartesian Product with WHERE condition to display only matching RollNo records. 7. Identify the type of JOIN used in: SELECT * FROM Student, Marks; 8. Predict the number of rows returned by: SELECT * FROM Student, Marks; 9. Write a query using Equi Join to display names of students who have marks greater than 85. 10. Write a query using NATURAL JOIN to display records of Class 12 students only. 11. Write a query using Equi Join to display RollNo, Name, and Subject. 12...
Post a Comment
Read more
Recent posts

GRADE XI | DESIGN THINKING & INNOVATION (848) | INTRODUCTION NOTES

  DESIGN THINKING &  INNOVATION (848)  INTRODUCTION LINK : INTRODUCTION PPT PPT LINK Notes: Design Thinking and Innovation Grade XI Introduction Section   I. What is Design? (0.1.1) Definitions from Experts: John Maeda: "Design is solution to a problem". Saul Bass: "Design is thinking made visual". Charles Eames:   “Design is a plan for arranging elements in such a way as best to accomplish a particular purpose.” Steve Jobs:  "Design is not just what it looks like and feels like. Design is how it works". Prof. Sudhakar Nadkarni:  "Essentials of design are— purity, precision, details". Design is a way of understanding needs, identifying problems, and creating appropriate and innovative solutions. It is not only about appearance, but also about usefulness and sustainability. Design is explained as something that helps solve problems and make a positive difference. Key ...
Post a Comment
Read more

PANDAS SERIES - 16 /3/26

  PRACTICE QUESTIONS Pandas Series – Practice Questions 1. Write a program to create a Pandas Series containing English alphabets from ‘a’ to ‘z’ and display it. 2. Write a statement to display the alphabets ‘e’ to ‘p’ from the Series EngAlph. 3. Write a statement to display the first 10 values from the Series EngAlph. 4. Write a program to create a Series named 'vow' containing vowels (‘a’, ‘e’, ‘i’, ‘o’, ‘u’) with initial value 0 and display it. 5. Write a statement to set all the values of the Series 'vow' to 10 and display the updated Series. 6. Write a statement to divide all values of the Series 'vow' by 2. 7. Create another Series 'vow1' having 5 elements with index labels ‘a’, ‘e’, ‘i’, ‘o’, ‘u’ and values [2,5,6,3,8] respectively. 8. Write a program to add two Series 'vow' and 'vow1' and store the result in a new Series 'vow3'. 9. Write statements to perform subtraction, multiplication and division betwe...
Post a Comment
Read more

STACK ASSIGNMENT | 24TH OCT

  STACK ASSIGNMENT QUE 1: [1] A ____________ is a way to store, organize, or manage data in efficient and productive manner. [2] A stack is one of the following types of data structure? a) Linear  b) Dynamic c) Circular d) All of these [3] Stack data structure is following ____________ principle. [4] In stack data can be inserted or deleted from ____________ only. [5] The insert operation in the stack is known as pop. (True/False) [6] You can replace any element position in the stack. (True/False) [7] The peek operation refers to accessing/inspecting the top element in the stack. (True/False) [8] A condition raise due to the stack is full is known as ___________. a) Underflow  b) Overflow  c) List is full d) Completely Filled [9] While popping the element from the stack, a condition will be raised, this condition is known as ____________. a) Underflow b) Overflow c) List is Empty d) Blank List [10] Stack overflow condition is raised i...
Post a Comment
Read more

Grade XII - CS - Menu-Driven Stack Code | 14-10-25

  PYTHON STACKS LINK :  PYTHON STACKS - NOTES Menu-Driven Stack Program # -*- coding: utf-8 -*- """ Created on Sun Oct 12 17:19:01 2025 @author: Kirti Hora """ ''' Menu-Driven Stack Program 1.PUSH 2.POP 3.DISPLAY 4. DISPLAY EVEN ''' def push(stack):     elements = input("Enter elements to push (separated by spaces): ").split()     for item in elements:         n = int(item)         stack.append(n)         print("Element pushed:", n)     print("Current Stack:", stack) def pop(stack):     if len(stack) == 0:         print("Stack Underflow! Stack is empty.")     else:         n = stack.pop()         print("Deleted Element:", n) def disp(stack):     if len(stack) == 0:         print("Stack Underflow! Stack is empty.")     else:         print("Stack elemen...
Post a Comment
Read more