Write a SQL statement to create a table job_history including columns employee_id, start_date, end_date, job_id and department_id and make sure that, the employee_id column does not contain any duplicate value at the time of insertion and the foreign key column job_id contain only those values which are exists in the jobs table. Field EMPLOYEE_ID START_DATE END DATE JOB ID DEPARTMENT ID Type Decimal(6,0) Date Date Null Key Default Extra No pk Null No Null No Varchar(10) No Decimal(4,0) Yes fk Null Null Null ...

Write an SQL query to extract the answer directly.

write SQL statement to search for employees whose manager is specified by the txtEname box

1.What is the result when the following SQL query is executed on a table named products? Choose the most correct answer. SELECT AVG(Products)FROM Products; Group of answer choices The query results in an error because the is no AVG function None of the above The query results in an error be cause a column is not specified The query returns the average of the Products table   2. If the primary key in the Employee table is located in the "ID" column what is the maximum number of results the following SQL SELECT query will return? SELECT *FROM EmployeeWHERE ID = 15; Group of answer choices 2 1 3 Do not have enough information to determine the answer 0

Write Create Table SQL statements Work Session table  The table must have a primary key. The table must have appropriate foreign key constraints. Foreign keys must have the same name, datatype and size of the primary key that they refer to The following columns datatypes and sizes and named constraints must be used Column DataType Constraint WorkYear number(4) Range 2019 - 2020 WorkWeek number(2) Range 1-52 WorkHours number(4,2) Range 0.5 – 99.99 BID NUMBER(4) ,AUTHID NUMBER(4)

Questions 2.

Write SQL code to ensure that the BOOKING_STATUS will only allow the words confirmed, tentative, cancelled, or complete, with the date entered on BOOKING_STATUS_CHANGE_DATE changing to the date when the BOOKING_STATUS is changed. BOOKING BOOKING_ID F' PROPERTY_ID F' PROPERTY_UNIT_NUMBER F' GUEST_ID * BOOKING_STATUS * BOOKING_STATUS_CHANGE_DATE * BOOKING_START * BOOKING_END OTHER DETAILS NUMBER (10) NUMBER (10) CHAR (8 BYTE) NUMBER (10) VARCHAR2 (25 BYTE) DATE DATE DATE VARCHAR2 (100 BYTE) ΒOOKING_PΚ (BOOKING_ID) FK_BOOKING TO_GUEST (GUEST_ID) FK_BOOKING_TO_PROPERTY (PROPERTY_ID, PROPERTY_UNIT_NUMBER) BOOKING_PK (BOOKING_ID)

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.

4. Write a SQL statement to create a view named 'Employees_Purchase which will contain First Name, Last name and Salary of employees who are working in the Purchasing department.

write sql statement to modify the position table in order to define a constraint to ensure that the column position receive only values salad rep or manager course hero