Coursework (Distributed Relational Database Model)

Coursework (Corporate Information Systems)


Develop a model of the distributed relational database companies, consisting of a main manufacture and multiple remote offices. Some of the enterprises are linked computer network have their own local databases can use these remote sites. Global information is stored on a central site.

To develop an application that provides the creation, modification, and retrieval of data. Assume that all the local databases located on the same computer.


Requirements:

The number of local databases> = 3;

The composition of the separate local database: linked table (at least 2), indexes, stored procedures, triggers, generators;

The number of records in one table> = 10;

Operations over the database: create, modify, search the database;

Database: InterBase;

Languages: SQL, Delphi.

Data integrity: use the machine transactions, stored procedures, triggers;

CASE-use design tools software.


Sequence of operation:

Describe the composition and functioning of the mission of the enterprise;

Build UML-diagrams use case and classes to the database of the enterprise;

Build infological model "entity-relationship" database of the enterprise;

Build a relational database model of the enterprise;

Split the database on a local database of the central production and branches;

Perform initial filling of the database;

Write a program database operations.


The structure of the explanatory note:

Title page;

Table of Contents;

Formulation of the problem;

Description of the structure and functioning of the enterprise;

UML-diagrams of the enterprise;

The model "entity-relationship" database of the enterprise;

The relational database model;

Decomposition of the database on a local database;

Description of the programs (the principle of operation, visual forms, code snippets)

Applications: DB table filled, program listings;

Literature.


Option setting: 8. CIS "Research Institute";

-------------------------------------------------- --------------------

Programs implemented in Delphi windowed interface. In exchange, in the archive are the source 4-yoh programs (Delphi 7) with detailed comments, 3 local database (InterBase), files CASE-tool Rational Rose, the original diagram (.png and .fla - macromedia), an explanatory note ( 82str). Evaluation of the teacher posed: Excellent. Lined only 9 screens, as on the trading floor limit in the number of screenshots.

-------------------------------------------------- --------------------

PS Use this job as teaching material, an example of which you

You are able to develop and deliver its program of work the teacher perfectly.