Questioncustomer id number name varchar10001 akash

Assignment Help Computer Engineering

Reference no: EM13348955

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)

Reference no: EM13348955

Questions Cloud

Question1 create 15 or more decomposed work packages into 4 : question1. create 15 or more decomposed work packages into 4 levels that are assigned to 5 or extra main tasks 75 line

Questiongenerate a class name that starts with string : questiongenerate a class name that starts with string variable first set to your first name and the string variable

Questioncreate a shadow on phrase html5 canvas with an : questioncreate a shadow on phrase html5 canvas with an offeset -x of 2px an offset-y of 5px a blur of 6px and a

Questionnbsppart 1-the goal is to design a memory system to : questionnbsppart 1-the goal is to design a memory system to support a small amount of data storage outside of the

Questioncustomer id number name varchar10001 akash : questioncustomer id number name varchar10001 akash kumar10002 vijay chopra10003 rahul mishratransactionsid number

Question 1 a clearly explain what you understand by the : question 1 a clearly explain what you understand by the term recruitment and list down the factors affecting

Questionwrite a short program of five to ten lines in : questionwrite a short program of five to ten lines in assembly language to accomplish something. your program should

Questionwrite down an interactive program that prompts user : questionwrite down an interactive program that prompts user for three real numbers and finds the sum average smallest

Question 1help wantedin the early october gaetan ah kong : question 1help wantedin the early october gaetan ah kong the owner of chez gaetan catering company came into the

User Account

All Pages