DBMS LAB

create table Branch1(Branchid int primary key, Bname varchar(10), HOD varchar(10));
Table created.
SQL> create table Student1(USN varchar(10)primary key, Name varchar(10), Address varchar(15),
Branchid int references Branch1(Branchid),Sem int);
Table created.
SQL> create table Author1(Authorid int primary key, Aname varchar(10),Country varchar(15), Age
int);
Table created.
SQL> create table Book1(Bookid varchar(10)primary key, Bname varchar(10),Authorid int references
Author1(Authorid),Publisher varchar(10),Branchid int references Branch1(Branchid));
Table created.
SQL> create table Borrow1(USN varchar(10) references Student1(USN),Bookid varchar(10)
references Book1(Bookid),Borrowed_date date);
Table created.
SQL> insert into Branch1 values(1,'MCA','Shankar G');
1 row created.
SQL> insert into Branch1 values(2,'MBA','Veeresh');
SQL> insert into Branch1 values(3,'CSE','Nirmala');
1 row created.
SQL> insert into Branch1 values(4,'ISE','Vinutha');
1 row created.
SQL> insert into Branch1 values(5,'EC','Dheeresh');
1 row created.
SQL> select * from Branch1;
 BRANCHID BNAME HOD
---------- ---------- ----------
 1 MCA Shankar G
 2 MBA Veeresh
 3 CSE Nirmala
 4 ISE Vinutha
 5 EC Dheeresh
SQL> insert into Student1 values('22MCA01','Rajesh','Dabangere',1,2);
1 row created.
SQL> insert into Student1 values('22MCA02','Sanvi','Dabangere',2,3);
insert into Student1 values('22MCA03','Yash','Belgavi',3,6);
1 row created.
SQL> insert into Student1 values('22MCA04','Anaya','Belgavi',4,7);
1 row created.
SQL> insert into Student1 values('22MCA05','Pooja','Vijapur',5,4);
1 row created.
SQL> select * from Student1;
USN NAME ADDRESS BRANCHID SEM
---------- ---------- --------------- ---------- ----------
22MCA01 Rajesh Dabangere 1 2
22MCA02 Sanvi Dabangere 2 3
22MCA03 Yash Belgavi 3 6
22MCA04 Anaya Belgavi 4 7
22MCA05 Pooja Vijapur 5 4
SQL> insert into Author values(
 2
SQL> insert into Author1 values(123,
 2
SQL> insert into Author1 values(123,'Kottur','India',55);
insert into Author1 values(124,'Navathe','India',45);
1 row created.
SQL> insert into Author1 values(125,'Riche','UK',50);
1 row created.
SQL> insert into Author1 values(126,'Jane','USA',55);
1 row created.
SQL> insert into Author1 values(127,'Sumitaba','India',55);
1 row created.
SQL> select * from Author1;
 AUTHORID ANAME COUNTRY AGE
---------- ---------- --------------- ----------
 123 Kottur India 55
 124 Navathe India 45
 125 Riche UK 50
 126 Jane USA 55
 127 Sumitaba India 55
SQL> insert into Book1 values(1111,'C Program',123,'Pearson',1);
1 row created.
SQL> insert into Book1 values(2222,'DBMS',124,'Himalaya',2);
SQL> insert into Book1 values(3333,'OOPS',125,'Sapna',3);
1 row created.
SQL> insert into Book1 values(4444,'UNIX',126,'Subhash',4);
1 row created.
SQL> insert into Book1 values(5555,'CN',127,
 2
SQL> insert into Book1 values(5555,'CN',127,'Pearson',5);
1 row created.
SQL> select * from Book1;
BOOKID BNAME AUTHORID PUBLISHER BRANCHID
---------- ---------- ---------- ---------- ----------
1111 C Program 123 Pearson 1
2222 DBMS 124 Himalaya 2
3333 OOPS 125 Sapna 3
4444 UNIX 126 Subhash 4
5555 CN 127 Pearson 5
SQL> insert into Borrow1 values('22MCA01',2222,'22 jan 2023');
insert into Borrow1 values('22MCA01',3333,'21 apr 2023');
1 row created.
SQL> insert into Borrow1 values('22MCA03',5555,'22 mar 2023');
1 row created.
SQL> insert into Borrow1 values('22MCA05',2222,'20 jan 2023');
1 row created.
SQL> insert into Borrow1 values('22MCA02',1111,'18 sep 2023');
1 row created.
SQL> select * from Borrow1;
USN BOOKID BORROWED_
---------- ---------- ---------
22MCA01 2222 22-JAN-23
22MCA01 3333 21-APR-23
22MCA03 5555 22-MAR-23
22MCA05 2222 20-JAN-23
22MCA02 1111 18-SEP-23
SQL> select * from Student1 where sem = 2 and Branchid in (select Branchid from Branch1 where
Bname = 'MCA');
select * from Student1 where USN not in (select USN from Borrow1);
USN NAME ADDRESS BRANCHID SEM
---------- ---------- --------------- ---------- ----------
22MCA04 Anaya Belgavi 4 7
SQL> select Student1.USN,Student1.Name,Branch1.Bname,Book1.Bname,Aname,Borrowed_date
from Student1,Branch1,Book1,Author1,Borrow1 where Student1.USN=Borrow1.USN and
Borrow1.Bookid=Book1.Bookid and Book1.Authorid=Author1.Authorid and
Student1.Branchid=Branch1.Branchid and Student1.Sem=2 and Branch1.Bname='MCA';
USN NAME BNAME BNAME ANAME BORROWED_
---------- ---------- ---------- ---------- ---------- ---------
22MCA01 Rajesh MCA DBMS Navathe 22-JAN-23
22MCA01 Rajesh MCA OOPS Riche 21-APR-23
SQL> select count(*),Authorid from Book1 group by Authorid;
 COUNT(*) AUTHORID
---------- ----------
 1 123
 1 125
 1 124
 1 126
 1 127
SQL> select Name,Address,Branchid,Sem,count(Borrow1.USN) from Student1,Borrow1 where
Borrow1.USN=Student1.USN group by Name,Address,Branchid,Sem having count(Borrow1.USN)=2; select * from Student1 where USN in (select USN from Borrow1 group by USN having
count(USN)=2);
USN NAME ADDRESS BRANCHID SEM
---------- ---------- --------------- ---------- ----------
22MCA01 Rajesh Dabangere 1 2
SQL> select Bname from Book1 order by Bname desc;
BNAME
----------
UNIX
OOPS
DBMS
CN
C Program
SQL> select s.* from Student1 s
 2 JOIN Borrow1 br on s.USN = br.USN
 3 JOIN Book1 bk on br.Bookid = bk.Bookid
 4 WHERE bk.Publisher in(
 5 select Publisher from Book1 group by Publisher having count(Bookid) > 1
 6 );
USN NAME ADDRESS BRANCHID SEM
---------- ---------- --------------- ---------- ----------
22MCA02 Sanvi Dabangere 2 3
22MCA03 Yash Belgavi 3 6
SQL> create table StudentR1(USN varchar(10)primary key, Sname varchar(10), Date_of_Birth Date,
Branch varchar(10), Mark1 int, Mark2 int, Mark3 int, Total int, GPA int);
Table created.
SQL> insert into StudentR1 values('2KD22MC001','Abhishek','02 jul 1999','MCA',91,82,86,0,0);
1 row created.
SQL> insert into StudentR1 values('2KD22MC002','Ajay S','02 mar 1998','MCA',71,82,76,0,0);
1 row created.
SQL> insert into StudentR1 values('2KD22MC003','Anjana','12 jun 1999','MCA',81,92,76,0,0);
1 row created.
SQL> insert into StudentR1 values('2KD22MC007','Chandan','02 mar 1998','MCA',71,82,76,0,0);
1 row created.
SQL> insert into StudentR1 values('2KD22MC014','Naveen','02 feb 1999','MCA',81,82,83,0,0);
1 row created.
SQL> insert into StudentR1 values('2KD22MC015','Manohar','02 jul 1999','MCA',71,82,76,0,0);
1 row created.
SQL> insert into StudentR1 values('2KD22MC018','Prasad','02 jul 1999','MBA',71,82,76,0,0);
insert into StudentR1 values('2KD22MC020','Chetan','02 mar 2000','MCA',91,72,76,0,0);
1 row created.
SQL> insert into StudentR1 values('2KD22MC024','Shrinivas','02 jul 1998','CS',71,72,76,0,0);
1 row created.
SQL> select * from StudentR1;
USN SNAME DATE_OF_B BRANCH MARK1 MARK2 MARK3 TOTAL GPA
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ----------
2KD22MC001 Abhishek 02-JUL-99 MCA 91 82 86 0 0
2KD22MC002 Ajay S 02-MAR-98 MCA 71 82 76 0 0
2KD22MC003 Anjana 12-JUN-99 MCA 81 92 76 0 0
2KD22MC007 Chandan 02-MAR-98 MCA 71 82 76 0 0
2KD22MC014 Naveen 02-FEB-99 MCA 81 82 83 0 0
2KD22MC015 Manohar 02-JUL-99 MCA 71 82 76 0 0
2KD22MC018 Prasad 02-JUL-99 MBA 71 82 76 0 0
2KD22MC020 Chetan 02-MAR-00 MCA 91 72 76 0 0
2KD22MC024 Shrinivas 02-JUL-98 CS 71 72 76 0 0
9 rows selected.
SQL> Update StudentR1 set Total=Mark1+Mark2+Mark3;
9 rows updated.
SQL> select * from StudentR1;
USN SNAME DATE_OF_B BRANCH MARK1 MARK2 MARK3 TOTAL GPA
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ----------
2KD22MC001 Abhishek 02-JUL-99 MCA 91 82 86 259 0
2KD22MC002 Ajay S 02-MAR-98 MCA 71 82 76 229 0
2KD22MC003 Anjana 12-JUN-99 MCA 81 92 76 249 0
2KD22MC007 Chandan 02-MAR-98 MCA 71 82 76 229 0
2KD22MC014 Naveen 02-FEB-99 MCA 81 82 83 246 0
2KD22MC015 Manohar 02-JUL-99 MCA 71 82 76 229 0
2KD22MC018 Prasad 02-JUL-99 MBA 71 82 76 229 0
2KD22MC020 Chetan 02-MAR-00 MCA 91 72 76 239 0
2KD22MC024 Shrinivas 02-JUL-98 CS 71 72 76 219 0
Update StudentR1 set GPA=Total/3;
9 rows updated.
SQL> select * from StudentR1;
USN SNAME DATE_OF_B BRANCH MARK1 MARK2 MARK3 TOTAL GPA
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ----------
2KD22MC001 Abhishek 02-JUL-99 MCA 91 82 86 259 86
2KD22MC002 Ajay S 02-MAR-98 MCA 71 82 76 229 76
2KD22MC003 Anjana 12-JUN-99 MCA 81 92 76 249 83
2KD22MC007 Chandan 02-MAR-98 MCA 71 82 76 229 76
2KD22MC014 Naveen 02-FEB-99 MCA 81 82 83 246 82
2KD22MC015 Manohar 02-JUL-99 MCA 71 82 76 229 76
2KD22MC018 Prasad 02-JUL-99 MBA 71 82 76 229 76
2KD22MC020 Chetan 02-MAR-00 MCA 91 72 76 239 80
2KD22MC024 Shrinivas 02-JUL-98 CS 71 72 76 219 73
select sname, GPA from StudentR1;
SNAME GPA
---------- ----------
Abhishek 86
Ajay S 76
Anjana 83
Chandan 76
Naveen 82
Manohar 76
Prasad 76
Chetan 80
Shrinivas 73
9 rows selected.
SQL> select * from StudentR1 whre Date_of_Birth like '%99';
select * from StudentR1 whre Date_of_Birth like '%99'
 *
ERROR at line 1:
ORA-00933: SQL command not properly ended
SQL> select * from StudentR1 where Date_of_Birth like '%99';
USN SNAME DATE_OF_B BRANCH MARK1 MARK2 MARK3 TOTAL GPA
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ----------
2KD22MC001 Abhishek 02-JUL-99 MCA 91 82 86 259 86
2KD22MC003 Anjana 12-JUN-99 MCA 81 92 76 249 83
2KD22MC014 Naveen 02-FEB-99 MCA 81 82 83 246 82
2KD22MC015 Manohar 02-JUL-99 MCA 71 82 76 229 76
2KD22MC018 Prasad 02-JUL-99 MBA 71 82 76 229 76
SQL> Select * from StudentR1 where Branch='CS';
USN SNAME DATE_OF_B BRANCH MARK1 MARK2 MARK3 TOTAL GPA
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ----------
2KD22MC024 Shrinivas 02-JUL-98 CS 71 72 76 219 73
SQL> Select branch, max(GPA) from StudentR1 group by branch;
BRANCH MAX(GPA)
---------- ----------
MBA 76
CS 73
MCA 86
SQL> select * from StudentR1 where Sname like'S%';
USN SNAME DATE_OF_B BRANCH MARK1 MARK2 MARK3 TOTAL GPA
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ----------
2KD22MC024 Shrinivas 02-JUL-98 CS 71 72 76 219 73
SQL> select * from StudentR1 where Sname like'%ar';
USN SNAME DATE_OF_B BRANCH MARK1 MARK2 MARK3 TOTAL GPA
2KD22MC015 Manohar 02-JUL-99 MCA 71 82 76 229 76
SQL> delete from StudentR1 where USN='2KD22MC001';
1 row deleted.
SQL> select * from StudentR1;
USN SNAME DATE_OF_B BRANCH MARK1 MARK2 MARK3 TOTAL GPA
---------- ---------- --------- ---------- ---------- ---------- ---------- ---------- ----------
2KD22MC002 Ajay S 02-MAR-98 MCA 71 82 76 229 76
2KD22MC003 Anjana 12-JUN-99 MCA 81 92 76 249 83
2KD22MC007 Chandan 02-MAR-98 MCA 71 82 76 229 76
2KD22MC014 Naveen 02-FEB-99 MCA 81 82 83 246 82
2KD22MC015 Manohar 02-JUL-99 MCA 71 82 76 229 76
2KD22MC018 Prasad 02-JUL-99 MBA 71 82 76 229 76
2KD22MC020 Chetan 02-MAR-00 MCA 91 72 76 239 80
2KD22MC024 Shrinivas 02-JUL-98 CS 71 72 76 219 73




Lab3
SQL> create table Team(Teamid varchar(10) primary key, Team_name varchar(10),Coach
varchar(10),Capid varchar(4),city varchar(10));
Table created.
SQL> insert into Team values('T001','India','Clark','PA01','Mumbai');
1 row created.
SQL> insert into Team values('T002','Pakistan','Mulla','PB01','Gulf');
1 row created.
SQL> insert into Team values('T003','Africa','Smith','PC01','Gerf');
1 row created.
SQL> insert into Team values('T004','Australia','Sammy','PD01','Denmark');
1 row created.
SQL> select * from Team;
TEAMID TEAM_NAME COACH CAPI CITY
---------- ---------- ---------- ---- ----------
T001 India Clark PA01 Mumbai
T002 Pakistan Mulla PB01 Gulf
T003 Africa Smith PC01 Gerf
T004 Australia Sammy PD01 Denmark

SQL> create table Player(Playerid varchar(10) primary key,Player_name varchar(10)Not Null,age
int,Teamid varchar(10) references Team(Teamid));
Table created.
SQL> insert into Player values('PA01','Kohli',25,'T001');
1 row created.
SQL> insert into Player values('PA02','Dhoni',27,'T001');
1 row created.
SQL> insert into Player values('PA03','Ishant',32,'T001');
1 row created.
SQL> insert into Player values('PB01','Smark',30,'T002');
1 row created.
SQL> insert into Player values('PB02','Smith',25,'T002');
1 row created.
SQL> insert into Player values('PB03','Shayne',35,'T002');
1 row created.
SQL> insert into Player values('PC01','Samm',35,'T003');
SQL> insert into Player values('PC02','Wander',33,'T003');
1 row created.
SQL> insert into Player values('PC03','Valky',34,'T003');
1 row created.
SQL> insert into Player values('PD01','Valky',24,'T004');
1 row created.
SQL> insert into Player values('PD02','Bahu',21,'T004');
1 row created.
SQL> insert into Player values('PD03','Fugu',28,'T004');
1 row created.
SQL> insert into Player values('PD04','Rugu',28,'T004');
1 row created.
SQL> select * from Player;
PLAYERID PLAYER_NAM AGE TEAMID
---------- ---------- ---------- ----------
PA01 Kohli 25 T001
PA02 Dhoni 27 T001
PA03 Ishant 32 T001
PB01 Smark 30 T002
PB02 Smith 25 T002
PB03 Shayne 35 T002
PC01 Samm 35 T003
PC02 Wander 33 T003
PC03 Valky 34 T003
PD01 Valky 24 T004
PD02 Bahu 21 T004
PLAYERID PLAYER_NAM AGE TEAMID
---------- ---------- ---------- ----------
PD03 Fugu 28 T004
PD04 Rugu 28 T004
13 rows selected.
SQL> create table Stadium(Sid varchar(4) primary key,Stadium_name varchar(10) Not null,Pincode
int,City varchar(10),Area varchar(10));
Table created.
SQL> insert into Stadium values('S001','INDIA',509123,'Mumbai','Sahpur');
1 row created.
SQL> insert into Stadium values('S002','AFRICA',509124,'Denmark','Ocean');
create table Stadium(Sid varchar(4) primary key,Stadium_name varchar(10) Not null,Pincode
int,City varchar(10),Area varchar(10));
Table created.
SQL> insert into Stadium values('S001','INDIA',509123,'Mumbai','Sahpur');
1 row created.
SQL> insert into Stadium values('S002','AFRICA',509124,'Denmark','Ocean');
create table Matches(Mid varchar(4) primary key,Mdate date,time varchar(10),Sid
varchar(4)references Stadium(Sid),Team_id1 varchar(4) references Team(Teamid),Team_id2
varchar(4) references Team(Teamid),winning_team_id varchar(4) references
Team(Teamid),man_of_the_match_id varchar(4) references Player(Playerid));
Table created.
SQL> insert into Matches values('M1','02-JUL-2022','10AM','S001','T001','T002','T001','PA01');
1 row created.
SQL> insert into Matches values('M2','02-JUN-2021','3AM','S002','T003','T004','T003','PC01');
1 row created.
SQL> insert into Matches values('M3','10-JUN-2021','9AM','S001','T001','T003','T001','PA02');
1 row created.
SQL> insert into Matches values('M4','10-JUN-2023','11AM','S002','T001','T004','T001','PA02');
1 row created.
SQL> insert into Matches values('M5','10-MAY-2022','11AM','S001','T001','T002','T001','PA02');
1 row created.
SQL> select * from Matches;
MID MDATE TIME SID TEAM TEAM WINN MAN_
---- --------- ---------- ---- ---- ---- ---- ----
M1 02-JUL-22 10AM S001 T001 T002 T001 PA01
M2 02-JUN-21 3AM S002 T003 T004 T003 PC01
M3 10-JUN-21 9AM S001 T001 T003 T001 PA02
M4 10-JUN-23 11AM S002 T001 T004 T001 PA02
M5 10-MAY-22 11AM S001 T001 T002 T001 PA02
SQL> create table Player_pno(Playerid varchar(4) references Player(Playerid),Phone_no int);
Table created.
SQL> insert into Player_pno values('PA01',9845234212);
1 row created.
SQL> insert into Player_pno values('PA02',9362564886);
1 row created.
SQL> insert into Player_pno values('PA03',9384566258);
1 row created.
SQL> insert into Player_pno values('PA01',9314535848);
1 row created.
SQL> insert into Player_pno values('PA02',9358635848);
1 row created.
SQL> insert into Player_pno values('PA01',9312475848);
SQL> insert into Player_pno values('PA01',9312432898);
1 row created.
SQL> insert into Player_pno values('PA01',9658931898);
1 row created.
SQL> select * from Player_pno;
PLAY PHONE_NO
---- ----------
PA01 9845234212
PA02 9362564886
PA03 9384566258
PA01 9314535848
PA02 9358635848
PA01 9312475848
PA01 9312432898
PA01 9658931898
8 rows selected.
Query:
SQL> SELECT Player_name,Team_name,age FROM Player p,Team t WHERE p.Teamid=t.Teamid and
age=(SELECT MIN(age) FROM Player);
PLAYER_NAM TEAM_NAME AGE
Bahu Australia 21
SQL> SELECT * FROM Stadium WHERE Sid IN
 2 (SELECT Sid FROM Matches GROUP BY
 3 Sid HAVING COUNT(Sid)=(SELECT
 4 MAX(COUNT(Sid)) FROM Matches
 5 GROUP BY Sid));
SID STADIUM_NA PINCODE CITY AREA
---- ---------- ---------- ---------- ----------
S001 INDIA 509123 Mumbai Sahpur
SQL> SELECT * FROM Player WHERE Playerid NOT IN(SELECT
 2 Capid FROM Team) AND Playerid IN(SELECT
 3 man_of_the_match_id FROM Matches GROUP BY
 4 man_of_the_match_id HAVING
 5 COUNT(man_of_the_match_id)>=2);
PLAYERID PLAYER_NAM AGE TEAMID
---------- ---------- ---------- ----------
PA02 Dhoni 27 T001
SQL> SELECT * FROM Team WHERE Teamid IN
 2 (SELECT winning_team_id
 3 FROM Matches
 4 GROUP BY winning_team_id
 5 HAVING COUNT(winning_team_id)=(SELECT MAX(wins) FROM(SELECT COUNT
 6 (winning_team_id)AS wins FROM Matches GROUP BY winning_team_id)));
TEAMID TEAM_NAME COACH CAPI CITY
Bahu Australia 21
SQL> SELECT * FROM Stadium WHERE Sid IN
 2 (SELECT Sid FROM Matches GROUP BY
 3 Sid HAVING COUNT(Sid)=(SELECT
 4 MAX(COUNT(Sid)) FROM Matches
 5 GROUP BY Sid));
SID STADIUM_NA PINCODE CITY AREA
---- ---------- ---------- ---------- ----------
S001 INDIA 509123 Mumbai Sahpur
SQL> SELECT * FROM Player WHERE Playerid NOT IN(SELECT
 2 Capid FROM Team) AND Playerid IN(SELECT
 3 man_of_the_match_id FROM Matches GROUP BY
 4 man_of_the_match_id HAVING
 5 COUNT(man_of_the_match_id)>=2);
PLAYERID PLAYER_NAM AGE TEAMID
---------- ---------- ---------- ----------
PA02 Dhoni 27 T001
SQL> SELECT * FROM Team WHERE Teamid IN
 2 (SELECT winning_team_id
 3 FROM Matches
 4 GROUP BY winning_team_id
 5 HAVING COUNT(winning_team_id)=(SELECT MAX(wins) FROM(SELECT COUNT
 6 (winning_team_id)AS wins FROM Matches GROUP BY winning_team_id)));
TEAMID TEAM_NAME COACH CAPI CITY
T001 India Clark PA01 Mumbai
SQL> SELECT Team_name FROM Team
 2 WHERE Teamid IN(SELECT winning_team_id
 3 FROM Matches);
TEAM_NAME
----------
India
Africa

Popular posts from this blog

WT lab

WEB TECHNOLOGIES LAB JOURNAL 1.Create an XHTML page that provides information about your department. Your XHTML page must use the following tags: a) Text Formatting tags b) Horizontal rule c) Meta element d) Links e) Images f) Tables (Use of additional tags encouraged).--! <!DOCTYPE html> <html xmlns="http://www.w3.org/1999/xhtml" lang="en"> <head>  <meta charset="UTF-8" />  <meta name="description" content="Information about the MCA Department" />  <title>Department Information</title> </head> <body>  <h1 style="text-align: center; color: navy;">Welcome to the MCA Department</h1>  <hr />  <p><strong>About Us:</strong> The <em>MCA Department</em> is dedicated to providing quality education and fostering innovation. Our programs are designed to develop skills and knowledge required to excel in various engin...
Read more

A2 python

Program1: check whether the number is belongs to Fibonacci series or not PART A n=int(input("Enter the number: ")) c=0 a=1 b=1 if n==0 or n==1: print("Yes the number belongs to Fibonacci series") else:  while c<n:  c=a+b  b=a  a=c  if c==n:  print("Yes,the number belongs to Fibonacci series")  else: print("No, the number not belongs to Fibonacci series") ==========OUTPUT========= Enter the number: 5 Yes the number belongs to fibonacci series Enter the number: 4 No the number not belongs to fibonacci series SNJPSNMS Trust’s Degree College,Nidasoshi Python Programming Lab Program 2: Solve Quadratic Equations #import complex math module import cmath print("Enter the value of a") a=float(input()) print("Enter the value of b") b=float(input()) print("Enter the value of c") c=float(input()) #calculate the discriminant d=(b**2)-(4*a*c) #find the solution soln1=(-b-cmath.sqrt(d))/(2*a) soln2=(-b+cmath.sqrt(d))/(2*a) #prin...
Read more