Answer / Lav Kumar

Data modeling techniques help to design and create a database schema. Commonly used techniques include Entity-Relationship Modeling (ER), Object-Oriented Modeling (OO), and Class diagrams, which visualize the relationships between different entities or objects in the system.

To convert IDMS to DB2, how to deal with IDMS occurs and redefined clause?

1 Answers  

---

What are the three types of database design?

1 Answers  

---

1. Using the XML Document below, with the URI “recipe.xml” define the following queries in XQuery: a.) Give the names of all breakfast in the menu. b.) Select breakfasts that have price lower than $7.00? <?xml version="1.0"?> <breakfast_menu> <food> <name>Belgian Waffles</name> <price>$5.95</price> <description> two of our famous Belgian Waffles with plenty of real maple syrup </description> <calories>650</calories> </food> <food> <name>Strawberry Belgian Waffles</name> <price>$7.95</price> <description> light Belgian waffles covered with strawberries and whipped cream </description> <calories>900</calories> </food> <food> <name>Berry-Berry Belgian Waffles</name> <price>$8.95</price> <description> light Belgian waffles covered with an assortment of fresh berries and whipped cream </description> <calories>900</calories> </food> <food> <name>French Toast</name> <price>$4.50</price> <description> thick slices made from our homemade sourdough bread </description> <calories>600</calories> </food> <food> <name>Homestyle Breakfast</name> <price>$6.95</price> <description> two eggs, bacon or sausage, toast, and our ever-popular hash browns </description> <calories>950</calories> </food> </breakfast_menu>

1 Answers  

---

Why does this query return 0?

1 Answers  

---

What are the constraints on severity level in raiseerror?

1 Answers  

---

How to replace not in with not exist?

1 Answers  

---

How to generate OIDS

1 Answers  

---

What is bit datatype and what's the information that can be stored inside a bit column?

2 Answers  

---

How to use timestamp datatypes

1 Answers  

---

You have two tables with a one to many join based on a field named id. You need to find records in the parent table that are not represented in the child table. how would you accomplish this?

1 Answers  

---

How is data stored in dbms?

1 Answers  

---

Explain about relational database management systems?

1 Answers  

---