Please show the output for question 1,2,3,4 as screen shots Output:1.1RacetrackRacehostsRacetrackD (PK)RacelD (PK)3.NameRacetraco (FK)CityNameDate1.INSERT INTO race (racetrack_id, name, date)Figure 72. Related table: Race2VALUES (1, "Austria 2020", "2020-07-05"),1. Write and run the following SQL statements(2, "Hungary 2020", "2020-07-19");41•e CREATE TABLE race (5.SELECT.2race_idINT AUTO_INCREMENT NOT NULL,6FROM race33racetrack_idINT NOT NULL,VARCHAR (250) CHARACTER SET utf8mb4 NOT NULL,nameUPDATE racedateDATE NOT NULL,PRIMARY KEY (race_id),2SET date = "2020-07-12"6NHERE race_id - 237FOREIGN KEY (racetrack_id) REFERENCES racetrack(racetrack_id)38 );Output:Output4.2. In the race table INSERT a few values:Hint as below:SELECTINSERT INTO racetrack (name, city)2FROM race1.WHERE race_id - 33VALUES ("Red Bull Ring", "Spielberg"),3("Hungaroring", "Budapest");4.Output:SELECT *FROM racetrack

Output: Racetrack Race hosts RacetrackD (PK) RaceiD PKI 3. Name Racetracko (FK) Cty Name Date INSERT INTO race (racetrack_id, name, date) Figure 72. Related table: Race VALUES (1, "Austria 2020", "2020-07-05"), 2 1. Write and run the following SQL statements 3 (2, "Hungary 2020", "2020-07-19"); 4 1•e CREATE TABLE race ( 5. SELECT • race_id INT AUTO_INCREMENT NOT NULL, INT NOT NULL, FROM race; 3 racetrack_id 4 name VARCHAR (250) CHARACTER SET utf8mb4 NOT NULL, 1. UPDATE race date DATE NOT NULL, SET date - "2020-07-12" WHERE race_id - 23 6. PRIMARY KEY (race_id), FOREIGN KEY (racetrack_id) REFERENCES racetrack(racetrack_id) 3 8 Output: Output: 4. 2. In the race table INSERT a few values: Hint as below: SELECT • FROM race INSERT INTO racetrack (name, city) VALUES ("Red Bull Ring", "Spielberg"), 1. 3 WHERE race_id - 33 ("Hungaroring", "Budapest"); 4 Output: SELECT FROM racetrack 6.

Output: Racetrack Race hosts RacetrackD (PK) RaceiD PKI 3. Name Racetracko (FK) Cty Name Date INSERT INTO race (racetrack_id, name, date) Figure 72. Related table: Race VALUES (1, "Austria 2020", "2020-07-05"), 2 1. Write and run the following SQL statements 3 (2, "Hungary 2020", "2020-07-19"); 4 1•e CREATE TABLE race ( 5. SELECT • race_id INT AUTO_INCREMENT NOT NULL, INT NOT NULL, FROM race; 3 racetrack_id 4 name VARCHAR (250) CHARACTER SET utf8mb4 NOT NULL, 1. UPDATE race date DATE NOT NULL, SET date - "2020-07-12" WHERE race_id - 23 6. PRIMARY KEY (race_id), FOREIGN KEY (racetrack_id) REFERENCES racetrack(racetrack_id) 3 8 Output: Output: 4. 2. In the race table INSERT a few values: Hint as below: SELECT • FROM race INSERT INTO racetrack (name, city) VALUES ("Red Bull Ring", "Spielberg"), 1. 3 WHERE race_id - 33 ("Hungaroring", "Budapest"); 4 Output: SELECT FROM racetrack 6.

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

Rstudio app using the diamonds dataset, write in the line below the code necessary to make sure that only the diamonds (observations) with carat bigger or equal to 0.3 and cut equal to ideal are included in the dataset. what's the code
How would you change the code below position, to make it look like the picture.
with comments please for the codes
Please do not give solution in image format thanku
Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
Click cell C9 and insert a VLOOKUP function that looks up the code in cell B9, compares it to the codes and types of art in the range B2:C6, and returns the type of art. Copy the function in cell C9 to the range C9:C54. Hide column B that contains the codes.
10. Using the INDEX function only, write a formula in cell H10 to find the state name having the minimum "Sum of Percentage". The formula should include the value(row number) that is calculated in G10. Thank you screenshot attached
User Satisfaction team wants to send monthly summaries for each user. They need the following details with the user ID: The last day of the month when the users traveled most recently One week after the last day of the month when the users traveled most recently You need to return a three-column output with USER_ID, LAST_TRAVEL_MONTH and NOTIFICATION. LAST_TRAVEL_MONTH should be calculated using the MAX of the LAST_DAY of the TRAVEL_END_TIME field. Similarly, NOTIFICATION should be calculated with DATE_ADD function to add one week.
"""Q3: Create a series called 'directors' that contains each director's name and his or her average rating. Print out the type of your variable.Use the 'directors' series to find the average rating for Steven Spielberg. Print the value.""" Please help I keep getting series are different!!
The title of the show will appear as follows at the top of the screen:
In cell B6 in the Purchasing sheet, insert the payment function to calculate the monthly payment using cell references, not numbers, in the function, and make sure the function displays a positive result. Apply Accounting Number Format and the Output cell style to cell B6.