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.
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.
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:
2. Customer’s Orders;
3. Purchase Orders;
4. Items & Products;
5. Price Lists;
8. Search (Contacts, Orders);
9. Email Archive;
11. Sensors (User’s activity statistics);
12. Tasks (Alerts).
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