1.List all the data in your table shows. Your table should have at least 13 records (inserted in A1 and A2).Take a screenshot now and paste it here.2.Create a table networks, with columns id and name. The field id must be a primary key, integer and not null,with auto_increment. The field name will contain the network's name. It must be VARÇCHAR(20) or longer.Take a screenshot now and paste it here.3.Insert the following network names into the table networks.nаmeАВС KidsCBSDiscovery KidsDisneyFoxNickelodeonTeletoon [mysql> select * from shows;+--| ID | Title| Num_episodes | Country| Start | End1 | Bluey2 | Bobby's World3 | Caillou4 | Doc McStuffins5 | Doki6 | Family Guy| 7 | Sofia the First8 | SpongeBob SquarePants9 | The Loud House10 | The Simpsons11 | Chip 'n Dale| 12 | The Little Mermaid| 13 | Little Einsteins53 | Australia |81 | USA110 | Canada136 | USA77 | Canada350 | USA109 | USA263 | USA81 | Singapore |685 | USA65 | USA31 | USA76 | USA2018 | NULL |1990 | 1998 ||1997 | 20102012 | 20202013 | NULL |1999 | NULL |201320181999 | NULL |2016 | NULL ||1989 | NULL |1989 | 19901992 | 19942005 | 2009|13 rows in set (0.01 sec)

1. The list of data in the table shows along with the SQL code is given in the form of screenshots:…

1. List all the data in your table shows. Your table should have at least 13 records (inserted in A1 and A2). Take a screenshot now and paste it here. 2. Create a table networks, with columns id and name. The field id must be a primary key, integer and not null, with auto_increment. The field name will contain the network's name. It must be VARCHAR(20) or longer. Take a screenshot now and paste it here. 3. Insert the following network names into the table networks. name АВС Kids CBS

