1. Write SQL statements to create the tables below.2. Write SQL statements to insert at least 5 rows / records into each table.3. Write SQL to display the average Read for all students.4. Write SQL to display the number of students assigned to each Tutor and Tutor Status5. Write SQL to display for each match the duration of assignement and certification date for tutorand Read Score.TUTOR (TutorID, CertDate, Status)TuturIDCertDateStatus1001/05/2008Active1/05/20081/05/2008101Temp StopDropped1025/22/20085/22/20085/22/20085/22/2008103Active104ActiveTemp Stop105106ActiveSTUDENT (StudentID, Read)StudentIDRead30002.330015.630021.330033.330042.730054.830067.830071.5MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate)MatchIDTutorIDStudentIDStartDateEndDate10030001/10/20081/15/20085/15/20083/01/2008210130012/10/20085/28/200810230024106300310330046/01/20086/15/20086/01/20086/01/200810430056/28/200871043006c0 00

Create table : Tutor table CREATE TABLE TUTOR ( TutorId int NOT NULL, CertDate date, Status…

1. Write SQL statements to create the tables below. 2. Write SQL statements to insert at least 5 rows / records into each table. 3. Write SQL to display the average Read for all students. 4. Write SQL to display the number of students assigned to each Tutor and Tutor Status 5. Write SQL to display for each match the duration of assignement and certification date for tutor and Read Score. TUTOR (TutorID, CertDate, Status) TuturID CertDate Status 100 1/05/2008 Active 1/05/2008 1/05/2008 5/22/2008 5/22/2008 5/22/2008 101 Temp Stop Dropped Active Active 102 103 104 105 Temp Stop 106 5/22/2008 Active STUDENT (StudentiD, Read) StudentID Read 3000 2.3 3001 5.6 3002 1.3 3003 3.3 3004 2.7 3005 4.8 3006 7.8 3007 1.5 MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate) MatchID TutorID StudentID StartDate EndDate 100 3000 1/10/2008 3001 1/15/2008 5/15/2008 2 101 2/10/2008 5/28/2008 3 102 3002 3/01/2008 106 3003 6/01/2008 6/01/2008 6/15/2008 6/28/2008 103 3004 6. 104 3005 104 3006 6/01/2008

1. Write SQL statements to create the tables below. 2. Write SQL statements to insert at least 5 rows / records into each table. 3. Write SQL to display the average Read for all students. 4. Write SQL to display the number of students assigned to each Tutor and Tutor Status 5. Write SQL to display for each match the duration of assignement and certification date for tutor and Read Score. TUTOR (TutorID, CertDate, Status) TuturID CertDate Status 100 1/05/2008 Active 1/05/2008 1/05/2008 5/22/2008 5/22/2008 5/22/2008 101 Temp Stop Dropped Active Active 102 103 104 105 Temp Stop 106 5/22/2008 Active STUDENT (StudentiD, Read) StudentID Read 3000 2.3 3001 5.6 3002 1.3 3003 3.3 3004 2.7 3005 4.8 3006 7.8 3007 1.5 MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate) MatchID TutorID StudentID StartDate EndDate 100 3000 1/10/2008 3001 1/15/2008 5/15/2008 2 101 2/10/2008 5/28/2008 3 102 3002 3/01/2008 106 3003 6/01/2008 6/01/2008 6/15/2008 6/28/2008 103 3004 6. 104 3005 104 3006 6/01/2008

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

Related questions

