Creation of the relational data model or transferring the logical data model into the physical data model for the Microsoft SQL Server database with regard to the Credit Suisse equity statements, implemented by means of ERWIN.

• Analyze the given task.
• If necessary, clarify with the business.
• Collect relevant objects with all relevant properties and the relevant relationships.
• Formulate relationships graphically and textually.
• The conceptual database schema on a logical database schema
• Extending the model to include technical data (field formats, identifying search terms, etc.).
• Structure logical database schema according to the rules of the structure given by the DBMS.
• Check whether all necessary data is stored in tables.
• Formulate all information in the syntax of the DBMS (ERWIN).