Central database schema, Database Management System

Show a centralised schema to support the operation of the system you have chosen, including in particular: the product catalogue; the outlets and respective stocks; customer records (including PayPal details and purchase history for past 12 months); shopping cart (including whether the order is still in process i.e. active, or has been shipped, i.e. inactive).

Distributed database design

a.  Identify a number of functional units to support the operation of the system you have chosen, including for example: product catalogue, order processing, stock management etc.

b. Make a fragmentation of the schema designed in 3 above which includes at least one primary/derived horizontal partition, at least one vertical partition and at least one replication. Make a case for the usefulness of your distribution, using quantitative estimates from 2 and the organisational substructure in the preceding point.

Justify your decision.

c. Show that your distribution satisfies the correctness rules.

Posted Date: 3/9/2013 12:09:32 AM | Location : United States







Related Discussions:- Central database schema, Assignment Help, Ask Question on Central database schema, Get Answer, Expert's Help, Central database schema Discussions

Write discussion on Central database schema
Your posts are moderated
Related Questions
Define instance and schema?  Instance:  Collection of  data  kept in the  data  base  at  a  particular  moment  is  known as an Instance of the database.  Schema: The o

QUESTION (a) Give two advantages of using Linked List as compared to arrays. (b) (i) You are working as programmer at the Orange Mauritius branch. You have been asked to cre

Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Explain the θ-join and equijoin Refer tables Car and Boat which list models of cars and boats and their relevant prices. Assume a customer wants to buy a car and a boat, but sh

Limitations of File Based System The file-based system has some limitations. The limitations are listed as follows: Isolation and separation of data: When the data is


entity relationship diagram for online examination system

Suppose an instruction takes 1 nanosecond to execute (on average), a page fault takes 20 microseconds of processor time, and it takes 300 microseconds of disk time to read or write

The aims of the project are: 1. To enable the students to undertake the detailed design of a specific plant or process 2. The design projects includes: process selection; und

I want to fragment existing table using java code... help me..!!