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
Question: (a) Discuss the difference between a composite key and a composite attribute. How would each be indicated in an E-R diagram? Support your answer with appropriate exam

Question: This question refers to the database schema. a) Express the following queries in SQL: (i) Write the SQL code that will create the table Company. Your answer sh

File Organisation And Its Types  Just as arrays, trees, lists and other data structures are used to execute data Organisation in main memory, a number of planning's are used to

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE? HAVING CLAUSE - HAVING CLAUSE is used only with SELECT statement. - It is normally used in a GROUP BY

Define What are the desirable properties of a decomposition Ans: What are the desirable properties of decomposition - dependency preserving.  Because Lossless join and dependen

What is RDBMS terminology for a row? A tuple is a RDBMS terminology for a row

using the invoice table shown below,write the relational schema,draw a dependencies,inclunding all partial and transitive dependencies.assume that the table does not contain repeat

What is document scanning and imaging? Document scanning and imaging, or digital archiving, is the method of scanning a document into a digital image to archive and retrieve a

each publisher has uniqe name a mial addrs are also kept on each pubisher.a publisher publish one book.a book publish y one publisher.book identified by isbn.each book writn by one

What is relationship instance ? Relationship Instance - A relationship is a relation between two or more entities. An instance of relationship set is a set of relationships.