Business solutions for you portfolio


Company: Credit Suisse, Bern

Technology: MS SQL Server, ERWIN.

Link: Not available

People in the project: Stefan Tröhler

Implementation period: Jun 2006 – Apr 2007

Cost: no details

Creation of the relational data model and transfer of the logical data model into the physical data model for the Microsoft SQL Server database with regard to the equity capital statements of Credit Suisse, implemented using ERWIN.

  • Analyse the given task.
  • If necessary, clarify with the business.
  • Identify relevant objects with all relevant properties and the relevant relationships.
  • Formulate relationships graphically and textually.
  • Map the conceptual database schema to a logical database schema.
  • Extend the model to include data-related specifications (field formats, identifying search terms, etc.).
  • Structure logical database schema according to the rules of the structure given by the DBMS.
  • Check that all necessary data are stored in tables.
  • Formulate all specifications in the syntax of the DBMS (ERWIN).
Back to the portfolio
Order a similar project
Order a project

+41 (0)44 586 53 45
+41 (0)76 737 00 84
+41 (0)77 915 25 52


[email protected]

Order a project
Tell us what kind of project you want to do.
Want to order
Upload your brief
For message
Submit project request

User Agreement

With this questionnaire (application) I officially express my consent to the processing (collection, systematization, accumulation, storage, clarification, (updates, changes), use, distribution (including transmission), depersonalization, blocking and destruction), including automated, my personal data specified in this Questionnaire (application), in accordance with the requirements of the law "On personal data".

The personal data specified by the client are provided for the purpose of communication with the client, as well as for informing about other products and services. Consent is provided from the moment of filling of this application for the entire life of the client.

This consent can be revoked by the client upon submission of an application in simple writing in accordance with legal requirements.