Notes

create database Lab3;
use Lab3;

Create table Supplier
(SupplierID nvarchar(50) not null Primary Key,
Name nvarchar(50),
Address nvarchar(50));

Create table Product
(ProductID nvarchar(50) not null Primary Key,
Name nvarchar(50),
Price_RM decimal(10,2),
QuantityInStock int);

Create table Supplies
(SuppliesID nvarchar(50) not null Primary Key,
SupplierID nvarchar(50) foreign key references Supplier(SupplierID),
ProductID nvarchar(50) foreign key references Product(ProductID),
SuppliedDate Date, QuantitySupplied int);

Insert into Supplier values
('S01','ABC Company', 'Penang'),
('S02','XYZ Company', 'Johor'),
('S03','HJK Company', 'Selangor'),
('S04','PQR Company', 'Selangor');

Insert into Product values
('P01','Keyboard', 103.55, 60),
('P02','Mouse', 30.90, 70),
('P03','Monitor', 200, 80),
('P04','Pendrive', 40.30, 50);

Insert into Supplies values
('001','S01','P01', '11 January 2017', 100),
('002','S01','P02', '22 February 2017', 200),
('003','S01','P03', Null, 300),
('004','S02','P03', '30 April 2017', 400);

--5(a)
Select * From Supplier;
--5(b)
select Name, Price_RM FROM Product;
--6
Select Address from Supplier;
Select Distinct Address from Supplier;
--7(a)
select * from Supplies where SuppliedDate is NULL;
--7(b)
select * from Supplies where SuppliedDate is not NULL;