Question

Consider the following relation(s) and write the necessary SQL statements to implement

the following desired actions :

Salespeople(snum + sname + city +salary)

Customer(cnum + cname + city + snum(f.k.))

a) Create table salespeople.

b) Create table customer.

c) Drop foreign key constraint on snum column of customer table.

d) Add new column “Qualification” in salespeople table.

e) Find out unique salespeople name w. r. t each city.

f) Find the detail of customers who belong to city whose name begin with ‘p’ and ends

with ‘a’.
​

Answer 1

Answer:

quip app all Zayn seven helps carousel pixel park Israel aware

dschock-full