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 is Stored Procedure? A stored procedure is a named group of SQL statements that have been previously formed and kept in the server database. Stored procedures accept input

Define Deadlock recovery measures                   To recover from deadlock, the cycle in the wait-for-graph should be broken. The common technique of doing this is to rollbac

What is called block-level striping? Block level striping stripes blocks across many disks. It treats the array of disks as a large disk, and provides blocks logical numbers

What function divides one numeric expression by another and returns the remainder? MOD function divides one numeric expression by another and returns the remainder.

What are views? Explain how views are different from tables? A view in SQL terminology is a one table in which is derived from other tables. These other tables could be base t

sir we want er diagram of bank management system in this main menu option as new account,deposit amount,withdraw amount,all acount holder list,modify account,close account

Explain What is Relation? A database relation is a predefined row or column format for storing information in a relational database. Relations are equal to tables.

Define DBA database administrator? DBA : A database administrator (DBA) is a person who is responsible for the environmental aspects of a database. In common, these involves:

Discuss the differences among the candidate keys and the primary key of a relation. Give instance to describe your answer? A candidate key is one that can be used as primary ke

Find a 3NF decomposition of the following relation scheme: University (Faculty, Dean, Department, Chair, Professor, Rank, Student}. The University relation satisfies the following