Roles of Data Modeler


Data modeler will create three types of data models based on the page design given by the Business Analyst.

First data model is, Conceptual data model which includes

-> Entity names

->Entity relationship

Second data model is, Logical data model which includes

->Entity names

->Entity relationship

->Attributes

->Primary key

->Foreign key

Third data model is, Physical data model which includes

->Table Name

->Column Name

->Column Data type

->Primary key

->Foreign key

                                 Table Creations



                                 Clients_Table


create table c_clients(client_id number not null,client_details varchar(255),Constraint c1 primary key(client_id));



                                    Accounts_Table


create table a_accounts(account_id number not null, client_id number,
account_details varchar(255),Constraint c2 primary key (account_id),foreign key(client_id) References c_clients(client_id));


                                   Financial_products_table


create table f_products(f_product_id number not null,f_product_details varchar(255), 
Constraint c3 primary key(f_product_id)); 


                                    Asset_Table


create table a_asset(asset_id number not null,asset_details varchar(255),Constraint c4 primary key(asset_id));


                                    Brokerage_Table


create table b_broker(broker_id number not null,broker_details varchar(255),Constraint c5 primary key(broker_id));
           

                                     Mobile_Device_Table


create table m_device(mobile_device_id number not null,mobile_details varchar(255),Constraint c6 primary key(mobile_device_id));



                                    Staff_Table


create table s_staff(staff_id number not null,mobile_device_id number,staff_details varchar(255),Constraint c7 primary key(staff_id), foreign key(mobile_device_id) References m_device(mobile_device_id));


                                    Deals_table


create table d_deals(deal_id number not null, account_id number,asset_id number, broker_id number ,f_product_id number,staff_id number,generic_deal_details varchar(255),Constraint c8 primary key(deal_id), foreign key(account_id) References a_accounts (account_id),foreign key(asset_id) References a_asset (asset_id),foreign key (broker_id) References b_broker(broker_id),foreign key(f_product_id) References f_products (f_product_id), foreign key(staff_id) References s_staff (staff_id));


                                   
                              Transactions_Table



create table t_transactions(transaction_id number not null, deal_id number,
transaction_details varchar(255),Constraint c9 primary key (transaction_id),foreign key(deal_id) References d_deals(deal_id));

                             
                                 Settlements_Table



create table s_settlement(settlement_id number not null, deal_id number,settlement_deal_details varchar
(255),Constraint c10 primary key (settlement_id),foreign key(deal_id) References d_deals
(deal_id));  


                                  Ref_Currencies_Table



create table r_currencies(currency_code char(15),currency_name varchar(255),current_USD_exchange_rate  REAL,Constraint c11 primary key 
(currency_code));


                                Deals_Currencies_Table



create table d_currencies(deal_currency_id number not null, currency_code char(15),currency_deal_details varchar(255),Constraint c12 primary key 
(deal_currency_id),foreign key(currency_code) References r_currencies(currency_code)); 

                                  

                                     Deals_General_Table



create table d_general(deal_general_id number not null, details_general_details varchar(40),Constraint c13 primary key 
(deal_general_id)); 


                                      Deals_Fx_Table


create table d_fx(deal_fx_id number not null, details_fx_details varchar(40),Constraint c14 primary key 
(deal_fx_id));