Below is a table description and its data. The table is not in Third Normal Form (3NF).Explain why.mysql> DESC shows;+--+-| Field| Туре| Null | Key | Default| Extra+--| int(11)| varchar(50) | YES| int(11)I network_name I varchar(30) | YES| id| NOPRI I NULLauto_increment || NULL| NULL| NULL| nameI network_id| YESmysql> SELECT * FROM shows;+----| id | nameI network_id I network_name+----+1 | Raven's Home2 | Friends3 I The Good Place |10 I Disney30 | NBC30 | NBC|4 | Young Sheldon20 | CBS+---

Third normal form: A relation is said to be in third normal form only if the relation is already in…

Below is a table description and its data. The table is not in Third Normal Form (3NF). Explain why. mysql> DESC shows; I Field | Туре | Null I Key | Default | Extra | id | NO | auto_increment int(11) I varchar(50) | YES I int(11) I network_name | varchar(30) | YES | PRI | NULL | NULL I NULL I NULL | name I network_id | YES mysql> SELECT * FROM shows; +----- | id I name I network_id I network_name | +---- 1 | Raven's Home 2 I Friends 3 | The Good Place I 4 | Young Sheldon 10 I Disney 30 I NBC 30 | NBC 20 | 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

Related questions

Q: Write and execute XML statements for the following two queries: Q1. Find the name of an employee who…

A: Extensible Markup Language (XML) Extensible Markup Language (XML) is a markup language that…

Q: Given the default schema of a database: Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld…

A: A Foreign key is a field in a table that is used to reference the Primary key of another table. It…

Q: Write SQL CODE to Add a new column in the table COURSE, name it "DEPT_CODE". Split the major code…

A: SQL (Structured Query Language) is a programming language used to manage and manipulate data stored…

Q: CONSIDER THE INVOICE TABLE BELOW: invoice id NUMBER (12), invoice date…

A: The question is to answer the given queries related to Oracle.

Q: The following table is in 2NF. Convert it to 3NF using proper notation: Forum (ForumNum, ForumDate,…

A: Second normal form (2NF) is based on full functional dependency and the third normal form (3NF) is…

Q: Below is a table description and its data. The table is not in Third Normal Form (3NF). Explain why.…

A: A relation is said to be in the third normal form if only if the relation is in both first normal…

Q: Populate the CUST_NUM, INV_DATE, and INV_AMOUNT fields with the following customers: CUST_NUM…

A: To populate the given data first we need to create the table. Let’s assume the table name as…

Q: Given the default schema of a database: Orders 123 Orderld OrderDate ADC OrderNumber 123 Customerld…

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

Q: For this problem create a table called instructor_course_nums. Write a procedure that accepts an…

A: Answer is given below .

Q: Convert the following QUERIES to Stored Procedures with IN parameters In MySQL select…

A: Here our task is to convert the given query to stored procedures in MySQL. Stored Procedures A…

Q: Order Number: 5678 Customer Number: 9123 Customer Name: Thomas Customer Address: 51 Samora Machel…

A: Normalization which refers to the one it is the process of organizing data in a database in order to…

Q: b) The following is the HTML code of a form: Student id: Student address: The form is…

A: Answer: <html> <body> <form action = "student.php" method = "post">…

