Based on the Tables Below,which of the Following SQL Commands

question 81

Multiple Choice

Based on the tables below,which of the following SQL commands would create an SQL view named CustomerSalesRep that could be used to display CustNo,CustName,RepName?
GENERAL SALES DATABASE:
SALESREP
$$\begin{array} { l | l | l | } \hline \text { SalesRepNo } & \text { RepName } & \text { HireDate } \\\hline 654 & \text { Jones } & 01 / 02 / 1999 \\\hline 734 & \text { Smith } & 02 / 03 / 2000 \\\hline 345 & \text { Chen } & 01 / 25 / 1998 \\\hline 434 & \text { Johnson } & 11 / 23 / 1998 \\\hline\end{array}$$
CUSTOMER
$$\begin{array} { | l | l | l | l | } \hline \text { CustNo } & \text { CustName } & \text { Balance } & \text { SalesRepNo } \\\hline 9870 & \text { Winston } & 500 & 345 \\\hline 8590 & \text { Gonzales } & 350 & 434 \\\hline 7840 & \text { Harris } & 800 & 654 \\\hline 4870 & \text { Miles } & 100 & 345 \\\hline\end{array}$$

• A) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER;
• B) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER
• WHERE CustNo=*;
• C) SELECT CustNo, CustName, RepName FROM SALESREP, CUSTOMER
• WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;
• D) CREATE VIEW CustomerSalesRep AS SELECT CustNo, CustName, RepName
• FROM SALESREP, CUSTOMER
• WHERE CustNo=*;
• E) CREATE VIEW CustomerSalesRep AS SELECT CustNo, CustName, RepName
• FROM SALESREP, CUSTOMER
• WHERE SALEREP, SalesRepNo = CUSTOMER, SalesRepNo;

---

Definitions:

Positivist

Relating to a philosophical approach that emphasizes empirical and scientific evidence to understand and explain phenomena.

Constructionist Perspectives

A theoretical viewpoint that emphasizes the socially constructed nature of reality, suggesting that our understanding of the world is shaped through social interactions and cultural norms.

Constructionist

Pertaining to theories that social phenomena and categories are socially constructed through language, communication, and negotiation.

Deviance

Behaviors, actions, or conditions that violate social norms or values, ranging from minor breaches to major violations, often subject to social judgment.