Practical 8

1 ALTER TABLE orders_aj MODIFY ONUM INT UNIQUE;

    TABLE altered

4 ALTER TABLE orders_aj ADD intem_name VARCHAR(20);

    TABLE altered

5 CREATE TABLE orders AS SELECT * FROM orders_aj WHERE 1=1;
    TABLE created

DROP TABLE orders_aj;
    TABLE dropped


8 CREATE TABLE orders ( onum INT NOT NULL , cnum INT, snum INT NOT NULL,
CHECK (onum>cnum),
CHECK (cnum > snum));

    TABLE created


9.1 CREATE TABLE salesman ( snum INT PRIMARY KEY  , sname varchar2(10) NOT NULL , commission varchar2(10) NOT NULL );
    TABLE created


9.2 CREATE TABLE customer_rr(
snum INT ,
cnum INT UNIQUE,
cname varchar2(10) NOT NULL,
city varchar2(10) NOT NULL,
rating INT ,
FOREIGN KEY(snum)
REFERENCES salesman(snum));

    TABLE created


9.3 CREATE TABLE orders_rr (
onum INT PRIMARY KEY,
amount DECIMAL(3,2) NOT NULL,
odate DATE NOT NULL ,
cnum INT ,
snum INT );

    TABLE created