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 1 Discuss on transmission impairments Question 2 What is framing? Question 3 Write a note on 10Base2 10Base- T Question 4 Explain the rev

What are the problems if one were not to normalize?  When do these problems surface?           Ans:  Database normalization, sometimes considered to as  canonical synthesis, is

Construct a generalization-specialization hierarchy for a motor-vehicle sales company. The company sells motorcycles that comprise an engine number and cost; cars that have a chass

Retrieve the S&S In-Chapter Database (in Microsoft Access format) from the text's Web site (or create the tables in Table 4-5 in a relational DBMS product). Write queries to answer

explain exhausitively the problems associated with er diagrams with ellustrations

Concurrency issues Data integrity: Threads accessing same object need to be synchronized, such as: banking account. Deadlock: One or more threads in system are perman

Question 1 Indexes are ocasionally defines on a single field of a file called an indexing field. List and describe the different types of indexes Question 2 Consider a book i

What is a data dictionary? Data Dictionary is a main source of data in a data management system.  Its major function is to carry the creation and management of data definition

Adding Redundant Associations for Efficient Access The expression redundant association means using "duplicate association for proficient access". While analysis, it is not a

A domain is a set of permissible values that can be given to an attribute. So each attribute in a table has a definite domain. Values to these attributes cannot be assigned outside