Design and building a distributed information system, Database Management System

The scenario

You have been approached to design and implement a prototype of a distributed information system for a national car part retail outlet chain. The company comprises of numerous garage retail outlets that each keep their own stock and sell parts to various customers. A central warehouse despatches parts to the various garages according to their individual stock management requirements. At present stock is managed individually at the many retail outlets. Likewise sales, customers, orders are all managed locally. As the new IT expert, you have suggested an integrated distributed information system that will provide better stock management and reporting.

The prototype system functionality

Local garage outlets

1. Local staff will have the capabilities to sell parts from local stock.

2. Local staff will have the capabilities to order parts from the warehouse or from other garage.

3. Local staff are able to recording customer details and take payments.

4. Re-order levels should be automated.

5. Emergency query a local garage for an item of stock.

Note: emergency deliveries are dispatched for express overnight delivery.

The warehouse

1. Maintain a level of stock sufficient to meet the needs of the numerous local garage outlets.

2. Set national prices for products.

3. Set national discounts and offers for products.

4. Dispatch stock to the local garage outlets.

Note: deliveries to each garage occur once every week.

Managers

1. Have all of the functionality of Local managers and the warehouse.

2. Can view summary of national sales.

3. Can view summary of local sales.

4. Can view summary of national stock.

5. Can view summary of local stock.

All information used in your system should as a minimum be stored at the warehouse

Your task

Based on the a bove requirements it is necessary to build the prototype as a distributed system with a number of different user interfaces, one for each of the users. You should implement a 3-tier architecture.

The system should persistently save data in a database. The choice of technology is  ours.

Likewise the user interfaces can be built using any technology of your choosing. Care should be taking to achieve a 3-tier architecture.

You should produce and submit a document of your UML design for the proposed system

along with screen shots of your implementation and a brief description of your implemented product. You should also produce a ZIP file containing your software code and a brief report describing what you have achieved.

Deliverables

Based on the above requirements it is necessary to build the prototype as a distributed system with a number of different user interfaces, one for each of the users identified in your design. You should design and implement a 3-tier architecture.

You should document a UML design for the proposed system.

The implemented prototype system should persistently save data in a database. The choice of appropriate technology for your centre will be determined by your local tutor, this includes the technology for distribution1 (middleware, RMI, web services, etc.), the database (Oracle, SQL server, MYSQL, Postgres, MS Access, etc.) and also the application/user interface technology (Java, Java Servlets, .NET, ASP.NET, VB.NET, etc.).

Posted Date: 2/21/2013 7:53:22 AM | Location : United States







Related Discussions:- Design and building a distributed information system, Assignment Help, Ask Question on Design and building a distributed information system, Get Answer, Expert's Help, Design and building a distributed information system Discussions

Write discussion on Design and building a distributed information system
Your posts are moderated
Related Questions
WRITE SHORT NOTES ON INDEX STRUCTURE OF FILES? There are two basic parts of indices 1.   Ordered indices 2.   Hash indices Every technique must be evaluated on the bas

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

What does conceptual design work? A conceptual design involves modelling independent of the DBMS.

Having Clause with sub queries: First we have to recollect the GROUP BYclause. The following query searches the minimum salary in every department. SELECT DEPTNO, MIN (SAL)

One-way Associations When an association is traversed only in the one direction, then it is implemented as a pointer i.e.an attribute which contains an object reference. If mu

What are ways of finding out either an update is required or not for derived attributes? The ways to find out an update is required or, not are as: Explicit update

A collection of a same kind of entities is known as an Entity Set or entity type. Example: For the COLLEGE database defines earlier objects of concern are Students, Faculty,

What is Cardinality Ratio? Cardinality Ratios - The cardinality ratios for relationship kinds specifies the maximum number of relationship instances in which an entity can pa

Which sorting technique is used to sort databases, whose sizes are very big?  Give one such algorithm.  Why do sorting techniques like quicksort, insertion sort, etc.  not applied

Control as a State Machine Engine First let us define the state machine: "the state machine is a machine which is an object but not an application object. It is a part of lang