1) Write Relational Algebra Quarries For Given Set Of Relations.
2) Perform The Following (A) Viewing All Database,Creating A Database, Viewing All Tables In A Database, Creating Tables(With And Without Constraints), Inserting/Updating/Deleting Record In A Table, Saving Commit)And Undoing (Roll Back).
3) Altering A Table, Dropping/Trancating/Renaming Table Backing Up/ Restoring A Database.
Simple Queries, Queries With Aggregate Function (Group By And Having Clause), Queries Involving,Data Function,String Function,Main Function Join Queries Inner Join Outer Join.
import java.awt.*;
ReplyDeleteimport java.applet.*;
import java.awt.event.*;
public class call extends Applet implements ActionListener
{
Button b1,b2,b3,b4,b5;
Panel p1;
TextField t1,t2,t3;
Label l1,l2,l3;
public void init()
{
l1=new Label("FirstNumber");
t1=new TextField(15);
l2=new Label("Second Number");
t2=new TextField(15);
l3=new Label("Result");
t3=new TextField(15);
p1=new Panel();
b1=new Button("Add");
b2=new Button("Sub");
b3=new Button("Mult");
b4=new Button("Div");
b5=new Button("Clear");
b1.addActionListener(this);
b2.addActionListener(this);
b3.addActionListener(this);
b4.addActionListener(this);
b5.addActionListener(this);
p1.add(l1);
p1.add(t1);
p1.add(l2);
p1.add(t2);
p1.add(l3);
p1.add(t3);
p1.add(b1);
p1.add(b2);
p1.add(b3);
p1.add(b4);
p1.add(b5);
add(p1);}
public void actionPerformed(ActionEvent e)
{
int n1=Integer.parseInt(t1.getText());
int n2=Integer.parseInt(t2.getText());
if(e.getSource()==b1)
{
t3.setText(String.valueOf(n1+n2));
}
if(e.getSource()==b2)
{
t3.setText(String.valueOf(n1-n2));
}
if(e.getSource()==b3)
{
t3.setText(String.valueOf(n1*n2));
}
if(e.getSource()==b4)
{
t3.setText(String.valueOf(n1/n2));
}
if(e.getSource()==b5)
{
System.exit(0);
}
}
}