Say we have a table named TradingBook with fields: TradeId, CounterpartyID, BuyOrSell, Ticker, PriceDealt, and Number...

 

Transcribed Image Text:

Say we have a table named TradingBook with fields: TradeId, CounterpartyID, BuyOrSell, Ticker, PriceDealt, and Number Of Shares, and a table named Counterparties with fields: CounterpartyID, LongName, and Country. None of these fields is allowed to be missing in the database and the primary key for each of these tables is the first field. (e) Write the CREATE TABLE SQL instruction that creates the second table. You are free to choose details such as data type but make sure you make meaningful choices. (f) Write the CREATE TABLE SQL instruction that creates the first table ensuring you create a relationship between it and the second table. (g) Write a SQL instruction that displays all the trade information (TradeId, CounterpartyID, Buy OrSell, Ticker, PriceDealt, and Number Of Shares) for all trades with counterparties domiciled in Bahamas (Country='Bahamas'). [ Say we have a table named TradingBook with fields: TradeId, CounterpartyID, BuyOrSell, Ticker, PriceDealt, and Number Of Shares, and a table named Counterparties with fields: CounterpartyID, LongName, and Country. None of these fields is allowed to be missing in the database and the primary key for each of these tables is the first field. (e) Write the CREATE TABLE SQL instruction that creates the second table. You are free to choose details such as data type but make sure you make meaningful choices. (f) Write the CREATE TABLE SQL instruction that creates the first table ensuring you create a relationship between it and the second table. (g) Write a SQL instruction that displays all the trade information (TradeId, CounterpartyID, Buy OrSell, Ticker, PriceDealt, and Number Of Shares) for all trades with counterparties domiciled in Bahamas (Country='Bahamas'). [