Question: Consider The Following Tables In A Relational Database. Provide The Appropriate “SELECT” SQL Statement Necessary To Answer The Queries That


  1. Consider the following tables in a relational database.Provide the appropriate “SELECT” SQL statement necessary to answerthe queries that follow. Primary keys are underlined and foreignkey fields have an asterisk at the end of the field.

CUSTOMERS (CUST-NO, C-NAME, C-ADDRESS,BALANCE)

SALESPERSONS (SP-NO, S-NAME,DATE-EMPLOYED, SALARY)

SALES (INVOICE-NO, DATE, CUST-NO*,SP-NO*)

a) List the salesperson name andsalary for all sales to customers whose balance outstanding isgreater than 20000.

b) List the names and addresses of allcustomers who have been sold merchandise by salespersons employedbefore 1/1/96.

  1. Find all violations of entity and referentialintegrities.  
  2. 2. Find all violations of entity and referential integrities. CUSTOMERS CUSTOMER NAME ADDRESSI ADDRESS STATE STR BALANCE 456Accounting InformationSystems

Show transcribed image text

Leave a comment

Your email address will not be published. Required fields are marked *