Q: MySQL */ CREATE TABLE AGENT ( AGENT_CODE int, AGENT_LNAME varchar(15), AGENT_FNAME varchar(15),…

A: Hey! This is pretty intuitive. All you need to do is create a database then the respective tables…

Q: The following table is in 1NF. Convert it to 2NF using proper notation:

A: Facilitator (FacilitatorID, LastName, FirstName, Street, City, ZipCode, (ForumNum, ForumDate,…

Q: Please convert the following ERD to RDM The following ERD shows the following information: Some…

A: ERD: ERD stands for Entity Relationship Diagram. ERD is used to display content of the data store.…

Q: SQL code Select the idLitCharacters, name, Gender, Creature SubType. You newest author wants a…

A: SOLUTION -two criteria you've specified:Female Pirates:Gender is 'Female'.Creature SubType is…

Q: Hint: starts with 044 First, create a MySQL database or use an existing database (make sure to use a…

A: Algorithm:Create a database if it doesn't exist, using the UTF8 character set.Use the created…

Q: DATABASE: library (library_name [pk], City, Phone, manager_SSN[pk, fk]) book (book_name [pk], Genre,…

A: answer is

Q: #3 At a given organization, the COVERAGE_MEMBER_LIST table has 500 rows of data. Exactly 200 of…

A: If count Function can be used as count(*) will return the number of rows in a specified table or…

Q: Create a PL/SQL database programming block with DECLARE BEGIN END; In Declare section define…

A: Below is the PLSQL block code:

Q: IN MYSQL Create a trigger named trg_pic_hours that automatically updates the PILOT table when a new…

A: Overview :

Q: Create a PL/SQL anonymous block to insert a new project in DoGood Donor database. Create and use a…

A: The question asks you to create a PL/SQL anonymous block to insert a new project into the DoGood…

Concept explainers

Cryptography

Cryptography is a term used in computer science to describe secure information and communication techniques that transform messages in difficult-to-decipher ways using mathematical concepts and a set of rule-based calculations known as algorithms.

Question

Below is a table description and its data. The table is not in Third Normal Form (3NF).
Explain why.
mysql> DESC shows;
+--
+-
| Field
| Туре
| Null | Key | Default| Extra
+--
| int(11)
| varchar(50) | YES
| int(11)
I network_name I varchar(30) | YES
| id
| NO
PRI I NULL
auto_increment |
| NULL
| NULL
| NULL
| name
I network_id
| YES
mysql> SELECT * FROM shows;
+----
| id | name
I network_id I network_name
+----+
1 | Raven's Home
2 | Friends
3 I The Good Place |
10 I Disney
30 | NBC
30 | NBC
|
4 | Young Sheldon
20 | CBS
+---

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

Introduction

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps with 2 images

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

SQL Query question
3. Show the ID of all the authors that do not have any books. a). Using a join: b). Using a subquery:
Hi, This is what I have, but I am stuck with what to write and not sure if my function is even correct, to begin with. Can someone show me a walk-through solution? MUST USE postgreSQL CREATE TABLE instructor_course_nums (ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25)); CREATE OR REPLACE PROCEDURE calculate_instr_course(ID VARCHAR(25), name VARCHAR(25), tot_courses VARCHAR(25))LANGUAGE plpgsqlAS$$BEGIN END;$$;
q4- Choose all that apply
SELECT P.BRAND_ID, B.BRAND_NAME, B.BRAND_TYPE,MAX(AVGPRICE) FROM LGPRODUCT P INNER JOIN LGBRAND B ON P.BRAND_ID = B.BRAND_ID (SELECT P.BRAND_ID, AVG (P.PROD_PRICE) AS AVGPRICE FROM LGPRODUCT P GROUP BY P.BRAND_ID)AS AVG_PRICE GROUP BY P.BRAND_ID, B.BRAND_NAME, B.BRAND_TYPE ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECT P.BRAND_ID, AVG (P.PROD_PRICE) AS AVGPRICE FROM LGPRODUCT P GROUP BY P.' at line 3
Database Systems please help me answer this question I will give you a good rating Thank you!
Normalization Diagram. See the attached picture.
Write Create Table SQL statements based on the above ERD. All tables must have primary keys. All tables must have appropriate foreign key constraints. Foreign keys must have the same name, datatype and size of the primary key that they refer to The following columns datatypes and sizes must be used: bid,authid / number(4) title,sname,fname / varchar2(30) sellingprice, payrate / number(6,2) Table Column Type Range author sname & fname Unique book title Not Null book sellingprice Check not negative allocation payrate Check 1 to 79.99
Create an anonymous block in PL/SQL to list all the countries from Country table where Currency contain keyword ‘Dollar’. Perform following steps: Create user define type with name of the country, currency.Type should contain datatype for name and currency using %type only.Display should include Name of the country, currency code using user defined type. Filter for the data : All the countries from Country table where Currency contain keyword ‘Dollar’.
Correct Query from table given.
Composite datatypes can only have multi row &multi column values in them Answers: Yes No
Apply the First Normal Form (1NF) and Second Normal Form (2NF) steps to the following two tables. ST_ID ST_Name ST_Major St_Phone ST_Email 100 Marla jen ACCT (703) 111-2222 mjen@gmail.com 110 Jan Bok MGMT (703) 222-3333 jbok@verizon.net 115 Lee Chan MIS (703) 333-4444 (703) 444-5555 lchan@cox.net Table 1 ID Name Courses 1 Ashely Key MIS 302, MIS 303 2 Katy Pery MIS 310 3 Mickey Zen MIS 303, MIS 350 Table 2