Create a table Infant and Solve the following queries………..
CLASS 12th IP Practical-3 Class 12th IP SOLUTION -> create database exam; -> use exam; -> create table infant ( item_code int primary key, item varchar(100) not null, DatePurchase date, UnitPrice int, Discount int); -> Insert query insert into infant values(101,’Frock’,’2016-01-23′,700,10); insert into infant values(102,’Cot’,’2015-09-23′,5000,25); insert into infant values(103,’Soft Toy’,’2016-06-17′,800,10); insert into infant values(104,’Baby Socks’,’2014-10-16′,100,7); […]
Write a Program to create a Pandas Matplotlib
CLASS 12th IP Practical-2 Class 12th IP SOLUTION import matplotlib.pyplot as plt import numpy as np # DATA student = [‘Mohit’,’Nishant’,’Sudha’] subjects = [‘Maths’,’Science’,’English’] marks = [ [100,100,60], [95,100,57], [85,95,96]] x = np.arange(len(subjects)) #[0,1,2] # Bar width bar_width = 0.25 # Creating a bar Chart plt.bar(x – bar_width,marks[0],width = bar_width , label=’Mohit’,color=’green’) plt.bar(x, marks[1] , […]
Question_Bank
Q.1 Write a program to Create a Series from Scalar Values. Q.2 Write a Program to Creation of Series from NumPy Arrays. Q.3 Write a program to Creation of Series from Dictionary  Q4 Write a Program to Accessing Elements of a Series.  Q.5 Write a program to create a series object using the […]
Create a DataFrame and Solve the following Queries in Python Pandas
CLASS 12th IP Practical-1 Class 12th IP SOLUTION import pandas as pd a = {‘Maths’:[100,95,85], ‘SCIENCE’:[90,50,90], ‘ENGLISH’:[85,90,65] } df = pd.DataFrame(a,index=[‘Mohit’,’Nishant’,’Sudha’]) print(df) print(“———————–1———————-“) print() df[‘total’]=df[‘Maths’] + df[‘SCIENCE’] + df[‘ENGLISH’] print(df) print(“——————-2——————–“) print() df.loc[‘Harish’]=[77,85,69,77+85+69] print(df) print(“————————3———————“) print() print(df[[‘Maths’,’SCIENCE’]]) print(“——————4——————-“) print() df.loc[‘Sudha’,’SCIENCE’]=85 print(df) print(“———————-5—————–“) print() df = df.drop(index=’Mohit’) print(df) Output
Unit 3 :- PL/SQL and conditional Statements
PL/sQL and conditional statement INDEX 3.1 Introduction to PL/SQL (Definition & Block Structure) 3.2 Variables, Constants and Data Type 3.3 Assigning Values to Variables 3.4 User Defined Record 3.5 Conditional Statements 3.5.1 IF…THEN statement 3.5.2 IF..Else statements 3.5.3 multiple conditions 3.5.4 Nested IF statements 3.5.5 CASE statements PL/sQL and conditional statement Introduction to PL/SQL PL/SQL […]
Unit-2 Advanced SQL
Unit-2 Advanced SQL SQL : A Brief Overview SQL (Structured Query Language) is a standard programming language used to interact with relational databases. It enables users to perform operations like creating, retrieving, updating, and managing data stored in database tables. SQL is essential for database management and widely used in software development, data analysis, and […]
Unit-1. Introduction of Relational model
Unit-1. Introduction of Relational model Introduction to the Relational Model The relational model is a fundamental concept in database management systems (DBMS). Introduced by Edgar F. Codd in 1970, the relational model organizes data into tables, called relations, making it easier to understand, query, and manage information. Key Concepts of the Relational Model 1. Relation […]
Oracle Practice Sheet 1
Oracle Practice Sheet 1 Oracle sheet 1 Overview  Practice Sheet 1 Create the table by using the above data and Solve the following Queries. To show information about the teachers of the history department. To list the names of teachers earning a salary between 20000 and 30000. To count the number of male teachers. […]
SEM 2 BCA
Try typing test
Typing Practice Typing Practice Test Time Remaining: 2:00 Start Test Submit