SophiaPretty

(5)

$14/per page/Negotiable

About SophiaPretty

Levels Tought:
Elementary,Middle School,High School,College,University,PHD

Expertise:
Accounting,Algebra See all
Accounting,Algebra,Applied Sciences,Architecture and Design,Art & Design,Biology,Business & Finance,Calculus,Chemistry,Communications,Computer Science,Economics,Engineering,English,Environmental science,Essay writing Hide all
Teaching Since: Jul 2017
Last Sign in: 304 Weeks Ago, 6 Days Ago
Questions Answered: 15833
Tutorials Posted: 15827

Education

  • MBA,PHD, Juris Doctor
    Strayer,Devery,Harvard University
    Mar-1995 - Mar-2002

Experience

  • Manager Planning
    WalMart
    Mar-2001 - Feb-2009

Category > Computer Science Posted 13 Dec 2017 My Price 10.00

course of a single day, billions of financial transactions occur

I need some help with this. Thank you for your help

  • Part 2  

    Project 2 Financial Data Transactions

     

     

    Over the course of a single day, billions of financial transactions occur. There is an important need to keep track of all the data for the financial firms, the customers who buy and sell, and the government who needs to makes sure that everything is running by the law.

     

    Customers:

    The customer database needs to have the customer name, product name and item bought. The above is a foreign key Customer_ID. Then there is needs to be place for the customer’s holding positions as well as the remaining positions.

    There then needs to be a primary key with Payment Method (Payment_Method_Code). This is used to show many different banks that the customer needs to fund their account.

     

     

    Financial Firms:

    When a financial transaction occurs, there are least two counterparties: the multiple buyers and the multiple sellers called Customer_ID. Then there needs a place for price to make sure the amount is bought and sold is listed to the customer who did those things.

     

    Government:

    The government needs to make sure that that taxes are collected from the sale of securities. The dates of these transactions are needed to make sure that the transactions happened during the same calendar year.

     

     

     

    Customers

    Attribute Name

    Data Type

    Size

    Constraint/ Domain

    Cascading Problems

    Customer_ID

    Varchar

    12

    Varchar(12)

    Primary key

    Payment_Method_Code

    Varchar

    12

    Varchar(12)

    null

    Customer_name

    Char

    35

    Char(30)

    Not null

    Product name

    Char

    35

    Char(30)

    Not null

    Item_bought_name

    Varchar

    25

    Varchar(25)

    Not null

     

     

     

    Primary keys: Customer_ID

     

    Foreign keys: Account_ID-references Account ID in government table,

    Indices: CREATE INDEX Customer_name

    ON Customers (Customer_name); UPDATE INDEX Customer_name

    ON Customers (Customer_name); DELETE INDEX Customer_name

    ON Customers (Customer_name);

     

    Financial Firms

    Attribute Name

    Data Type

    Size

    Constraint/ Domain

    Cascading Problems

    Tranaction_ID

    varchar

    12

    Varchar(12)

    Primary key

    Customer_ID

    Varchar

    12

    Varchar(12)

    Foreign key

    price

    Currecy

    Double

    Currency(double)

    Not null

    Item_sold_name

    Varchar

    25

    Varchar(25)

    Not null

    Customer_name

    Varchar

    25

    Varchar(25)

    Not null

     

    Primary Keys: Transaction_ID

     

    Foreign Keys Customer_ID-references Customer_ID in customers table

    Indices: CREATE INDEX Item_sold_name ON Financial Firms (Item_sold_name);

    UPDATE INDEX Item_sold_name ON Financial Firms (Item_sold_name); DELETE INDEX Customer_name

    ON Financial Firms (Item_sold_name);

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Government

    Attribute Name

    Data Type

    Size

    Constraint/ Domain

    Cascading Problems

    Account_ID

    Varchar

    12

    Varchar(12)

    Primary key

    Account_name

    Char

    35

    Varchar(35)

    Not null

    Date

    Date

    Dd/mm/yy

    Date(dd/mm/yy)

    Not null

    Transaction_ID

    Varchar

    12

    Varchar(12)

    Foreign key

    social security number

    Varchar

    12

    Varchar(12)

    Not null

     

     

    Primary Keys: Account_ID

     

    Foreign Keys Tranaction_ID-references Transaction ID in Finacial firms

    Indices: CREATE INDEX Account_name ON Government (Account_name);

    UPDATE INDEX Transaction_Type ON Government (Transaction_Type);

    DELETE INDEX Transaction_Type ON Government (Transaction_Type);

     

Attachments:

Answers

SophiaPretty
(5)
Status NEW Posted 13 Dec 2017 01:12 PM My Price 10.00

-----------  ----------- H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly

Not Rated(0)
Relevent Questions