Generate the tables attach the primary key and foreign key

Assignment Help Computer Engineering

Reference no: EM132903

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: EM132903

Questions Cloud

Generate a work breakdown structure code : Generate a Work Breakdown Structure Code

Generate a class name that starts with string variable : Generate a class Name that starts with string variable

Create a shadow on phrase html5 canvas : Create a shadow on phrase "HTML5 Canvas"

Accessing and reading a mouse : Accessing and reading a mouse

Generate the tables attach the primary key and foreign key : Generate the tables attach the primary key and foreign key

List the steps involved for conducting a job analysis : List the steps involved for conducting a Job Analysis Define Job Analysis and describe the uses of Job Analysis in a HRM context

Program of five to ten lines in assembly language : Program of five to ten lines in assembly language

Program for dissimilar values for real numbers : Program for dissimilar values for real numbers

Identify and discuss four characteristics of events : Identify and discuss four characteristics of events Using as example an event of your choice, elaborate on the benefits the event brings, in social and economic terms

User Account

All Pages