Old MathJax webview

DBMS Program

2. Convert RDBMS table into XMLtype. For the following Restaurant data. Create tables for restaurant and menu as per xml document shown below. Copy the restaurant information into the 'rest_xmltab' using PL/SQL. diner content/logo.png

1567 Broadway New York United States 40.75930175423635 -73.98525953292847

+2129189999 http://www.diner.com It takes guts to open a restaurant in Times Square that lacks a theme or strives to be classier than a carnival. Granted, Diner offers an audacious voyeur's paradise in its soaring staircase that rises alongside a suspended abstract sculpture of a fork. Mayson Bacon Jr. has succeeded finding a perfect balance between class and bacon. Deep-fried king prawns and Sweet Chili sauce. Deep-fried jalapenos filled with cheese. Served with garlic mayonnaise and out Super Hot Chilisauce. Tortillaa chips, melted cheddar cheese, salsa sauce, jalapeno slices, sour cream & guacamole. Salted fries with bbq sauce. Seasoned Criss Cuts with blue cheese sauce. Sweet potato fries with our special mustard sauce. A mixed green salad with Caesar dressing, Parmesan cheese, croutons and arugula with a choice of chicken breast, marinated shrimps, bacon or chevre. A mixed green salad with cherry tomato, cucumber, fresh pineapple, orange, marinated red onion, watermelon, arugula & deep-fried spring rolls. Served with ranch dressing, toasted bread and Sweet Chili sauce. A mixed green salad with salmon fillet, cherry tomato, cucumber, fresh pineapple, orange, marinated red onion, watermelon, lime & arugula. Oil & herb dressing and toasted bread. Whatever fish comes up, served with seasonal vegetables and Tartar sauce. A huge steak of fresh tuna, baked sweet potato and lime mayo. A 250g sirloin steak, fries, seasonal veggies and BBQ mayo. A 180g sirloin steak, deep-fried king prawns, bell pepper, asparagus, red onion, whiskey- and Bearnaise sauce, Criss Cuts and garnished with arugula. Lamb Loin Chops with minty mushed peas, country fries and creamy mustard sauce. Chicken breast with Latino sauce and salad of cherry tomatos, cucumber, marinated red onion & arugula. Fresh pineapple, garlic mayonnaise and Criss Cuts. Chocolate muffin with white-chock chips, served with vanilla whipped cream. Apple pie with pecan nuts and raisins, served with vanilla ice cream and chocolate sauce. A giant milk shake with a choice of banana- chocolate, chocolate, strawberry-vanilla or mint-chocolate. Made with real fruits and choc. A home made cheesecake served with heaps of whipped cream and Goji-berry & strawberry sauces. Chocolate muffin with white-chock chips, served with vanilla whipped cream. Apple pie with pecan nuts and raisins, served with vanilla ice cream and chocolate sauce. heaps of whipped cream and Goji-berry & strawberry sauces. Apple pie with pecan nuts and raisins, served with vanilla ice cream and chocolate sauce. A giant milk shake with a choice of banana- chocolate, chocolate, strawberry-vanilla or mint-chocolate. Made with real fruits and choc. A home made cheesecake served with heaps of whipped cream and Goji-berry & strawberry sauces. 1. Retrieve the restaurant information into xml form using PL/SQL code. 2. Retrieve the menu details into xml column. 3. Retrieve the info details of subelement as an attribute of info tag. 4. Insert a new category element with a set of dish names. 5. Update "category5" of dish name "Super Cheesecake" into "Super Cheese Sauce