(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. Using SQL, write the command to add a new column in the customer table with the following data definition; (Column “gender” of char data type and field size of 1). ii. Write the SQL query to display the cid and gender of all employees. iii. Write the SQL code to list all supervisors whose salary is greater than Rs 30000.
(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. Using SQL, write the command to add a new column in the customer table with the following data definition; (Column “gender” of char data type and field size of 1). ii. Write the SQL query to display the cid and gender of all employees. iii. Write the SQL code to list all supervisors whose salary is greater than Rs 30000.
Database Systems: Design, Implementation, & Management
11th Edition
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Chapter11: Database Performance Tuning And Query Optimization
Section: Chapter Questions
Problem 2P: Problem 1 and 2 are based on the following query: SELECT EMP_LNAME, EMP_FNAME, EMP_AREACODE, EMP_SEX...
Related questions
Question
100%
(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. Using SQL, write the command to add a new column in the customer table with the following
data definition; (Column “gender” of char data type and field size of 1).
ii. Write the SQL query to display the cid and gender of all employees.
iii. Write the SQL code to list all supervisors whose salary is greater than Rs 30000.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Recommended textbooks for you
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781285196145
Author:
Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:
Cengage Learning
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781305627482
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning