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
Define- relational algebra. The relational algebra is a procedural query language. It having of a set of operations that take one or two relation as input and make a new relati

Your OS has a set of queues, each of which is protected by a lock. To enqueue or dequeue an item, a thread must hold the lock associated to the queue. You need to implement an a

Having clause This clause is used for producing conditions on grouped information. Example: Find maximum salary and department number of those departments where maxim

1. Create the tables for the play-scheme database as specified in the TMA. 2. Enter the data as given in the spreadsheet. 3. Create queries to retrieve specified information

Describe the four main ways of optimising disk block access. Ans: a. Disk  b. Non-volatile writes buffers c. File organization (Clustering) d. Log-based file system

The following variant of the primary copy asynchronous-update replication protocol has been proposed for totally replicated systems. (a)  A transaction executing at site A updat

why shadow copy technique is used?

Give Concurrent sub states diagram for the classroom and exam held. In Figure, simultaneous substrates have been taken. After passing Minor 1 test you could give Minor 2 test. T

Define tuple variable? Tuple variables are used for comparing two tuples in the same relation. The tuple variables are explained in the from clause by way of the as clause.

construct an er diagram for a hospital with a set of patients and a set of medical doctors. associate with each patient a log of various test and examination conducted.convert er d