Question: please answer both. Lab 2 (20 points) Write SQL statements that populate the following datasets. Departments id name Marketin Sales budget 10,000,000 20,000,000 2 Employees

please answer both.

please answer both. Lab 2 (20 points) Write SQL statements that populate

Lab 2 (20 points) Write SQL statements that populate the following datasets. Departments id name Marketin Sales budget 10,000,000 20,000,000 2 Employees id name James John Patricia salar 100,000 200,000 300,000 age 32 2 35 Works In d id work time 30 40 50 2 2 Dependents name Daniel Lab 3 (10 points) Write SQL statements that delete all tuples associated with "James

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

LAB 1 CREATE TABLE EMPLOYEE(EMP_ID INT PRIMARY KEY, EMP_NAME VARCHAR(20),EMP_AGE INT,SALARY INT); CREATE TABLE DEPENDENTS(DEPNDT_NAME VARCHAR(20),EMP_ID INT,DEPNDT_AGE INT,FOREIGN...

PLEASE WRITE UP/ SCREENSHOT SPOOL FILE. ONLY NEED SPOOL FILE. CODE IS PROVIDED BELOW. NEED ACTUAL SPOOL FILE NOT DIRECTIONS! LAB 1 CREATE TABLE EMPLOYEE(EMP_ID INT PRIMARY KEY, EMP_NAME...

ONLY NEED SPOOL FILE!! PLEASE ATTACH SPOOL FILE!! HERE IS THE CODE: LAB 1 CREATE TABLE EMPLOYEE(EMP_ID INT PRIMARY KEY, EMP_NAME VARCHAR(20),EMP_AGE INT,SALARY INT); CREATE TABLE...

only question 2.. plz help me.. im offering all my credits. i swear... Faculty of Business, Economics & Accounting Department of Accounting and Finance HELP Bachelor of Business (Hons) Year 3...

Question 1 , Question 2 and Question 5 part (ii) thanks alot Faculty of Business, Economics & Accounting Department of Accounting and Finance HELP Bachelor of Business (Hons) Year 3 INTERNAL SUBJECT...

This SQL project in three Phases and the instruction as below: Instructions Follow the steps and let me know if you have any questions. The intent of the project is to create a project you can use in...

***I have posted this question now five times. Each time I am told I need more information so I add something and no one returns back to answer; which means I have now wasted five questions. Can...

***I have posted this question now six times. Each time I am told I need more information, I add something and no one returns to answer. Yesterday I posted everything and no one has responded; which...

Using the information provided in the chapter background and gathered from the exercise on CS2-15, Complete the following: a. Perform a risk assessment of BUS?s growth-related change initiatives,...

List and briefly define three types of superscalar instruction issue policies.

Extreme Clean Ltd (hereafter "Extreme Clean") is a manufacturing company that specialises in manufacturing cleaning supplies and equipment. Extreme Clean has a 31 March financial year end. During the...

Supporters of direct costing have contended that it provides management with more useful accounting information. Critics of direct costing believe that its negative features outweigh its positive...

Bidwell Leasing purchased a single-engine plane for its fair value of $834,564 and leased it to Red Baron Flying Club on January 1, 2021. (FV of $1, PV of $1, FVA of $1, PVA of $1, FVAD of $1 and...

10. Are you a. a leader? b. a follower? _______

5. Would you prefer a job that a. is pretty much the same from day to day? b. changes constantly? _______

3. In terms of your career, do you think you are or will mostly be a. fixed in place? b. always moving? _______