(a) Write the sql syntax to create a table name customer with the following restrictions; Customer(cid, cname, address, age, occupation, salary, payment_mode) Where cid is the primary key. cname and occupation do not accept null values. Payment_mode accepts only cash or credit entries. The default address is “Flacq”. customer is at least 18 years old. Salary is above Rs 25000.
(a) Write the sql syntax to create a table name customer with the following restrictions;
Customer(cid, cname, address, age, occupation, salary, payment_mode)
Where
cid is the primary key.
cname and occupation do not accept null values.
Payment_mode accepts only cash or credit entries.
The default address is “Flacq”.
customer is at least 18 years old.
Salary is above Rs 25000.
(b) Consider the schema of Customer table in part(a) and write SQL statements for the following queries.
i. Write the SQL query to set salary of all administrators to Rs 50 000.
ii. Write the SQL query to display details of customers whose names start with character 'e'.
iii. Write the SQL code to display details of those customers who come from Triolet or Trianon.
iv. Write the SQL code to list details of customers in descending order of age.
v. Write the SQL code to show details of customers where salary is greater than Rs 36000 and age is between 30 and 45.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps