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…

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

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter3: Table Creation And Management

Section: Chapter Questions

Problem 7HOA: Create a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail,...

See similar textbooks

Similar questions

Create a new table containing these four columns from the existing BOOKS table: ISBN, Cost, Retail, and Category. The name of the ISBN column should be ID, and the other columns should keep their original names. Name the new table BOOK_PRICING.
Create a new table containing these four columns: Emp#, Lastname, Firstname, and Job_class. The table name should be EMPLOYEES. The Job_class column should be able to store character strings up to a maximum length of four, but the column values shouldn’t be padded if the value has less than four characters. The Emp# column contains a numeric ID and should allow a five-digit number. Use column sizes you consider suitable for the Firstname and Lastname columns.
Create a view called HOMEWORK13 that includes the columns named Col1 and Col2 from the FIRSTATTEMPT table. Make sure the view is created even if the FIRSTATTEMPT table doesn’t exist.
SQL: Add a table-level PRIMARY KEY constraint to the EMPLOYEE table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Create a PRIMARY KEY constraint on the DEPARTMENT table using the ID column. The constraint should be named at creation. (Which means you'll need to drop the table, then recreate.) Add a foreign key reference on the EMPLOYEE table that will ensure that the employee is not assigned to a nonexistent department. Confirm that the constraints were added by querying USER_CONSTRAINTS. Note the types and names of the constraints and include them in your statement comments. Display the object names and types from the USER_OBJECTS data dictionary view for EMPLOYEE and DEPARTMENT tables. You will want to format the columns for readability. Provide comments that include the new tables and indexes created. Modify the EMPLOYEE table by adding a SALARY column of NUMBER data type, precision 7. Confirm…
A new table has been requested to support tracking automated emails sent to customers.Create the table and add data as described below Tablename: email_logColumns: emailid (numeric), emaildate (datetime), customer# (numeric)Primary key: emailid column, define as an Identity Column Add the following data rows and display resulting rows (if any errors occur, explain why theerror is expected)
1. Create the My Employee table with the following fields: Not Null ID Last Name First Name Userid Salary 1 2 3 4 5 2. Add the constraint Primary Key (ID) to the table. 3. Insert the following data to the table: ID Last Name First Name Ali Number(4) Varchar(25) Varchar(25) Varchar(8) Number(9,2) AlChameri Alanizi Hejazi Turki AlKamel Rayen Decham Mohamed Fahhed Userid raptel bdancs bbiri cnewman aropebur Salary 795 860 1100 750 1550 I 4. Select all the data in the table. 5. Change the Last Name of employee 4 to Turkish. 6. Change the Salary to 1000 for all employees with a salary less than 900
A new table has been requested to support tracking automated emails sent to customers. Create the table and add data as described below.• Tablename: email_log• Columns: emailid (numeric), emaildate (datetime), customer# (numeric)• Primary key: emailid column, define as an Identity Column• Add the following data rows and display resulting rows (if any errors occur, explain why the error is expected)1. Emaildate ¼ current date, customer# ¼ 10072. Emailid ¼ specify to use the column default value, emaildate ¼ current date, customer# ¼ 10083. Emailid ¼ 25, emaildate ¼ current date, customer# ¼ 1009 (refer to the tables in the JustLee Books database).
The table VideoVisitFact has a single primary key column of VideoVisitKey. The column is numeric. Which of the following returns the number of rows in the VideoVisitFact table? A. SELECT MAX (VideoVisitKey) FROM VideoVisitFact B. SELECT COUNT (*) FROM VideoVisitFact C. SELECT (*) FROM VideoVisitFact D. SELECT SUM(VideoVisitKey) FROM VideoVisitFact

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science

ISBN:

9780357392676

Author:

FREUND, Steven

Publisher:

CENGAGE L

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Np Ms Office 365/Excel 2016 I Ntermed

Computer Science

ISBN:

9781337508841

Author:

Carey

Publisher:

Cengage

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781285196145

Author:

Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

COMPREHENSIVE MICROSOFT OFFICE 365 EXCE

Computer Science