Based on fragment of XML document, write XQuery query that returns category tag and price tag nested within the book tag with attribute title! For example, for Applied Functional Analysis this would look as follows: book title="Applied Functional Analips Others 400 document name: library.xml James Applied Functional Analysis Others 2 400 Smith Jeff

Based on fragment of XML document, write XQuery query that returns category tag and price tag nested within the book tag with attribute title! For example, for Applied Functional Analysis this would look as follows: book title="Applied Functional Analips Others 400 document name: library.xml James Applied Functional Analysis Others 2 400 Smith Jeff

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What does an EXCEPT (MINUS) query care about operand order, while a UNION query doesn't?
Suppose an application programmer was supposed to write a query select * from r natural left outer join s; on relations r(A, B) and s(B, C), but instead wrote the query select * from r natural join s; a. Give sample data for r and s on which both queries would give the same result. b. Give sample data for r and s where the two queries would give different results, thereby exposing the error in the query.
There are three tables in this database (see image). Write MYSQL code for: (1) Create a trigger “insert_inventory” on table “Inventory”. The trigger is fired after a row is inserted in table “Inventory”. After a row is inserted in table “inventory”, the “itemid”, the insertion time, and the action is inserted in table “Inventory_history”. The action is set to ‘add an item’. The oldprice is set to null. Test your trigger by inserting a row into Inventory and displaying the contents of Inventory_history. (2) Create a trigger “change_quantity” on table “Transaction”. The trigger is fired after a row is inserted in table “Transaction”. After a row is inserted in table “Transaction”, update the “quantity” in table “Inventory”. For example, if 3 iWatch are sold, then the quantity of iWatch in table “Inventory” is decreased by 3. Test your trigger by inserting a row into Transaction and displaying the contents of the relevant row in Inventory. (3) Create a trigger “change_price” on table…
Give Pros of Using Dynamic Views
Hi, This is what I have, but I am stuck with what to write and not sure if my function is even correct, to begin with. Can someone show me a walk-through solution? MUST USE postgreSQL CREATE TABLE instructor_course_nums (ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25)); CREATE OR REPLACE PROCEDURE calculate_instr_course(ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25))LANGUAGE plpgsqlAS$$BEGIN END;$$;
Apply Normalization A table with the students and their grades in different topics. UnitID | StudentID | Date TutorID | Topic Room | Grade Book 5 U2 U1 U5 U4 St1 St1 St4 St2 St2 23.02.03 Tut1 18.11.02 Tut3 23.02.03 Tut1 05.05.03 Tut3 04.07.03 Tut5 GMT 629 Gln 631 5.1 4.7 GMT 629 4.3 PhF 632 AVQ 621 4.9 5.0 Deumlich Zehnder Deumlich TutEmail tut1@fhbb.ch tut3@fhbb.ch tut1@fhbb.ch Dümmlers tut3@fhbb.ch Swiss Topo tut5@fhbb.ch
Consider tables S (A, B, C) and T (B, C, D) and SQL query select A, B, C, D from S, T where S.B = T.B and S.C = T.C Design a MapReduce program to compute the join efficiently. Please provide the pseudocode.
Write a PL/SQL Function that accepts 4 integers, 2 representing the homeTeamID and visitorTeamID, and the other 2 representing the score for each team during a game : htscore and vtscore The function will determine which team won the match and return the teamID of the winning team. You can achive this by comparing htscore > or < then vtscore.. if htscore is bigger then return hteamID or else return vteamID. If the game was a tie (the 2 scores are the same value) return a 0.
How does query optimization differ when querying against nested JSON objects as compared to flat key-value pairs?
Using the getFirst() function as a template for reference, code the saveProduct() function that will be called when the save button of the depicted screen is clicked. The text from the JTextFields will be used as parameters.The database schema for the SQL tables are also depicted. The number of the product is the primary key and is set to auto-increment. public Product getFirst() { if (openConnection()) { try{ Product temp = null; String query = "SELECT * FROM products order by number asc limit 1"; // our SQL SELECT query. Statement st = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY); // create the java statement ResultSet rs = st.executeQuery(query);// execute the query, and get a java resultset while (rs.next()) // iterate through the java resultset { temp = new…
Below is a table description and its data. The table is not in Third Normal Form (3NF). Explain why. mysql> DESC shows; +-- +- | Field | Туре | Null | Key | Default| Extra +-- | int(11) | varchar(50) | YES | int(11) I network_name I varchar(30) | YES | id | NO PRI I NULL auto_increment | | NULL | NULL | NULL | name I network_id | YES mysql> SELECT * FROM shows; +---- | id | name I network_id I network_name +----+ 1 | Raven's Home 2 | Friends 3 I The Good Place | 10 I Disney 30 | NBC 30 | NBC | 4 | Young Sheldon 20 | CBS +---
2. Get the Groups As new students begin to arrive at college, each receives a unique ID number, 1 to n. Initially, the students do not know one another, and each has a different circle of friends. As the semester progresses, other groups of friends begin to form randomly. There will be three arrays, each aligned by an index. The first array will contain a queryType which will be either Friend or Total. The next two arrays, students1 and students2, will each contain a student ID. If the query type is Friend, the two students become friends. If the query type is Total, report the sum of the sizes of each group of friends for the two students.