-Given the following relational DB schema and the following SQL query: Student (sid, name, age, address) Book(bid, title, author) Checkout(sid, bid, date) SELECT S.name FROM Student S, Book B, Checkout C WHERE S.sid = C.sid AND B.bid = C.bid AND B.author = ’Olden Fames’ AND S.age > 12 And assuming: There are 20, 000 Student records stored on 2000 blocks. There are 50, 000 Book records stored on 5, 000 blocks There are 300, 000 Checkout records stored on 15, 000 blocks. Student ages range from 7 to 24. Using heuristic rules, show a physical query plan for this query, assuming there are no indexes and data is not sorted on any attribute.

All parts of this question use the following database schema: Flights(flno, from, to, distance) Aircraft(aid, aname, cruisingrange) Certified(eid, aid) Employees(eid, ename, salary) c) For each cruisingrange held by at least 3 aircraft, give the lowest salary of employees certified to fly one of those aircraft. Express in SQL only:

Consider the following schemas: Employee(staffId, name, salary, depNo) primary key staffId foreign key depNo references Department(depNo) Department(depNo,depname, totalSal) primary key depNo and the following procedural SQL statement: CREATE TRIGGER mystery AFTER INSERT ON Employee FOR EACH ROW IF NOT (NEW.depNo IS NULL) UPDATE Department SET totalSal = totalSal + NEW.salary NEW.depNo WHERE depNo ENDIF / = Explain what this trigger does without referring to its code. Describe the effect on the database that it has.

Please provide the correct sql query for the questions. Thanks

We have a relational database that contains the table ‘Staff’. The table ‘Staff’ consist of columns ‘Name’, ‘Department’ and ‘Date of Joining’. What query would you use to extract the Names and Department of all staff in the table?   a. SELECT * FROM Staff     b. a)    SELECT Name, Department FROM Staff     c. SELECT Name, Department IN Staff     d. SELECT * IN Staff

Relational Algebra Questions:Using the instance of the Airport database, formulate the following queries in the relationalalgebra: 1. List full details of all airports located outside the United States.Note: You should use the not equal sign  in this query. 2. List the name and the state of all United States airports. 3. List the name and the fleet size of all carriers employing more than 50000 workers. 4. List the carrier name, the carrierID, the flightNo and the date of all flights. 5. Display the number of airports. 6. Display the number of flights with distances longer than 3000 miles. 7. Display the number of all carriers and the average of their revenues. 8. Display the number of flights leaving from JFK and the total of their distances. 9. Display the minimum, the average, and the maximum distances of the flights that arescheduled on October 17th, 2017?