This computer science problem involves algorithmic thinking and programming concepts. The solution below explains the approach, logic, and implementation step by step.
ScanSolve AI Answer
c) The SQL code to populate the tables with 3 records each and one additional record for the Product table is as follows: Company Table Population: `sql INSERT INTO Company (CompanyID, CompanyName, CompanyQuantity) VALUES ('C01', 'VTX', 12); INSERT INTO Company (CompanyID, CompanyName, CompanyQuantity) VALUES ('C02', 'TAPT', 34); INSERT INTO Company (CompanyID, CompanyName, CompanyQuantity) VALUES ('C03', 'PORSH', 22); ` Product Table Population (3 records + 1 additional): `sql INSERT INTO Product (ProductID, ProductName, CostPrice) VALUES ('P01', 'Fans', 500); INSERT INTO Product (ProductID, ProductName, CostPrice) VALUES ('P02', 'Rice', 9000); INSERT INTO Product (ProductID, ProductName, CostPrice) VALUES ('P03', 'Leves', 7000); INSERT INTO Product (ProductID, ProductName, CostPrice) VALUES ('P04', 'Chairs', 1500); -- Additional record ` Supplier Table Population: `sql INSERT INTO Supplier (SuppID, SuppName) VALUES ('S01', 'Tima'); INSERT INTO Supplier (SuppID, SuppName) VALUES ('S02', 'Xofnet'); INSERT INTO Supplier (SuppID, SuppName) VALUES ('S03', 'Tima'); ` Supplied Table Population: `sql INSERT INTO Supplied (CompanyID, ProductID, SuppID) VALUES ('C01', 'P03', 'S02'); INSERT INTO Supplied (CompanyID, ProductID, SuppID) VALUES ('C02', 'P01', 'S03'); INSERT INTO Supplied (CompanyID, ProductID, SuppID) VALUES ('C03', 'P02', 'S03'); ` i) The SQL query to display the Company name, product name, and cost price of products supplied by 'Tima', ordered by company name: `sql SELECT C.CompanyName, P.ProductName, P.CostPrice FROM Company AS C JOIN Supplied AS S ON C.CompanyID = S.CompanyID JOIN Product AS P ON S.ProductID = P.ProductID JOIN Supplier AS Sup ON S.SuppID = Sup.SuppID WHERE Sup.SuppName = 'Tima' ORDER BY C.CompanyName; ` Expected Result: | CompanyName | ProductName | CostPrice | | :---------- | :---------- | :-------- | | PORSH | Rice | 9000 | | TAPT | Fans | 500 | ii) The SQL code to display the number of companies that supply products that cost above 500