Re: rbdms

From: HansF <news.hans_at_telus.net>
Date: Mon, 25 Oct 2004 17:58:35 GMT
Message-ID: <f9bfd.504$9b.483@edtnps84>

rohit srivastava wrote:

> Your design should include:
>
> I. The global schema, fragmentation schema and allocation schema.

Analyze the problem. Come up with possible entities. Validate & Normalize. Assume appropriate distribution technology (varies between vendor) to define the fragmented schema.

> II. SQL commands / application code for above queries / applications.

Assume a direct relationship between entity and table. Write the appropriate DDL statements.

> III. How the response for application 1 and 2 will be generated?

Write the appropriate data retrieval and DML statements.

> Assuming these are global queries, explain how various fragments will
> be combined to generate the query response.

Depending on your distribution mechanisms, you might want to write distributed queries and merge the responses.

You have 5 days. Suggest you start collaboratng with your fellow students if the above does not give sufficient information to proceed.

/Hans Received on Mon Oct 25 2004 - 12:58:35 CDT