Write a query in XQuery on the XML representation as shown below to compute the left outer
Question:
Write a query in XQuery on the XML representation as shown below to compute the left outer join of customer elements with account elements.
<!DOCTYPE bank-2 [
<!ELEMENT account ( branch, balance )>
<!ATTLIST account
account-number ID #REQUIRED
owners IDREFS #REQUIRED >
<!ELEMENT customer ( customer-name, customer-street, customer-city )>
<!ATTLIST customer
customer-id ID #REQUIRED
accounts IDREFS #REQUIRED >
· · · declarations for branch, balance, customer-name,
customer-street and customer-city · · · ] >
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Answer rating: 68% (16 reviews)
for b in bankaccount c in bankcustomer d in bank...View the full answer
Answered By
Muhammad Haroon
More than 3 years experience in teaching undergraduate and graduate level courses which includes Object Oriented Programming, Data Structures, Algorithms, Database Systems, Theory of Automata, Theory of Computation, Database Administration, Web Technologies etc.
5.00+
3+ Reviews
10+ Question Solved
Related Book For
Question Posted:
Students also viewed these Computer Sciences questions
-
Write queries in XQuery on the bibliography DTD fragment as shown below to do the following. a. Find all authors who have authored a book and an article in the same year. b. Display books and...
-
Give a query in XQuery to flip the nesting of data as shown below. That is, at the outermost level of nesting the outputmust have elements corresponding to authors, and each such element must have...
-
Specify the following views as queries in XQuery on the company XML schema shown in Figure 13.5. a. A view that has the department name, manager name, and manager salary for every department b. A...
-
A fair die is tossed until all the numbers have been seen at least once. Let N be the number of tosses this requires. Find E(N). [Hint: Let N; be the number of tosses until i different numbers have...
-
Bruno Industries manufactures and sells a single product. The controller has prepared the following income statement for the most recent year: The company produced 8,000 units and sold 7,000 units...
-
Magnum, LLC, is a web page design firm that has two designs for an online hardware store. To determine which is the more effective design, Magnum uses one page in the Denver area and a second page in...
-
Who prepares your tax return? As part of a study on income tax compliance (Behavioral Research and Accounting, January 2015), researchers sampled 270 adults at a shopping mall and asked each: Who...
-
A sample of the 2011 MTF survey suggests that adolescents are divided in terms of their attitudes toward others trying marijuana at least once. In fact, 49.3% of the 1,202 respondents who answered...
-
Date Inwentory records for Marvin Company revealed the following: Number Unit Trannaction of Units Cont Mar. 1 Beginning inventory 1,010 57.14 Mar. 10 Purchase 580 7.34 Mar. 16 Purchase 870 7.42 Mar...
-
Please solve this problem using C language Hacker Industries has a number of employees. The company assigns each employee a numeric evaluation score and stores these scores in a list. A manager is...
-
Write a query in XQuery on the XML representation as shown below to find the total balance, across all accounts, at each branch. A-101 Downtown 500 A-102 Perryridge 400 A-201 Brighton 900 Johnson...
-
Write queries in XSLT and XQuery to output customer elements with associated account elements nested within the customer elements, given the bank information representation using ID and IDREFS as...
-
You are the marketing manager for Lenovo laptop computers. Identify and briefly discuss the differences between the consumer market for laptops and the business market. Then give an example of each...
-
If you are a Super Coffee company and want to partner with Influencers on Instagram. How to find them? Influencer suggestions? How much to pay them? Who are they? Your budget is $250,000 So...
-
As the Customer Support Manager in the Fast-Moving Consumer Good (FMCG) sector with the ABC Corporation you are expected to address major grievances of customers from our product line and special...
-
An agent for positive change can be defined as someone who has the capability to influence and motivate those around them to accomplish whatever shared task needed to achieve a common goal, these...
-
Identify stress-reduction techniques used in organizations (e.g., wellness programs) Evaluate the impact of personal and work-related stress on performance Explain the relationship between...
-
Company: Viventium Explain which metrics you recommend tracking and why. For example, "these are the 3 to 5 metrics I've chosen; I'm tracking this because it does X, thereby bringing me closer to...
-
What are the benefits and disadvantages of transfer windows?
-
Global.asax is used for: a. declare application variables O b. all other answers are wrong O c. declare global variables O d. handle application events
-
For H 2 O, the following parameters have been proposed for the van der Waals equation of state: a = 0.5542 Pa m 6 /mol 2 and b = 3.051 10- 5 m 3 /mol. Find the specific volume of water at the same...
-
Explain why the following technique for transaction execution may provide better performance than just using strict two-phase locking: First execute the transaction without acquiring any locks and...
-
For each of the following isolation levels, give an example of a schedule that respects the specified level of isolation but is not serializable: a. Read uncommitted b. Read committed c. Repeatable...
-
Explain why the read-committed isolation level ensures that schedules are cascade-free.
-
Which of the following statement about swaps is least accurate? A. In a plain vanilla interest rate swap, the notional principal is swapped. B. The default problem [i.e. default risk] is the most...
-
7. How much would be in your savings account in nine years after depositing $340 today if the bank pays 9 percent per year? (Do not round intermediate calculations. Round your answer to 2 decimal...
-
Critically evaluate the dividend valuation model and the earnings multiple models
Study smarter with the SolutionInn App