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
What are the different strategies of implementation of the Statecharts?  There are two strategies for implementation of state charts: i)   Basic Implementation Strategy

Birla Institute of Technology & Science, Pilani Work-Integrated Learning Programmes Division Second Semester 2012-2013 EC-1 Assignment 2 (7.5% of the grade) Course No. : SS ZG

There are a number of possible solutions to the open ended brief. One of the simple ones is shown here without the PKs and FKs. It is important to think of how a number of tasks

Oracle Fusion Middleware: Key Skills: Consulting,Architect, Oracle Fusion Middleware,ECM, UCM, Stellent,Identity Management, SOA Suites, BPEL, ESB,OAM,OIM,J2ee, Java, Livelink

entity relationship diagram about finance

We have a new website where I need someone to 1: Inhabit the back end with all the recruitment agencies in the UK. I require someone who is not manually going to do this, but who w

CREATE YOUR DATABASE TABLES Your database project must have a minimum of four tables. Include the SQL scripts used to create the tables in your documentation. Explain the tables

Discuss how the bi-directional Implementations are made. In bi-directional implementation of the association, a pair of references must implement every link. The declarations a

#question.what is mapping constraints and types?.

Explain Data Sublangauges ? Data sublanguage: In relational database theory, the term sublanguage, first used for this purpose through E. F. Codd in the year of 1970, refers t