Project description MICROSOFT SQL SERVER PROJECTS

Microsoft development, database development and database administration, web portals and OO development...

Justinian – Microsoft SQL Server, Microsoft Access, VBA, T–SQL

t–cos GmbH

MS SQL Server – SQL, T–SQL, VBA

t–cos GmbH, Feldbrunnen

PROJECT LINK: Not available
Persons in the PROJECT: Stefan Troehler
PROJECT Duration: Feb 2004 - Dec 2005
PROJECT value: SFR. 00,000.00

SQL

Project portfolio
0
HOURS REQUIRED
0
CUP OF COFFEE
0
LINES IN THE CODE
0
EXPERTS IN THE PROJECT

Implementation of a performance recording for the company t-cos Feldbrunnen. In a first prototype Microsoft Access is used as a database, the user interfaces are already being developed in this prototype using VB .NET. In version 2 the Microsoft Access database is replaced by a Microsoft SQL Server and a large part of the logic is transferred from the user interfaces to the backend in the form of stored procedures and functions.

  • Developing a performance record as a supplement to the worldwide
  • patented systems from t-cos GmbH (working time recording using
  • biometric data).
  • Times recorded by biometric data are assigned to a project or an order using a service catalog.
  • Services defined in this way are in turn assigned to a customer via project or order.
  • The customer administration takes place via client administration.
  • The time recording data is stored in a Microsoft SQL Server.
  • The performance recording data is saved in a Microsoft Access 2000 database.
  • There is an automated synchronization (trigger) between time recording data and performance data.
  • The user interfaces are developed using VB.NET.
  • Requirement engineering, data model using design.
  • Implementation of customer requirements using Microsoft SQL Server, Microsoft Access 2000, Microsoft Visual Basic for Application, T-SQL and Microsoft VB.NET.
  • Testing and documentation (user and technical).