Ask Question, Ask an Expert

+1-415-315-9853

info@mywordsolution.com

Ask DBMS Expert


Home >> DBMS

problem 1)a) What is the criteria for naming of data items in DDBMS? How it could be achieved?

b) describe the following concurrency control methods for distributed transactions:

i) Majority Based Protocol

ii) Biased Protocol

iii) Quorum Consensus Protocol

problem 2)a) Demonstrate the usage of semijoin strategy in distributed query processing.

problem 3)a) describe the following in the context of DTD:

i) Element Specification

ii) Attribute Specification

b) Consider the XML Document based on Bank DTD:
… declarations for branch, balance, customer_name, customer_street and customer_city ]>

a) Give the XPATH expressions for the following:

i) Name the customers whose account balance is more than 10000.

ii) Name the accounts with two or more owners.

b) Give the XQuery expression, which converts the flat structure of the bank information into the nested structure where account elements are nested within customer elements.

c) How can you store the XML data in relational databases using tree representation? Describe.

problem 4)a) How the various geometric constructs can be represented in a database in a normalized fashion?

b) How can you achieve indexing of spatial data by the following?

i) k-d tree

ii) Quadtree

iii) R-tree

c) prepare a brief note on Mobile databases.

DBMS, Programming

  • Category:- DBMS
  • Reference No.:- M96498

Have any Question? 


Related Questions in DBMS

Systems and database design assignment database design amp

Systems and Database Design Assignment: Database Design & Implementation (Airline) The assignment consists of two tasks. The first task, Database Design, requires a word processed document in PDF format detailing the des ...

Itech 1006 - database management systems

ITECH 1006 - Database Management Systems Assignment Overview For this assignment you will implement and query a database from a supplied ER Diagram and Schema. You will be required to write the SQL statements to create t ...

The purpose of the veterinary hospital registration system

The purpose of the Veterinary Hospital Registration system is to handle and record all the information relating to the clients, veterinarians, pets, treatments administered, insurance coverage and appointments (open, clo ...

Database worksheetuse the attached database to complete the

Database Worksheet Use the attached database to complete the following: Create a simple excel spreadsheet with data to update the database. >>> This can hold any type of data to be used in this database In MS Access 1. C ...

Db questions1 what is a consistent database state and how

DB QUESTIONS 1. What is a consistent database state, and how is it achieved? 2. List and discuss the five transaction properties. 3. What is a transaction log, and what is its function? 4. What is a deadlock, and how can ...

A quick guide to pivot tables is found at the end of this

A "Quick Guide to Pivot Tables" is found at the end of this document. Review it BEFORE beginning the questions. The data for this exercise (structured as a flat file) can be found in an Excel workbook located on Blackboa ...

Coit20247 database design and development assignmentyou

COIT20247 Database Design and Development Assignment You must use that sample solution of assignment only for the following tasks: Assessment task- 1. Normalization a) Map the ERD, from the sample solution, into a set of ...

Physical database design assignment query optimisationthis

Physical Database Design Assignment: Query Optimisation This assignment aims to develop your skills optimizing query. It involves identifying the suitable methods for structuring the data and writing the query. First, yo ...

List the different types of locks used by dbms systems and

List the different types of locks used by DBMS systems and explain how they differ from each other. Additionally, suggest the suitable scenario for each of them. 400 to 500 words, at least 4 references with one website r ...

Database reflectionuse the attached database and associated

Database Reflection Use the attached database and associated sheets to review and to make sure the forms are working. Review your project; make sure that all the forms are working. Write a one page report on how you coul ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

A cola-dispensing machine is set to dispense 9 ounces of

A cola-dispensing machine is set to dispense 9 ounces of cola per cup, with a standard deviation of 1.0 ounce. The manuf

What is marketingbullwhat is marketing think back to your

What is Marketing? • "What is marketing"? Think back to your impressions before you started this class versus how you

Question -your client david smith runs a small it

QUESTION - Your client, David Smith runs a small IT consulting business specialising in computer software and techno

Inspection of a random sample of 22 aircraft showed that 15

Inspection of a random sample of 22 aircraft showed that 15 needed repairs to fix a wiring problem that might compromise

Effective hrmquestionhow can an effective hrm system help

Effective HRM Question How can an effective HRM system help facilitate the achievement of an organization's strate