Question
Customer
ID (Number) Name (Varchar)
10001 Akash Kumar
10002 Vijay Chopra
10003 Rahul Mishra
Transactions
ID (Number) CUST_ID(Number) STOCK_SYM(varchar) TYPE(varchar) QTY(Number)
1 10001 UNITECH BUY 100
2 10003 UNITECH SELL 200
3 10001 DLF BUY 500
4 10001 DELTA BUY 450
5 10002 DLF BUY 110
1. Generate the tables exposed above and use the data types mentioned in the column headers. The underlined columns in every table are the primary keys for that table. CUST_ID in transactions table is foreign key and references ID in Customer table. Please attach the primary key and foreign key constraints as well.
2. Populate table with the data shown above.
3. Show all the stocks, their quantity and the quantity invested in those stocks for ‘Akash Kumar' (You don't know his customer ID)