SOLVE THE BELOW PROBLEMS CONSIDERING GIVEN TABLES. PK EMP FK EMPNO ENAME MGR DEPTNO SAL COMMISSION 100 REHAB MANAGER 1236 12 7500 500 101 MAAZ MANAGER 1234 10 so00 300 102 ALI CLERK 135 11 200 104 MAT ARCHITECT 1236 12 so DEPT DEPINO ONAME LOC 10 IT ABHA 11 IS JAZAN 12 CNET RIYADH Problem 1.1: Create a table called EMP with the following structure. Name Iyne EMPNO NUMBER(6) ENAME VARCHAR2(20) JOB VARCHARZ(10) MGR NUMBER(4) DEPTNO NUMBER(3) SAL NUMBER(7,2) Problem 1.2: Add a column COMMISSION which can hold NULL value. Problem 1.3: Modify the column width and data type of the JOB field of EMP1 table.

2.1 Create a Scalar-valued function to get the total of the UnitCost, in the Products table. 2.2 Use the Scalar-valued function created in question 2.2 to print "The Total cost of the products we have is R", return the Total cost from the function in rands. Note: Use  Database and tables created In Tsql CREATE TABLE Categories (    CategoryID int NOT NULL,    CategoryName varchar(255), PRIMARY KEY (CategoryID));   CREATE TABLE Products (  ProductID int NOT NULL,  ProductName varchar(255),  MobileNumber  varchar(255),  ProductImage image,  UnitCost    int ,  Description  varchar(255),  CategoryId int,PRIMARY KEY (ProductID),FOREIGN KEY (CategoryId) REFERENCES Categories(CategoryId) );   CREATE TABLE Review(  ReviewID int NOT NULL,  ProductID int NOT NULL,  CustomerName varchar(255),  CustomerEmail varchar(255),  Rating  int,  Comments varchar(255), PRIMARY KEY (ReviewID),FOREIGN KEY (ProductID) REFERENCES Products(ProductID) );   CREATE TABLE ShoppingCart(  RecordID int NOT NULL,…

Track Addresses Employee Key Values 1234 ЕMP6 ЕMP8 EMP10 EMP12 5678 ЕMP14 EMP16 EMP19 EMP20 9101 EMP26 EMP27 EMP28 EMP29 1121 ЕMP31 ЕMP38 EMP40 EMP42 Index file 1 a. How many comparisions are required to find EMP38 in index file 1 given above b. Update index file by inserting a new employee with employee no. 41. Recreate the index file after updating the index file c. Visualized by recreating the index file how can we reduce camparision to find EMP38

Models Airlines Fleet AID MID Acount manufacturer model capacity Boeing Воeing Вoeing MID AID name 1 777 340 1 American Airlines 1 3 15 2 787 260 United Airlines 1 2 10 3 737 140 Delta Air Lines 2 2 14 4 Airbus 320 230 4 Southwest Airlines 1 Airbus 380 560 5 Alaska Airlines 3. 6. 24 9. Boeing 747 420 3 4 9 5 2 7 3 16 4. Using the above instances of the relational tables Models, Airlines and Fleets, determine whether the following functional dependencies hold. (Write yes/no) 10 ) manufacturer - model Answer: ii) MID – capacity Answer: ii) model → capacity Answer: iv) MID - Acount Answer: v) AID, MID → Accunt Answer: