Program
function[]=nf(x,d,z)
while(abs(z(x))>d)
if(derivative(z,x)<>0)
x=x-z(x)/derivative(z,x)
end
end
printf('Root by newton raphson method=%f',x)
endfunction
Output:
-->deff('z=f(x)','z=x*exp(x)-2')
-->nf(2,50,f)
Root by newton raphson method=2.000000
7 Comments
CREATE DATABASE college;
ReplyDeleteUSE college;
CREATE TABLE student (
sid INT PRIMARY KEY,
name VARCHAR(50),
dept VARCHAR(30)
);
CREATE TABLE marks (
mid INT PRIMARY KEY,
sid INT,
subject VARCHAR(30),
marks INT,
FOREIGN KEY (sid) REFERENCES student(sid)
);
INSERT INTO student VALUES
(1,'Amit','CS'),
(2,'Riya','IT'),
(3,'Rahul','CS');
INSERT INTO marks VALUES
(101,1,'DBMS',85),
(102,2,'DBMS',78),
(103,1,'OS',88);
# joins
SELECT student.name, marks.subject, marks.marks
FROM student
INNER JOIN marks
ON student.sid = marks.sid;
SELECT student.name, marks.subject
FROM student
LEFT JOIN marks ON student.sid = marks.sid
UNION
SELECT student.name, marks.subject
FROM student
RIGHT JOIN marks ON student.sid = marks.sid;
# nested
SELECT name
FROM student
WHERE sid IN (
SELECT sid FROM marks WHERE marks > 80
);
select * from marks
where marks = (select max(marks) from marks);
# set operations
CREATE TABLE alumni (
name VARCHAR(50)
);
INSERT INTO alumni VALUES ('Amit'), ('Sneha');
SELECT name FROM student
UNION
SELECT name FROM alumni;
SELECT name FROM student
UNION ALL
SELECT name FROM alumni;
# view:
CREATE VIEW cs_students AS
SELECT name FROM student WHERE dept='CS';
SELECT * FROM cs_students;
# Index:
CREATE INDEX idx_name ON student(name);
# Stored procedure
DELIMITER //
CREATE PROCEDURE show_students()
BEGIN
SELECT * FROM student;
END //
DELIMITER ;
CALL show_students();
# trigger
ReplyDeleteCREATE TABLE marks_audit (
sid INT,
old_marks INT,
new_marks INT
);
DELIMITER //
CREATE TRIGGER marks_update
AFTER UPDATE ON marks
FOR EACH ROW
BEGIN
INSERT INTO marks_audit
VALUES (OLD.sid, OLD.marks, NEW.marks);
END //
DELIMITER ;
UPDATE marks SET marks=90 WHERE mid=101;
# cursor
DELIMITER //
CREATE PROCEDURE count_students()
BEGIN
DECLARE done INT DEFAULT 0;
DECLARE sname VARCHAR(50);
DECLARE total INT DEFAULT 0;
DECLARE cur CURSOR FOR SELECT name FROM student;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done=1;
OPEN cur;
read_loop: LOOP
FETCH cur INTO sname;
IF done=1 THEN
LEAVE read_loop;
END IF;
SET total = total + 1;
END LOOP;
CLOSE cur;
SELECT total AS Total_Students;
END //
DELIMITER ;
CALL count_students();
# neo4j
ReplyDeleteCREATE (:Student {sid:1, name:'Shardul'});
CREATE (:Student {sid:2, name:'Ram'});
CREATE (:Course {cid:101, cname:'ADBMS'});
CREATE (:Course {cid:102, cname:'OS'});
MATCH (s:Student {sid:1}), (c:Course {cid:101})
CREATE (s)-[:ENROLLED_IN]->(c);
MATCH (s:Student {sid:2}), (c:Course {cid:102})
CREATE (s)-[:ENROLLED_IN]->(c);
MATCH (s:Student {sid:2})
SET s.name = 'Omkar';
MATCH (s:Student {sid:2})-[r:ENROLLED_IN]->()
DELETE r;
MATCH (s:Student {sid:2})
DELETE s;
# check point
ReplyDeleteCREATE DATABASE checkpoint_db;
USE checkpoint_db;
CREATE TABLE Account (
acc_no INT PRIMARY KEY,
balance INT
);
INSERT INTO Account VALUES
(1, 5000),
(2, 3000);
start TRANSACTION;
update Account
set balance = balance + 300
where acc_no = 1;
savepoint sp1;
update Account
set balance = balance + 500
where acc_no = 2;
rollback to sp1;
commit;
select * from Account;
# dac to grant and revoke
ReplyDeleteCREATE DATABASE dac_demo1;
USE dac_demo1;
CREATE TABLE employee (
emp_id INT PRIMARY KEY,
emp_name VARCHAR(50)
);
INSERT INTO employee VALUES
(1, 'Amit'),
(2, 'Riya');
CREATE USER 'librarian'@'localhost' IDENTIFIED BY 'lib123';
GRANT SELECT, INSERT
ON dac_demo1.employee
TO 'librarian'@'localhost';
SHOW GRANTS FOR 'librarian'@'localhost';
REVOKE SELECT, INSERT
ON dac_demo.employee
FROM 'librarian'@'localhost';
# fragmentation: horizontal & vertical (view)
ReplyDeleteCREATE DATABASE frag_db;
USE frag_db;
CREATE TABLE employee (
emp_id INT PRIMARY KEY,
emp_name VARCHAR(50),
region VARCHAR(20),
department VARCHAR(30),
salary INT
);
INSERT INTO employee VALUES
(1, 'Amit', 'North', 'IT', 40000),
(2, 'Riya', 'South', 'HR', 35000),
(3, 'Suresh', 'North', 'Finance', 45000),
(4, 'Neha', 'South', 'IT', 42000);
# horizontal
CREATE TABLE emp_north AS
SELECT * FROM employee
WHERE region = 'North';
CREATE TABLE emp_south AS
SELECT * FROM employee
WHERE region = 'South';
SELECT * FROM emp_north;
SELECT * FROM emp_south;
CREATE VIEW emp_all AS
SELECT * FROM emp_north
UNION
SELECT * FROM emp_south;
SELECT * FROM emp_all;
# vertical
CREATE TABLE emp_basic AS
SELECT emp_id, emp_name, department
FROM employee;
CREATE TABLE emp_salary AS
SELECT emp_id, region, salary
FROM employee;
SELECT * FROM emp_basic;
SELECT * FROM emp_salary;
CREATE VIEW emp_complete AS
SELECT b.emp_id, b.emp_name, b.department, s.region, s.salary
FROM emp_basic b
JOIN emp_salary s
ON b.emp_id = s.emp_id;
SELECT * FROM emp_complete
# mongo db
ReplyDeleteuse college
db.students.insertOne({
roll_no: 1,
name: "Amit",
age: 20
})
db.students.insertMany([
{ roll_no: 2, name: "Riya", age: 21 },
{ roll_no: 3, name: "Rahul", age: 19 }
])
db.students.find()
db.students.find({ age: { $gt: 20 } })
db.students.updateOne(
{ roll_no: 1 },
{ $set: { age: 22 } }
)
db.students.deleteOne({ roll_no: 3 })