eate an ADD TRIGGER. Explain what the trigger does. Test and show the related results of this trigger. Table 1: CREATE TABLE BSR_PASSENGER (PASSENGER_ID INT NOT NULL UNIQUE, FULL_NAME VARCHAR(30), COUNTRY VARCHAR(40), CITY VARCHAR (40), PRIMARY KEY (PASSENGER_ID)); Table 2: CREATE TABLE BSR_FLIGHT (FLIGHT_ID INT NOT NULL UNIQUE, AIRLINE_NAME VARCHAR(50), CREW_MEMBERS INT, PRIMARY KEY (FLIGHT_ID)); Table 3: CREATE TABLE BSR_BOOKING (BOOKING_ID INT NOT NULL UNIQUE AUTO_INCREMENT, PASSENGER_ID INT NOT NULL, FLIGHT_ID INT NOT NULL, COST DEC(6,3), PRIMARY KEY (BOOKING_ID), FOREIGN KEY (PASSENGER_ID) REFE

Task 1: Run lab_emp.sql and lab_students.sql, this will create 2 tables for you (emp and students) and will fill them with data.     create table emp ( eid number(7), fname char(20), lname char(20), salary   number, primary key (eid) ); insert into emp values (1111111, 'ali', 'ahmed', 3500); insert into emp values(2222222, 'asma', 'dani', 2000); insert into emp values(3333333, 'hassan', 'ali', 4500); insert into emp values(4444444, 'khaled', 'shaalan',6000); insert into emp values(5555555, 'farhad', 'kokol', 7500); insert into emp values(6666666, 'amir', 'sheikh', 10000); insert into emp values(7777777, 'rahul', 'kolap', 11000); insert into emp values(8888888, 'halim', 'ziaey', 21000); insert into emp values(9999999, 'henna', 'bubaker', 30000);     create table students ( sid number, fname char(20), lname char(20), avg   number, age number, primary key (sid) ); insert into students values (1111111, 'ali', 'ahmed', 76, 21); insert into students values(2222222, 'asma', 'dani', 89, 20);…

Write a SUB Query to display name of the Instrument that are manufactured in USA (country).

write Command to insert data into  this tables create table patients ( patient_id VARCHAR(255),`name` VARCHAR(255),`insurance` DECIMAL(15,2),`date_admitted` DATE,`date_checked_out` DATE,PRIMARY KEY(`patient_id`)); create table doctor (doctor_id VARCHAR(255),name VARCHAR(255),specialization VARCHAR(255),PRIMARY KEY (doctor_id) ); create table `test` (`test_id` VARCHAR(255),`test_name` VARCHAR(255),`test_date` DATE,`test_time` TIME,`result` VARCHAR(255),PRIMARY KEY(`test_id`)); create table doctor_patient( patient_id VARCHAR(255), doctor_id VARCHAR(255),PRIMARY KEY(`patient_id`),FOREIGN KEY(`doctor_id`) REFERENCES doctor(`doctor_id`) ); create table test_log (`test_log_id` varchar(255),`patient_id` VARCHAR(255),`test_id` VARCHAR(255),`doctor_id` VARCHAR(255),`comments` VARCHAR(255),PRIMARY KEY(`test_log_id`),FOREIGN KEY(`test_id`) REFERENCES `test`(`test_id`),FOREIGN KEY(`patient_id`) REFERENCES doctor_patient(`patient_id`),FOREIGN KEY(`doctor_id`) REFERENCES doctor(`doctor_id`));

Looking inside a script, you see this line: if [[ 'hostname' = 'bob' ]]; What is it doing? a) Nothing. It is trying to perform an integer comparison on a string. b) Checking to see whether the hostname command was successful. c) Changing the hostname to bob and checking to see whether that was successful. d) Checking to see whether the hostname is bob.

Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT.   ANSWER IN MYSQL PLEASE

Create a table in SQL developer and name it as ‘MyCrush’. The table should consists of only three attributes as follows: Crush_ID which will be the primary key with the number length of .Crush_Name with the maximum character length of 30.Crush_Description with the maximum character length of 10.Insert exactly three records with the above given attributes. Crush_ID values should be 1, 2 and 3 for the three records. Crush_Description should be ‘Present’ for record 1, ‘Past’ for record 2 and ‘Childhood’ for record 3. If you don’t have any crush from your childhood to present, you can insert some random names. Hmm.. Seems Interesting!! It’s time to implement your programming skills using PL/SQL stored procedures and functions. Create another table called ‘MyDetails’ and should contain exactly four attributes as below: Student_ID,Student_Name ,Student_Term ,Student_GPA If you are not a Master’s student, let’s assume you are a student pursuing masters and taking four semesters or terms.…

Create a View to show the city name of any location that has a department. Only show the city name once in the results. You must use a non-correlated subquery.Call this view: Department_LocationsInclude a second query to display from the View after it is created. Refer to the attached for the table.

List all products with their highest unit price, i.e. not discounted.the database is

Write Create Table SQL statements based on the above ERD. All tables must have primary keys. All tables 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 must be used: bid,authid / number(4) title,sname,fname    /   varchar2(30) sellingprice, payrate    /  number(6,2) Table Column Type Range author sname & fname Unique   book title Not Null   book sellingprice Check not negative allocation payrate Check 1 to 79.99