Scilab Program - newton raphson method while loop - IProgramX

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 

Post a Comment

7 Comments

  1. CREATE DATABASE college;
    USE 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();

    ReplyDelete
  2. # trigger


    CREATE 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();

    ReplyDelete
  3. # neo4j



    CREATE (: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;

    ReplyDelete
  4. # check point

    CREATE 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;

    ReplyDelete
  5. # dac to grant and revoke


    CREATE 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';

    ReplyDelete
  6. # fragmentation: horizontal & vertical (view)


    CREATE 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

    ReplyDelete
  7. # mongo db


    use 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 })

    ReplyDelete