Posts

Showing posts from December, 2023

DBMS

 https://docs.google.com/spreadsheets/d/1pwujzrd3LeVNe3XLTFjhkRULSw_IwnIkQhCOtblw_Fk/edit?usp=sharing Drive link : DBMS pdf link 1. Q1 With the help of customer and order database, implement all types of  joins. create database vaishnavi; show databases; use vaishnavi; create table customer(cid int primary key,cname varchar(20) not null,mono double not null); show tables; insert into customer values (1,"akku ban",56767),(2,"vaishu hgdg",732383),(3,"pallun frer",675463); select * from customer; create table oorder(oid int primary key,odate int not null,oammount int not null,cid int not null); show tables; insert into oorder values (1,2019-05-05,55,1),(2,2019-05-06,56,2),(3,2019-05-07,78,1); select * from oorder; select * from customer JOIN oorder ON customer.cid=oorder.cid; select customer.cid,cname,odate from customer JOIN oorder ON customer.cid=oorder.cid; select * from customer LEFT JOIN oorder ON customer.cid=oorder.cid; select * from customer RIGHT JOI...

IOT WSN

Image
 IOT IOT MATERIAL experiment no.5 interfacing IR sensor with arduino and buzzer block dig and discription Block dig: code int irSensor = 12 ; int buzzer = 7 ; void setup () {   Serial . begin ( 9600 ) ;   pinMode ( irSensor, INPUT ) ;   pinMode ( buzzer, OUTPUT ) ; } void loop () {   int value = digitalRead ( irSensor ) ;   Serial . println ( "" ) ;   Serial . print ( "Sensor Value = " ) ;   Serial . print ( value ) ;     if ( value == 0 )   {     digitalWrite ( buzzer, HIGH ) ;   }   else   {     digitalWrite ( buzzer, LOW ) ;   }   delay ( 50 ) ; } Experiment no : 6 interfacing 16*2 lcd with arduino board for display message or informtion block dig : Code: //YWROBOT //Compatible with the Arduino IDE 1.0 //Library version:1.1 #include <LiquidCrystal_I2C.h> LiquidCrystal_I2C lcd(0x27,20,4);  // set the LCD address to 0x27 for a 16 chars and 2 line display void setup() { ...

CNES

  CNES experiments