Use the following table to answer the questions below:Table name: CustomersColumn NameRoleData TypeLengthConstraintcustomerIDstores the ID of a customerChar5Primary keycustFNamestores the first name of a customerVarchar235Cannot be nullcustLNameStores the last name of a customerVarchar235Cannot be nullcustGenderStore the gender of a customerChar1It should be ‘M’ or ‘F’custDOBStores the date of birth of a customerDate custIncomeStore the income of a customerNumber4 Write in SQL a command that creates the table Customers according to the above description (2 marks). Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account (1.5 marks). Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990 (1.5 Marks). Write a SQL query that displays the number of customers who born on the 16th day of a month (1.5 marks). Write in SQL a query that displays the ids of the customers who have the highest income (1.5 marks). Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials (2 marks).

SQL answers to the above first 3 questions are in step2 as per our guidelines we are supposed to…

Answered: Write in SQL a command that creates the…

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter12: Subqueries And Merge Statements

Section: Chapter Questions

Problem 19MC

See similar textbooks

Related questions

Concept explainers

Question

Use the following table to answer the questions below:

Table name: Customers
Column Name	Role	Data Type	Length	Constraint
customerID	stores the ID of a customer	Char	5	Primary key
custFName	stores the first name of a customer	Varchar2	35	Cannot be null
custLName	Stores the last name of a customer	Varchar2	35	Cannot be null
custGender	Store the gender of a customer	Char	1	It should be ‘M’ or ‘F’
custDOB	Stores the date of birth of a customer	Date
custIncome	Store the income of a customer	Number	4

Write in SQL a command that creates the table Customers according to the above description (2 marks).
Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account (1.5 marks).
Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990 (1.5 Marks).
Write a SQL query that displays the number of customers who born on the 16^th day of a month (1.5 marks).
Write in SQL a query that displays the ids of the customers who have the highest income (1.5 marks).
Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials (2 marks).

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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.