@Sai_kiran_rachakonda

recursion (sum of natural numbers)

June 14, 2022 · Python 
def nat(n):
    if n < 0:
        return 0
    else:
        return n + nat(n - 1)

print(nat(5))

recursion 1 to N

June 14, 2022 · Python 
def num(n):
    if n > 0:
        num(n-1)
        print(n)
        
    
    
num(10)

recursion fact

June 14, 2022 · Python 
def factorial(n):
    if n == 0:
        return 1
    elif n == 1:
        return 1
    else:    
        return n * factorial(n-1)
    
    
print(factorial(5))

example

June 14, 2022 · Python 
def power(x,y):
    if y == 0:
        return 1
    else:    
        return x * power(x, y-1)
    
    
print(power(2,3))

recursion pow

June 14, 2022 · Python 
def power(x):
    if x== 0:
        return 1
    return 2 * power(x - 1)
    
    
print(power(4))

recursion fact

June 14, 2022 · Python 
def factorial(n):
    if n == 0:
        return 1
    elif n == 1:
        return 1
    else:    
        return n * factorial(n-1)
    
    
factorial(5)

sort (half)

June 14, 2022 · Python 
a = [2,3,8,-1,7,1]
b = [-4, 6, 9, -1, 3]
c = []
d = []
a.sort()
b.sort()
x = len(a) // 2
y = len(b) // 2
for i in range(x):
    if a[i] <= x:

example

updated June 14, 2022 · Python 
def factorial(n):
    if n == 0:
        return 1
    else:    
        return n * factorial(n-1)
    
    
factorial(5)

doctor- sum of special_fee

March 26, 2022 · SQL 
create table Doctor(
  Did int primary key,
  Dname varchar(25),
  specialization varchar(20) default 'general',
  Adhar_no varchar(12) unique,
  consultation_fee numeric(5,2) constraint c1 check(consultation_fee > 50)
);
insert into Doctor values('D_100', 'XYZ', 'ENT', 12334, 150);
insert into Doctor values('D_101', 'PQR', 'ORTHO', 12455, 200);
insert into Doctor values('D_102', 'LMN', 'ENT', 12256, 150);

doctor- special_fee

March 26, 2022 · SQL 
create table Doctor(
  Did int primary key,
  Dname varchar(25),
  specialization varchar(20) default 'general',
  Adhar_no varchar(12) unique,
  consultation_fee numeric(5,2) constraint c1 check(consultation_fee > 50)
);
insert into Doctor values('D_100', 'XYZ', 'ENT', 12334, 150);
insert into Doctor values('D_101', 'PQR', 'ORTHO', 12455, 200);
insert into Doctor values('D_102', 'LMN', 'ENT', 12256, 150);

doctor- special_fee

March 26, 2022 · SQL 
create table Doctor(
  Did int primary key,
  Dname varchar(25),
  specialization varchar(20) default 'general',
  Adhar_no varchar(12) unique,
  consultation_fee numeric(5,2) constraint c1 check(consultation_fee > 50)
);
insert into Doctor values('D_100', 'XYZ', 'ENT', 12334, 150);
insert into Doctor values('D_101', 'PQR', 'ORTHO', 12455, 200);
insert into Doctor values('D_102', 'LMN', 'ENT', 12256, 150);

doctor

March 26, 2022 · SQL 
create table Doctor(
  Did int primary key,
  Dname varchar(25),
  specialization varchar(20) default 'general',
  Adhar_no varchar(12) unique,
  consultation_fee numeric(5,2) constraint c1 check(consultation_fee > 50)
);
insert into Doctor values('D_100', 'XYZ', 'ENT', 12334, 150);
insert into Doctor values('D_101', 'PQR', 'ORTHO', 12455, 200);
insert into Doctor values('D_102', 'LMN', 'ENT', 12256, 150);

doctor- special_face

