• create a sql script that loads your tables with data. Note: in addition to the data present in the table, add several more records for each table in the database, including Client's taking multiple courses and Courses with NO students having taken (think planned course). LANGUAGE SCHOOL TABLE CourseID CourseLanguage 10 11 12 10 11 12 20 21 German German German German German German Japanese Japanese 3 CourseLevel ClientID ClientName Attendance FinalScore C111 Mr. Smith Ms. Jones Mr. Vance Ms. Clark Ms. Wong Ms. Hess Mr. Smith Ms. Jones Basic Intermediate C222 Advanced C333 Basic C C444 Intermediate C555 Advanced C666 Basic C111 Intermediate C222 100% 90% 95% 100% 90% 95% 100% 95% 80% 90% 100% 100% 95% 98% 100% 100%

PLZ HELP WITH THE FOLLOWING QUESTION  Using oralce sql or sql live Create a view named all_volunteer that gets details of all volunteers that assigned tasks in the organization. CREATE TABLE Packinglist(   List_ID INT NOT NULL,   Name VARCHAR(50),   Description VARCHAR(100),   PRIMARY KEY(List_ID)); CREATE TABLE Task(   Task_Code INT NOT NULL,   List_ID INT,   Task_Description VARCHAR(100),   Type VARCHAR(30),   Status VARCHAR(20),   PRIMARY KEY(Task_Code),   FOREIGN KEY(List_ID) REFERENCES Packinglist(List_ID)); CREATE TABLE Volunteer(   Vol_ID INT NOT NULL,   Name VARCHAR(50),   Telephone NUMBER,   Address VARCHAR(100),   PRIMARY KEY(Vol_ID)); CREATE TABLE Assignment(   Vol_ID INT,   Task_Code INT,   Start_Time TIME,   End_Time TIME,   PRIMARY KEY(Vol_ID, Task_Code),   FOREIGN KEY(Vol_ID) REFERENCES Volunteer(Vol_ID),   FOREIGN KEY(Task_Code) REFERENCES Task(Task_Code)); CREATE TABLE Package(   Pack_ID INT NOT NULL,   Task_Code INT,   Date DATE,   Weight FLOAT,   PRIMARY…

For this assignment, write SQL code based on the tables provided. Create three tables  Tables -1.Customer 2.Flower 3.Order Decide what fields, field lengths, and datatypes you need. Do this for each of the 3 tables.  Only use VARCHAR2, NUMBER, and DATE datatypes. Assign a primary key to one field in each table Provide the code to insert the records into each of the tables in the database.

//Using SQL, please make sure your code is working create two tables with one common column example: contacts table -> fields - id, name, phone address table -> fields - id, street_address, city, state, zip insert 10 records in each table (use insert statement) make sure id (first field) are common between two tables' data Apply inner join and full join between two tables and show intersection and union of contacts and address tables Please provide me with all sql statements for creating tables, inserting data, and join sql statments. example: INSERT INTO addresses (id, street_address, city, zip, state)VALUES (1, '1234 John Street', 'Fremont', '94539', 'California');

Based on the ERD below, write the SQL statement to change the job description of “Database Designer” to “Database Developer”. After completing this task examine the results with a select statement. (Hint: Use an Update Statement.)