1. List all the data in your table shows. Your table should have at least 13 records (inserted in A1 and A2). Take a screenshot now and paste it here. 2. Create a table networks, with columns id and name. The field id must be a primary key, integer and not null, with auto_increment. The field name will contain the network's name. It must be VARCHAR(20) or longer. Take a screenshot now and paste it here. 3. Insert the following network names into the table networks. name АВС Kids CBS

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 2: StayWell is an active business and already has some data collected over e-mails and phone conversations. You need to insert the following data to the OWNER and PROPERTY tables: Add the provided information to the OWNER table. Add the provided information to the PROPERTY table.
Modify the SELECT statement to select the title and release date of PG-13 movies that are released after February 1, 2008. Run your solution and verify the result table shows just the titles and release dates for The Dark Knight and Crazy Rich Asians. CREATE TABLE Movie ( ID INT AUTO_INCREMENT, Title VARCHAR(100), Rating CHAR(5) CHECK (Rating IN ('G', 'PG', 'PG-13', 'R')), ReleaseDate DATE, PRIMARY KEY (ID)); INSERT INTO Movie (Title, Rating, ReleaseDate) VALUES ('Casablanca', 'PG', '1943-01-23'), ('Bridget Jones\'s Diary', 'PG-13', '2001-04-13'), ('The Dark Knight', 'PG-13', '2008-07-18'), ('Hidden Figures', 'PG', '2017-01-06'), ('Toy Story', 'G', '1995-11-22'), ('Rocky', 'PG', '1976-11-21'), ('Crazy Rich Asians', 'PG-13', '2018-08-15'); -- Modify the SELECT statement:SELECT *FROM MovieWHERE ReleaseDate < '2000-01-01';
The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName - variable-length string Breed - variable-length string, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - decimal number, must be between 10.0 and 20.0 BirthDate - date, must be on or after Jan 1, 2015 Insert the following data into the Horse table: RegisteredName Breed Height BirthDate Babe Quarter Horse 15.3 2015-02-10 Independence Holsteiner 16.0 2017-03-13 Ellie Saddlebred 15.0 2016-12-22 NULL Egyptian Arab 14.9 2019-10-12
Need help with Excel spreadsheet. Using the table on the Enrollment worksheet, insert a PivotTable on a new worksheet named PivotAnalysis. Complete the following to create your PivotTable. • Add the Fee, Gender, and Class_Name fields to the PivotTable. • Ensure Class_name is in the Rows area. • Move Gender to the Columns area. • In cell B3, replace Column Labels with Gender. In cell B4, replace F with Female. In cell C4, replace M with Male. In cell A3, replace Sum of Fee with Revenue. In celln A4, replace Row Labels with Classes. • Format the Revenue field as Accounting with 0 decimal places. • Resize the column widths as needed. • Apply Light Orange, Pivot Style Light 10 to the PivotTable.
use the code below to create tabels. include screenshots of each completed table. CREATE TABLE PRICE ( PRICE_CODE NUMBER(2,0) PRIMARY KEY, PRICE_DESCRIPTION VARCHAR2(20) NOT NULL , PRICE_RENTFEE NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) ); CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE MEMBERSHIP ( MEM_NUM NUMBER(8,0) PRIMARY KEY, MEM_FNAME VARCHAR2(30) NOT NULL, MEM_LNAME VARCHAR2(30) NOT NULL, MEM_STREET VARCHAR2(120), MEM_CITY VARCHAR2(50), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(10,2) ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);…
he Horse table has the following columns: ID - integer, primary key RegisteredName - variable-length string Breed - variable-length string Height - decimal number BirthDate - date Write a SELECT statement to select the registered name, height, and birth date for only horses that have a height between 15.0 and 16.0 (inclusive) or have a birth date on or after January 1, 2020.
In MySQL please: The Question: Create a trigger named trg_char_hours that automatically updates the AIRCRAFT table when a new CHARTER row is added. Use the CHARTER table’s CHAR_HOURS_FLOWN to update the AIRCRAFT table’s AC_TTAF, AC_TTEL, and AC_TTER values. (Hint: use temp values, as the INSERT event does not accept the OLD keyword.)
CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY (artist_id)); CREATE TABLE TRACKS( track_id CHAR(30), track_name CHAR(30), duration INTL(10), tempo REAL, PRIMARY KEY (track_id)); CREATE TABLE USERS( user_id CHAR(30), user_name CHAR(30), age INT(5), nationality CHAR(30), num_track_listened INT(10), PRIMARY KEY (user_id)); CREATE TABLE RECORD( artist_id CHAR(30), track_id CHAR(30), PRIMARY KEY (artist_id, track_id), FOREIGN KEY (artist_id) REFERENCES ARTISTS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE LISTEN( user_id CHAR(30), track_id CHAR(30), PRIMARY KEY (user_id, track_id), FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE FOLLOW( user_id CHAR(30), artist_id CHAR(30), follow_date datetime, PRIMARY KEY (user_id, artist_id) FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (artist_id) REFERENCES ARTISTS); According to the six table, write a single SQL…
Insert a row into the LARGE_PROPERTY table for a new property. The office number is 1, The address is 2643 Lugsi Dr., The number of bedrooms is 3, The number of floors is 2, The monthly rent is $775, The owner number is MA111. Make sure to include the period (.) in the address.
WEEK 9 ASSIGNMENT#3 Part I: Complete the following exercise: Create the following table with the correct columns. Call your new table: student_course (see below). Populate this table with four rows. Make sure the student id column contains values that are also in the student id column of your student table. student id course id semester year Join the student and student_course table where the student id values are the same. Join the student and student_course table where the student id values are the same and year is equal to 2020. Create a select statement that will return the length of the last name column by joining the student and student_course table where the student id values are the same and enroll month is June. Once you have completed your assignment, copy and paste the script into a Word document. Part II: Complete the following exercise: Using a subquery, select student first name where the student is in the student course table. Using a subquery, select the…
Create a new query in Design View that is based on the tblCoach and tblLevel table Add the LevelName field from the tblLevel table to the query design. Add the CoachFirst, CoachLast, BGCExp, and CertificationExp fields, in that order, from the tblCoach table. Use qryCoachBGCExpirations to save query. Add criteria to the BGCExp field to select records with BGCExp dates that occur on or before 12/31/2019. Save and run the query, and then close it.
5. Open the UnsoldComponents query and complete the following tasks: a. Delete the criteria row that contains criteria in the InstallationFee field. b. Add the ClientID field from the ClientSoftware table to the query grid in the fourth column. С. Set the query to select all records from the SoftwareComponent table. d. Select only those records from the SoftwareComponent table with no matching records in the ClientSoftware table. Save and close the UnsoldComponents query. The query should match Figure 2 when in Datasheet view.