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.
I ask you to leave your positive feedback, thank you.
No feedback yet