Table name: SupplierColumn NameRoleData TypeLengthConstraintsupplierIDStores the ID of a supplierNumber10Primary keysupplierFNameStores the first name of a supplierVarchar230Cannot be nullsupplierLNameStores the last Name of a supplierVarchar230Cannot be nullsupplierDOBStores the date of birth of a supplierDate- supplierNBProStores the number of products supplied by a supplierNumber3Should be greater than 10 a. 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 Companyb. Write in SQL a query that displays the ids of the suppliers who supply the highest number of products. c. 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.

Syntax : Alter table table_name Add column_name datatype , foreign key(col_name) references…

Answered: Table name: Supplier Column Name Role…

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Concept explainers

Question

Table name: Supplier
Column Name	Role	Data Type	Length	Constraint
supplierID	Stores the ID of a supplier	Number	10	Primary key
supplierFName	Stores the first name of a supplier	Varchar2	30	Cannot be null
supplierLName	Stores the last Name of a supplier	Varchar2	30	Cannot be null
supplierDOB	Stores the date of birth of a supplier	Date	-
supplierNBPro	Stores the number of products supplied by a supplier	Number	3	Should be greater than 10

a. 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

b. Write in SQL a query that displays the ids of the suppliers who supply the highest number of products.

c. 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.

Expert Solution

Step by step

Solved in 3 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.

Similar questions