a SELECT DISTINCT on the results set.IILActivities1) In this activity, refer to the Construct Company schema studied in activity one of lab 3.a) Load the ConstructCompany Schema.sql script and execute it to create all the tables of theschema. Use this database to answer the following questions.b) Write the SQL code to enter the rows shown in the following Figure inside the table EMP 1.EMP_NUM EMP LNAMENewsSeniorArboughRamorasJohnsonSmithfield101102EMP FNAME EMPNTIAL EMP HIREDATE JOB CODEJohnDavidG08-Nov-00 502H12-Jul-89 501103104105June01-Dec-96 500AnneK15-Nov-87 50101-Feb-93 50222-Jun-04 500AliceK106107108109WilliamAlonzoMariaD10-Oct-93 500Washington Ralph22-Aug-91 501SmithLerry18-Jul-97 501c) Write the SQL code that will list all attributes for a job code of 502.d) Write the SQL code that will save the changes made to the EMP_1 table.e) Write the SQL code to change the job code to 501 for the person whose employee number(EMP_NUM) is 107. After you have completed the task, examine the results, and then resetthe job code to its original value.f) Write the SQL code to delete the row for the personon June 22, 2004, and whose job code classification is 500William Smithfield, who was hiredg) Write the SQL code required to list all employees whose last names start with Smith.ndows bulwalacl Jhilh) Using the EMPLOYEE, JOB, and PROJECT tables in ConstructCompany Schema, write theSQL code that will produce the result shown in the following Figure.(Soi iallTOSHIBAF6F7F8BVDF10F11F12INSSCROLL LOCK6.&7.V.8.- BAT.P.1.HiJ1.%3D

SQL statements are written for MySQL or Oracle database. b. Inserting values into table EMP_1…

questions. Write the SQL code to enter the rows shown in the following Figure inside the table EMP_1. EMP NTIAL EMP NUM EMP LNAME EMP FNAME EMP HIREDATE JOB_CODE 08-Nov-00 502 12-Jul-89 501 101 News John 102 103 Senior David Arbough June 01-Dec-96 500 104 Ramoras Anne 15-Nov-87 501 105 106 107 Johnson Alice 01-Feb-93 502 Smithfield William 22-Jun-04 500 10-Oct-93 500 Alonzo Maria 108 Washington Ralph Larry B 22-Aug-91 501 109 Smith 18-Jul-97 501 OHEKK

questions. Write the SQL code to enter the rows shown in the following Figure inside the table EMP_1. EMP NTIAL EMP NUM EMP LNAME EMP FNAME EMP HIREDATE JOB_CODE 08-Nov-00 502 12-Jul-89 501 101 News John 102 103 Senior David Arbough June 01-Dec-96 500 104 Ramoras Anne 15-Nov-87 501 105 106 107 Johnson Alice 01-Feb-93 502 Smithfield William 22-Jun-04 500 10-Oct-93 500 Alonzo Maria 108 Washington Ralph Larry B 22-Aug-91 501 109 Smith 18-Jul-97 501 OHEKK

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

code of create table and insert table only please
SQL Create table named Student, with the following rules and constraints Column Name Data Type Length Constraints SID Number 8 Primary Key Sname Varchar2 30 Unique DoB Date
11
SQL Problem- How do I create this and provide code please.
Q5: From the Customer table given below write SQL queries for the following question?  Write a query to display the record of the last name and city with unique state? Write a query to display the record of the distinct cities of the customers? Write a query to display the records of customers' address whose names contain letter “a”?
Questions 3.
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 SQL Database Add the four maintenance types to the MAINTENANCE_TYPES table Test Query SELECT * FROM MAINTENANCE_TYPES Expected Results MAINTENANCE_TYPE_ID MAINTENANCE_TYPE_DESCRIPTION MAINTENANCE_PRICE 1 Tire Change 50 2 Oil Change 45 3 Full Cleaning 100 4 Gas Pump Change 145
pls help me SQL Instructions: Answers ALL the questions. This test contributes 5% to your coursework. Use the following Table to write the queries. Emp_Infor Table EmpID EmpFname EmpLname Department Salary 1 Mohd Ali HR 2000 Admin Account 2 3 4 5 Azizah Chen Ananthi Manjit Suliman Kang Kulkarni Sidhu HR Admin Address Kuantan Ipoh 1800 8000 DOB 01/12/1977 02/05/1975 3500 5000 Kuala Lumpur 01/01/1984 Georgetown 02/05/1995 Kangar 03/07/1998 1. Write the query to display all the records in the Emp_Infor table. Gender MFMFM 2. Write a query to display the number of employees working in the department 'HR'.
using the link below, select which data type best fits the following needs: https://www.w3schools.com/sql/sql_datatypes.asp The Date a student enrolls with a university The students phone number The name of a degree program The students financial aid amount
Resort that charges the highest You have to only develop a SQL query Write a query to display the resort name, rate of all the resorts that charges the highest. Sort the output on the resort name. Use:Resort,cabincost table) RESORT MANAGEMENT SYSTEM Town Pointofinterest Manager Number Varchar(30) varchar(30) PK pointID Number PK towniD PK manageriD Number townname varchar(30) varchar(30) describe Varchar(30) name state opentime varchar(10) address longitude varchar(30) closetime varchar(10) city varchar(20) varchar(30) Number Number latitude towniD Number phone varchar(15) FK summertemp wintertemp sealevel Number GIVES Resort Guest Review PK resortiD Number PK guestiD Number FK,PK guestlID Number resortName varchar(30) name varchar(30) FK.PK resortID Number street varchar(30) MANAGES address varchar(30) + dateofreview Date varchar(30) townname varchar(20) varchar(30) country BOOKS email comments varchar(150) FK townid Number phone varchar(15) starRating Number FK manageriD Number…
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)