This sub-system is BankTrade system

This use to insert all trade operation transactions in bank database such as Guarantee, Letter of credit, Standby letter of credit, cCllection, Export.

The problem was we cant use one system (interface) to print all outstanding of client products on one time. We should use other systems to reach this result

How to solve this problem by using SQL 2012, see below:

Description of tables

In a couple of sentences, provide a brief description of each table in your database. Also include a short description of the columns/attributes from each table.

Description of keys - Primary, foreign, composite

In a couple of sentences, provide a brief description of the primary, foreign and composite keys for each table.

Data types for each attributes

In a couple of sentences, provide reasoning for selecting data types for each attribute/column.

Description of relationships

In a couple of sentences provide a brief description of the relationships between the tables of your database.

ER/Class Diagram--Draw the class diagram for your proposed database.