Can you help with these SQL queries?I have uploaded the questions below. Tutorial 8Тopic:Structured Query Language• Write a SQL statement to create a simple tablecountries including columnscountry_id,country_name and region_id.Structure of the table:mysql> DESC countries;| Field| Туре| Null | Key | Default | Extra || COUNTRY_ID| COUNTRY_NAMEvarchar(2)varchar(40)| decimal(10,0) | YES| YES| YES| NULL| NULL| NULLREGION_ID• Write a SQL statement to create the structure of atable dup_countries similar to countries.Structure of the table:mysql> DESC dup_countries;| FieldТуре| NullKey | Default | Extra || varchar(2)| COUNTRY_ID| COUNTRY_NAME | varchar(40)| YES| YESdecimal(10,0) | YES| NULL| NULL| NULLREGION_ID• Write a SQL statement to create a table countriesset a constraint NULL.mysql> desc countries;Field| ТуреNullKeyDefault Extra| NO| NO| decimal(10,0) | NOCOUNTRY_IDvarchar(2)NULLCOUNTRY_NAME | varchar(40)| REGION_ID| NULL| NULL3 rows in set (0.00 sec)• Write a SQL statement to create a table named jobsincluding columns job_id, job_title, min_salary,max_salary and check whether the max_salaryamount exceeding the upper limit 25000.• Write a SQL statement to create a table namedincludingandcountriescolumnscountry_id,country_namemake sure that no duplicate data against columncountry_id will be allowed at the time ofinsertion.region_id and • Write a SQL statement to create a table named jobsincluding columns job_id, job_title, min_salaryand max_salary, and make sure that, the defaultvalue for job_title is blank and min_salary is8000 and max_salary is NULL will be enteredautomatically at the time of insertion if no valueassigned for the specified columns.Write a SQL statement to create a table namedcountriesincludingcolumnscountry_id,country_name and region_id and make sure thatthe country_id column will be a key field whichwill not contain any duplicate data at the time ofinsertion.• Write a SQL statement to create a table job_historyincluding columns employee_id, start_date,end_date, job_id and department_id and makesure that, the employee_id column does notcontain any duplicate value at the time ofinsertion and the foreign key column job_idcontain only those values which are exists in thejobs table.• Write a SQL statement to create a table employeesincluding columns employee_id, first_name,last_name, email, phone_number hire_date,job_id, salary, commission, manager_id anddepartment_idemployee_id column does not contain anyduplicate value at the time of insertion and theforeign key columns combined by department_idand manager_id columns contain only thoseunique combination values, which combinationsare exists in the departments table.andmakesurethat, the

As per our guidelines we are supposed to answer only 1st three parts. Kindly repost the remaining…

Tutorial 8 Тopic: Structured Query Language •Write a SQL statement to create a simple table countries including columns country_id,country_name and region_id. Structure of the table: mysql> DESC countries; | Field Туре | Null | Key | Default | Extra | COUNTRY_ID | COUNTRY_NAME | varchar(2) varchar (40) decimal(10, 0) | YES | YES | YES | NULL | NULL | NULL REGION_ID • Write a SQL statement to create the structure of a table dup_countries similar to countries. Structure of the table: mysql> DESC dup_countries; | Field | Туре Null Key | Default | Extra | varchar(2) | COUNTRY_ID | COUNTRY NAME | varchar(40) | REGION_ID | YES | YES | decimal (10,0) | YES | NULL | NULL NULL • Write a SQL statement to create a table countries set a constraint NULL. mysql> desc countries; | Field Туре Null Key | Default | Extra | COUNTRY_ID | COUNTRY_NAME | REGION_ID | varchar(2) varchar(40) | decimal(10,0) | NO | NO | NO | NULL | NULL | NULL 3 rows in set (0.00 sec) Writo o SOL atoto mont t e oreoto o omad ioha

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

Similar questions

How do you qualify the name of a field in an SQL query? When is it necessary to do so? give few examples
How do you sort the results of a Select query in descending order in SQL?
What is an index in SQL? Also write it's syntax.
How the SQL queries work and what are their types?
What is the use or correlated subquery in oralce sql
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
Explain how to use SQL's identity column feature.
How can we insert data in SQL?
Using php and sql: create a query that will output only the user_id and message for user_id 8
When are aliases in SQL queries particularly useful? What are the risks of not using an alias in a query?
Can you provide me any further information on SQL?
computer fundamental-hack assembly language