March 26, 2022 · SQL 
create table Doctor(
  Did int primary key,
  Dname varchar(25),
  specialization varchar(20) default 'general',
  Adhar_no varchar(12) unique,
  consultation_fee numeric(5,2) constraint c1 check(consultation_fee > 50)
);
insert into Doctor values('D_100', 'XYZ', 'ENT', 12334, 150);
insert into Doctor values('D_101', 'PQR', 'ORTHO', 12455, 200);
insert into Doctor values('D_102', 'LMN', 'ENT', 12256, 150);

doctor

March 26, 2022 · SQL 
create table Doctor(
  Did int primary key,
  Dname varchar(25),
  specialization varchar(20) default 'general',
  Adhar_no varchar(12) unique,
  consultation_fee numeric(5,2) constraint c1 check(consultation_fee > 50)
);
insert into Doctor values('D_100', 'XYZ', 'ENT', 12334, 150);
insert into Doctor values('D_101', 'PQR', 'ORTHO', 12455, 200);
insert into Doctor values('D_102', 'LMN', 'ENT', 12256, 150);

doctor, patient, treat

March 25, 2022 · SQL 
create table Patient(
  Pid int primary key,
  Pname varchar(25),
  DOB date,
  Address varchar(20)
);
insert into Patient values('p_100', 'Adhi', '12-07-1999', 'cvvd');
insert into Patient values('p_101', 'Bosco', '02-03-2000', 'uythk');
insert into Patient values('p_102', 'Dylan', '18-09-0989', 'njkl');
insert into Patient values('p_103', 'Elma', '22-01-2000', 'mkjgx');

doctor, patient, treat

March 22, 2022 · SQL 
create table Patient(
  Pid int primary key,
  Pname varchar(25),
  DOB date,
  Address varchar(20)
);
insert into Patient values('p_100', 'Adhi', '12-07-1999', 'cvvd');
insert into Patient values('p_101', 'Bosco', '02-03-2000', 'uythk');
insert into Patient values('p_102', 'Dylan', '18-09-0989', 'njkl');
insert into Patient values('p_103', 'Elma', '22-01-2000', 'mkjgx');

doctor, patient, treat

March 22, 2022 · SQL 
create table Patient(
  Pid int primary key,
  Pname varchar(25),
  DOB date,
  Address varchar(20)
);
insert into Patient values('p_100', 'Adhi', '12-07-1999', 'cvvd');
insert into Patient values('p_101', 'Bosco', '02-03-2000', 'uythk');
insert into Patient values('p_102', 'Dylan', '18-09-0989', 'njkl');
insert into Patient values('p_103', 'Elma', '22-01-2000', 'mkjgx');

doctor, patient, treat

March 22, 2022 · SQL 
create table Patient(
  Pid int primary key,
  Pname varchar(25),
  DOB date,
  Address varchar(20)
);
insert into Patient values('p_100', 'Adhi', '12-07-1999', 'cvvd');
insert into Patient values('p_101', 'Bosco', '02-03-2000', 'uythk');
insert into Patient values('p_102', 'Dylan', '18-09-0989', 'njkl');
insert into Patient values('p_103', 'Elma', '22-01-2000', 'mkjgx');

Treat

March 22, 2022 · SQL 
create table Treat(
  Did int references Doctor(Did) on delete cascade,
  Pid int references Patient (Pid) on delete set null,
  Diagnosis varchar(30) not null,
  treat_id int,
  treat_date date
);
insert into Treat values('D_100', 'p_100', 'aaa', 1, '03-11-2000');
insert into Treat values('D_101', 'p_101', 'bbb', 2, '04-11-2010');
insert into Treat values('D_102', 'p_102', 'ccc', 3, '05-11-2009');

Treat

March 22, 2022 · SQL 
create table Treat(
  Did int references Doctor(Did) on delete cascade,
  Pid int references Patient (Pid) on delete set null,
  Diagnosis varchar(30) not null,
  treat_id int,
  treat_date date
);
insert into Treat values('D_100', 'p_100', 'aaa', 1, '03-11-2000');
insert into Treat values('D_101', 'p_101', 'bbb', 2, '04-11-2010');
insert into Treat values('D_102', 'p_102', 'ccc', 3, '05-11-2009');