Q: create table emp ( eid number(7), fname char(20), lname char(20), salary number, primary key…

A: Since you have not provided the database name to write the SQL code so I am using MySQL database to…

Q: SQL code for (see image for the table structure): Create a stored procedure “changeCreditLimit” to…

A: The solution is an given below :

Q: use the following data to add a default value unknown to the structure of part .descripti

A: The given ERD has two tables as: Detail_Line PART The relationship is: One details_line has one PART…

Q: Program language: SQLite Table syntax: CREATE TABLE Author( aid INTEGER PRIMARY KEY, name TEXT NOT…

A: The tables are created as in the question. I am updating the table Author with an attribute email.…

Q: Write the following insert statements. 3. Insert a guest into the table, Guest, using the following…

A: Answer: 3)Performing insert statement: INSERT INTO Guest(guestNo, lastName, firstName, phoneNo,…

Q: Complete the SQL statement to generate the Result table. The column names in the SELECT clause must…

A: SELECT Order.OrderCode, Part.PartName, Order.PartNumberSELECT: This keyword is used to specify the…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: n SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created…

A: ANSWER : B Becomes the last column in the table

Q: Write three functions in SQL which does the following: The first function should take an integer…

A: In MYSQL function Syntax to convert number from one base to another follows:- CONV(<num to…

Q: Write the SQL statements to create the table as shown below and attach the screenshot of the output…

A: Write the SQL statements to create the table as shown below and attach the screenshot of the output…

Q: The Magazine table contains three fields. The Cost field is numeric. The Code and Name fields…

A: SELECT * FROM MagazineWHERE Cost>amt1 AND Cost<amt2;

Q: N SQL: For every customer, list the customer number, the customer's entire zip code, and add two…

A: SQL-CREATE TABLE AND INSERT VALUES: BEGIN TRANSACTION; /* Create a table called CUSTOMER */CREATE…

Q: 1. Prepare a list of orders by Shipper showing the Shipper ID, Order ID, Product ID and Quantity.…

A: In this question we have to understand about given SQL database and prepare the list of queries…

Q: with it, paste your code in a text file named Student.txt and save it in your task folder. Write the…

A: This is a SQL question, here first we have to create a table student with a given parameter, then we…

Q: T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer…

A: Given : T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer…

Q: SQL: Dog Data In each question below, you will define a new table based on the following tables.…

A: In this query, we aim to construct a table named by_parent_height that provides a comprehensive view…

Q: 4. Display a list of all book titles and the percentage of markup for each book. The percentage of…

A: SQL commands:- Structured Query Language is what it stands for. When using a database to carry out…

Q: Create a function to determine the total pledge amount for a project. Use the function in an SQL…

A: SQL stands for standard query language.It is a domain specific language used in programming and…

Q: 2. Write a SQL statement to insert a new user with userId ‘XXXXX’ into the users table and populate…

A: The question has been solved in step2:

Q: SQL: Dog Data In each question below, you will define a new table based on the following tables.…

A: In tackling this task, the objective is to create a table named size_of_dogs that captures the size…

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

1. Write SQL statements to create the tables below.
2. Write SQL statements to insert at least 5 rows / records into each table.
3. Write SQL to display the average Read for all students.
4. Write SQL to display the number of students assigned to each Tutor and Tutor Status
5. Write SQL to display for each match the duration of assignement and certification date for tutor
and Read Score.
TUTOR (TutorID, CertDate, Status)
TuturID
CertDate
Status
100
1/05/2008
Active
1/05/2008
1/05/2008
101
Temp Stop
Dropped
102
5/22/2008
5/22/2008
5/22/2008
5/22/2008
103
Active
104
Active
Temp Stop
105
106
Active
STUDENT (StudentID, Read)
StudentID
Read
3000
2.3
3001
5.6
3002
1.3
3003
3.3
3004
2.7
3005
4.8
3006
7.8
3007
1.5
MATCH HISTORY (MatchID, TutorID, StudentID, StartDate, EndDate)
MatchID
TutorID
StudentID
StartDate
EndDate
100
3000
1/10/2008
1/15/2008
5/15/2008
3/01/2008
2
101
3001
2/10/2008
5/28/2008
102
3002
4
106
3003
103
3004
6/01/2008
6/15/2008
6/01/2008
6/01/2008
104
3005
6/28/2008
7
104
3006
c0 00

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1 1)

VIEW

Step 2 2)

VIEW

Step 3 3)

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.

Similar questions

in sql The ALTER SEQUENCE statement can be used to: Select one: a. Change the maximum value to a lower number than was last used b. Change the name of the sequence c. Change the START WITH value of a sequence d. Change the amount a sequence increments each time a number is generated
1) Write the SQL code to add a column that shows the full name of the Employee in the Employee Table. The expecting format should be “Firstname Initial Lastname” (e.g., “John G News” for the EMP_NUM 101) 2) Write the SQL code to add a binary variable “Hire_prior_2000” in the Employee table. If the hire year (year of hire needs to be identified) is prior to 2000, then Hire_prior_2000=1, other wise Hire_prior_2000=0.
Database
SQL Server Please help answer question 5 Please type out the answer because I cannot read the last answer because the handwriting is not very clear. Thank you.
SQL procedure a. Write a procedure in SQL that inserts a new customer record into the "Customers" table. b. Create a procedure that updates the quantity of a product in the "Inventory" table based on the product ID. c. Write a procedure that calculates the average salary of all employees in the "Employees" table and displays the result.
7. Determine the length of data stored in the ISBN field of the BOOKS table. Make sure eachdifferent length value is displayed only once (not once for each book). SQL commands
SQL: For every invoice, display the invoice number, invoice date and the total dollar amount for all products purchased in the invoice, ordered by invoice number in descending order and then by invoice date in ascending order. Here you will use an aggregate SUM(x,y) function in your SELECT clause to calculate the total dollar amount (a calculated field – name it TOTAL). Don’t forget to join on the tables as well. [hint: you should have 8 rows of output ordered properly]. select inv_number, inv_date sum(list_price) as 'total' from invoice, line order by desc inv_num, asc inv_date. I am getting the error: ORA-00923: FROM keyword not found where expected Am I formulating the query incorrectly?
Q1. Please write a query statement from emp table to display employee's empno, ename, length of ename, number of 'S',and number of 'L'. SQL> SELECT empno AS "EmpNo", ename AS "Emp Name", ... AS "Name Length", .... AS "# Of S", .... AS "# Of L"FROM emp; [IMAGE below] Material to answer the question above: Material: https://drive.google.com/file/d/14OwWDIybjAIeuHCO7McupV08gJs9nB-8/view?usp=sharing https://drive.google.com/file/d/1npRH8JoJ6GYBzPU3iNjLXluvCyhr2tMu/view?usp=sharing
How can you dynamically execute a SQL query in PL/SQL? a. Using EXECUTE IMMEDIATE statement b. Using DBMS_SQL package c. Using FETCH statement d. Using OPEN-FOR statement