7.Add a foreign key constraint to the shows table: the column net_id is the foreign key, referencing the column idfrom the networks table.Take a screenshot now and paste it here.8.Show the structure of your table shows.Take a screenshot now and paste it here.9.Insert the following data in your database. You may use more than one INSERT statement.titlenum_episodes countrystartendnetworkDaniel Tiger105USA2012NULLPBSHandy Manny113USA20062013Disney [mysql> select * from shows;| ID | Title| Num_episodes | Country| Start | Endnet_id |+---1 | Bluey53 | Australia |81 | USA110 | Canada136 | USA77 | Canada350 | USA109 | USA263 | USA81 | Singapore |685 | USA65 | USA31| USA76 | USA2018 | NULL |1990 | 1998 ||2 | Bobby's World3| Caillou|1||5 |1997 | 2010 |2012 | 2020 |2013 | NULL |1999 | NULL |2013| 2018 |74 | Doc McStuffins5 | Doki6 | Family Guy7 | Sofia the First8 | SpongeBob SquarePants9 | The Loud House| 10 | The Simpsons| 1 | Chip 'n Dale12 | The Little Mermaid| 13 | Little Einsteins43|5 |4 ||1999 | NULL |2016 | NULL |1989 | NULL |1989 | 1990 |1992 | 19942005 | 200966 |5 |4 |24+----13 rows in set (0.01 sec)[mysql> select * from networks;+---| id | name+1 | АВС Кids| 2 | CBS|3 | Discovery Kids4 | Disney|5| Fox|6 | Nickelodeon7 | Teletoon+.7 rows in set (0.00 sec)[mysql> DESC NETWORKS;| Field | Type| Null | Key | Default | Extra| int(11)| varchar(20) | YES| id| name| NO| PRI | NULL| auto_increment || NULL|+.2 rows in set (0.01 sec)[mysql> DESC SHOWS;| Field| Туре| Null | Key | Default | Extra| int(11)| ID| Title| Num_episodes | int(11)| Country| Start| End| net_id| NO| varchar (80) | NO| NO| varchar (60) | NO|| PRI | NULL| NULL| NULL| NULL| NULL| NULL| NULL| auto_increment || int(11)| int(11)| int(11)| NO| YES| YES+-7 rows in set (0.01 sec)

Hey, since multiple questions posted, we will answer first question according to our policy. If you want any specific question to be answered, then please submit that question only or specify the question number in your message. 7. Explanation: Foreign key constraint is used to link two tables. It is also called referencing key. They related using the primary key of one table with a foreign key of another table.Query: Creating networks and shows tables. CREATE TABLE networks ( id int NOT NULL, name text, PRIMARY KEY (id) ); CREATE TABLE shows ( ID int NOT NULL, Title text, Num_episodes int, Country text, Start text, End text, net_id int, PRIMARY KEY (ID) ); Adding foreign key constraint to shows table. ALTER TABLE shows ADD FOREIGN KEY (net_id) REFERENCES networks(id);Screenshot:

Engineering

Computer Science

7. Add a foreign key constraint to the shows table: the column net_id is the foreign key, referencing the column id from the networks table. * Take a screenshot now and paste it here. 8. Show the structure of your table shows. * Take a screenshot now and paste it here. 9. Insert the following data in your database. You may use more than one INSERT statement. title num_episodes country start end network Daniel Tiger 105 USA 2012 NULL PBS Handy Manny 113 USA 2006 2013 Disney

7. Add a foreign key constraint to the shows table: the column net_id is the foreign key, referencing the column id from the networks table. * Take a screenshot now and paste it here. 8. Show the structure of your table shows. * Take a screenshot now and paste it here. 9. Insert the following data in your database. You may use more than one INSERT statement. title num_episodes country start end network Daniel Tiger 105 USA 2012 NULL PBS Handy Manny 113 USA 2006 2013 Disney

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

Task 6: The Car Maintenance team considered that the available maintenance tasks should also have the price information in the database. Alter the MAINTENANCE_TYPES table to include a new column named MAINTENANCE_PRICE of type FLOAT. ANSWER IN MYSQL PLEASE
question 6 use the picture below to answer the following question Add a ZIP field/column to the customer table.
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
Create a view, using JOBS, DEPARTMENTS, and JOB_HISTORY tables that will include department name (not ID), job title (not jobID), start date, and end date for all rows in the JOB_HISTORY table Using your view, write a query that shows the number of rows (count) for each department. Write a query that uses your view from above to select the columns department name, job title, and end date for all rows where the department name includes the string “Sale” that is NOT case-sensitive. Use a function. i.e. SALE, SaLe, Sale, sAle, etc. should all match a row
Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx as the value for the employee ID for every row inserted. You may choose values for the other columns Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row). Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebin
create tables appointments having columns appointment id as primary key, appointment time, appointment date, doctor id doctors having doctor id as primary key, doctor name providers having provider id as primary key, provider first name, last name, username, password, office code. Now create a provider first name as Lilly , Last name as Brooks, username as Lily_777, password as Brooks_666. Validate on the database also show me the appointments with Dr.Alex at 10.30A.M