Design our new database for our new application.

Design our new database for our new application.

We have an access 2000 application which we need to renew, only this time we want to get it right the first time.

We Need:

DBA Expert that make us:

1.? Object Role Model (ORM) Diagrams for our application.

2.? Database relationship diagram for our database.

3.? The coder can use any well-known tool he can find right to create our ORM Diagrams and Database relationship diagram.

4.? The coder must have previous experience on write ORM Diagrams and Database relationship diagram.

Attached examples for what we need.

Our Application:

Signproject (SP) is a Windows application, built in MS Access environment. A source code of the application is stored in Access 2000 mdb file format. End user receives SP in form of compiled mde file, which runs in Access XP RT.

As the main data repository is used MS SQL Server 2000/2005. In SP are used linked objects of SQL Server (tables, stored procedures, user defined functions) and internal objects of Access (tables, queries).

SP provides access to its functional opportunities through menu and macros.

Graphical User Interface for access to data executed as through inner Access objects (Forms, Reports), and through external objects, containing forms and reports. These objects have been developed as .NET class libraries (DLLs, some of them is compiled with possibility to register for COM interop).

SP, depending on configuration, can be used in the head company (Techsign), and in the Desks or in the Distributors. The cases are different in the functionality and stream a products/raw materials directions.

SP includes main modules:

1. Contacts;

2. Customer’s Orders;

3. Purchase Orders;

4. Items & Products;

5. Price Lists;

6. Stock;

7. Manufacture;

8. Search (Contacts, Orders);

9. Email Archive;

10. Reports;

11. Sensors (User’s activity statistics);

12. Tasks (Alerts).

We provide:

1. Full access (Remote Desktop) to our development server.

2. On our server will be:

a. Microsoft access 2000

c. MS SQL Server 2005

d. DEMO database for test

Habilidades: Reescrever Artigos, Redação Publicitária, Research Writing, Redação técnica

Veja mais: writing use cases, writing tables, writing procedures, writing macros, writing functions, writing forms, writing desks, writing activity, what is mdb file, what is an mdb file, what is a mdb file, user diagrams, use cases diagrams examples, use cases diagrams, use cases diagram examples, use cases diagram, technical writing tool, technical writing class, statistics archive, search test cases, remote writing opportunities, remote sql server dba, remote sql dba, raw design, products of design for environment

Acerca do Empregador:
( 82 comentários ) Misgav dov, Israel

ID do Projeto: #3036739