Write in SQL a command that creates the table Supplier according to the above description .Write in SQL a statement that adds a new column named comapnyID of type char(5). This column should be defined as a foreign key that relates the table Supplier to the table Company . Write in SQL a query that lists the full names (first and last names) of all suppliers arranged in ascending order according to their date of births . Write a SQL query that displays the number of suppliers who born in December . Write in SQL a query that displays the ids of the suppliers who supply the highest number of products . Create a view named ‘SupplierDetails’ to hold all the details of suppliers whose last names start with ‘bait’ and who supply between 50 and 200 products . Table name: SupplierColumn NameRoleData TypeLengthConstraintStores the ID of asupplierStores the first namesupplierIDNumber10Primary keysupplierFNameVarchar230Cannot be nullof a supplierStores the last Nameof a suppliersupplierLNameVarchar230Cannot be nullsupplierDOBStores the date of birthDateof a suppliersupplierNBProShould be greaterthan 10Stores the number ofNumber3products supplied by asupplier

Note: since your question contain multiple-sub parts question but we can answer only first 3-sub…

Answered: Write in SQL a command that creates the…

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

Related questions

Question

Write in SQL a command that creates the table Supplier according to the above description .
Write in SQL a statement that adds a new column named comapnyID of type char(5). This column should be defined as a foreign key that relates the table Supplier to the table Company .
Write in SQL a query that lists the full names (first and last names) of all suppliers arranged in ascending order according to their date of births .
Write a SQL query that displays the number of suppliers who born in December .
Write in SQL a query that displays the ids of the suppliers who supply the highest number of products .
Create a view named ‘SupplierDetails’ to hold all the details of suppliers whose last names start with ‘bait’ and who supply between 50 and 200 products .