1- Create a NONGAME table with the following structure:ColumnТуpeLengthDecimal Places Nulls Allowed? DescriptionITEM NUMCHARPrimary Key4NoDESCRIPTIONCHAR30ON HANDDECIMAL4CATEGORYCHAR3PRICEDECIMAL2- Insert into the NONGAME table the item number, description, number of units onhand, category, and unit price from the ITEM table for each item that is not incategory GME.3- In the NONGAME table, change the description of item number DL51 to "ClassicTrain Set".4- In the NONGAME table, increase the price of each item in category TOY by twopercent. (Hint: Multiply each price by 1.02).5- Add the following item to the NONGAME table: item number: TL92; description:Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95.6- Delete every item in the NONGAME table for which the category is PZL.7- In the NONGAME table, change the category for item FD11 to null.8- Add a column named ON_HAND_VALUE to the NONGAME table. The on-handvalue is a seven-digit number with two decimal places that represents theproduct of the number of units on hand and the price. Then set all values ofON_HAND_VALUE to ON_HAND * PRICE.9- In the NONGAME table, increase the length of the DESCRIPTION column to 40characters.10-Delete the ON_HAND_VALUE column from the NONGAME table.InctriuctionCI

2.) INSERT INTO NONGAME (item number,description,category,price) SELECT item…

1- Create a NONGAME table with the following structure: olumn Турe Length Decimal Places Nulls Allowed? Description TEM_NUM ESCRIPTION Primary Key CHAR 4 No CHAR 30 ON_HAND CATEGORY RICE DECIMAL 4 CHAR 3 DECIMAL 6 2. 2- Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table category GME. each item that is not in

1- Create a NONGAME table with the following structure: olumn Турe Length Decimal Places Nulls Allowed? Description TEM_NUM ESCRIPTION Primary Key CHAR 4 No CHAR 30 ON_HAND CATEGORY RICE DECIMAL 4 CHAR 3 DECIMAL 6 2. 2- Insert into the NONGAME table the item number, description, number of units on hand, category, and unit price from the ITEM table category GME. each item that is not in

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: display all fields in the JOB table sorted by the largest hourly charges for the job first

A: SELECT * will fetch you all record in table

Q: ask 16: List the invoice number and invoice date for each invoice that was created for James…

A: The given is database problem where multiple tables are needed to join to get the required result.

Q: THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS IN THIS…

A: In SQL we use the sub queries along with the IN clause to get the set of records for which we need…

Q: List the isbn of the book, the id and firstname of the editors. Include all books in the bookeditor…

A: Script to List the ISBN of the book, the id, and first name of the editors mentioned in step 2, and…

Q: 1. ID Last Name First Name Create the My Employee table with the following fields: Number(4)…

A: The solution is given in the next step

Q: List the invoice number and invoice date for each invoice created for the customer James Gonzalez

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: The WHERE statement identifies the. Sort None of these Filter All of these Table Fields

A: The WHERE statement identifies the

Q: Based on the ERD below, display Employee first name, middle initial and last name so it displays in…

A: In this case, the whole name is displayed in a single column of employees where the job code is…

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: Task 6: Add the following record to the OWNER table: INSERT INTO OWNER VALUES('SA100', 'Sam',…

A: Attached the Procedure to add the following record to the OWNER table: INSERT INTO OWNER…

Q: please use the picture below to answer the following question Display employee number, employee…

A: SELECT EmployeeID, Emp_LName, HireDate FROM Employee e JOIN Position pWHERE e.Emp_LName like '%e%'…

Q: Display customer number, customer name, and location for customers whose Customer_name starts with…

A: The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. ORDER BY…

Q: productlines productLine VARCHAR(50) text:Description VARCHAR(4000) htmlDescription MEDIUMTEXT image…

A: A join query combines data from two or more database tables based on a related column, facilitating…

Q: Question 15 Suppose that you have the following table created as: CREATE TABLE TAB1 (NAME VARCHAR2…

A: For this question we can decompose the name by using parsename. Parsename will decompose a full name…

Q: The Horse table has the following columns: ID - integer, auto increment, primary key RegisteredName…

A: MySql is a relational database in which data related to each other. By using this relation data can…

Q: With the following table: PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY) Write…

A: Given table is:PRODUCTS(PRODUCT_NUMBER, DESCRIPTION,PURCHASE_DATE,CATEGORY)Write the mySQL statement…

Q: 1. ID Last Name First Name Userid Salary Create the My Employee table with the following fields:…

A: Here is the complete solution of the above problem. See below steps.

Q: 1. ID Last Name First Name Userid Salary Create the My Employee table with the following fields: Not…

A: We need to write query about the above problem. See below steps.

Q: Column Name Sie Constraints Data Type DepelD Varchar 4 Primary key DepeName 40 Not mull Varchar…

A: I have created the query below for the table:

Q: Parent row is a row where there is a ? Primary key Foreign key non-null field…

A: Explanation:- A parent key is either a primary key or a unique key in the parent table of a…

Q: Assume the PRODUCT table contains multiple rows. The following code would include: SELECT…

A: Dear Student, The answer to your question is given below -

Q: Create a student table. The student table needs to include the following columns: Student ID Student…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

1- Create a NONGAME table with the following structure:
Column
Туpe
Length
Decimal Places Nulls Allowed? Description
ITEM NUM
CHAR
Primary Key
4
No
DESCRIPTION
CHAR
30
ON HAND
DECIMAL
4
CATEGORY
CHAR
3
PRICE
DECIMAL
2- Insert into the NONGAME table the item number, description, number of units on
hand, category, and unit price from the ITEM table for each item that is not in
category GME.
3- In the NONGAME table, change the description of item number DL51 to "Classic
Train Set".
4- In the NONGAME table, increase the price of each item in category TOY by two
percent. (Hint: Multiply each price by 1.02).
5- Add the following item to the NONGAME table: item number: TL92; description:
Dump Truck; number of units on hand: 10; category: TOY; and price: 59.95.
6- Delete every item in the NONGAME table for which the category is PZL.
7- In the NONGAME table, change the category for item FD11 to null.
8- Add a column named ON_HAND_VALUE to the NONGAME table. The on-hand
value is a seven-digit number with two decimal places that represents the
product of the number of units on hand and the price. Then set all values of
ON_HAND_VALUE to ON_HAND * PRICE.
9- In the NONGAME table, increase the length of the DESCRIPTION column to 40
characters.
10-Delete the ON_HAND_VALUE column from the NONGAME table.
InctriuctionCI

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

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

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

MySql Workbench CREATE TABLE students ( id INT PRIMARY KEY, first_name VARCHAR(50), last_name VARCHAR(50), age INT, major VARCHAR(50), faculty VARCHAR(50)); CREATE TABLE location ( id INT PRIMARY KEY, name VARCHAR(50), rooms INT); CREATE TABLE faculty ( id INT PRIMARY KEY, name VARCHAR(50), department_id INT); 1. List last name of all students whose first name is longer than 4 letters in ascending order accordingto the last name. Duplicated rows should be removed from the output.2. Count the total number of rooms in Location.3. Find the number of students in each major.4. Find the number of employees in each department who get no commission or have salary less than5000.5. Find the maximum salary of employees in each department that the employee was hired 15 yearsbefore now. *hint: user TIMESTAMPDIFF(<unit type>,<Date_value 1>,<Date_value 2>), the unitcan be YEAR, MONTH, DAY, HOUR, etc...
Based on the ERD below, display all assigned numbers that had an assigned charge per hour greater than $84.5 and assigned charges were less than $200.
In the NONCAT table, change the category for item UF39 to null.
1-Write the syntax to insert into a relational table called students the address column references an object table called addresses that was created using an address_type. Other columns exist in the students table, but you are only inserting into the ones below. Aliases used should be the first letter of the table name, eg students would be s, addresses would be a Relational Table Name students attribute student_id attribute surname attribute address
Task 3: The Car Maintenance team wants to insert and store the following maintenance types to the MAINTENANCE_TYPES table: ID: 1; Description: Tire Change; Price: 50 ID: 2; Description; Oil Change; Price: 45 ID: 3; Description; Full Cleaning; Price: 100 ID: 4; Description; Gas Pump Change; Price: 145 Add the four maintenance types to the MAINTENANCE_TYPES table.
Write a SELECT statement that uses the ranking functions to rank products by the total quantity sold. Return these columns: The product_name column from the Products table A column named total_quantity that shows the sum of the quantity for each product in the Order_Items table A column named rank that uses the RANK function to rank the total quantity in descending sequence A column named dense_rank that uses the DENSE_RANK function to rank the total quantity in descending sequence
Task 14: List the invoice number and invoice date for each invoice that contains an invoice line for a Wild Bird Food (25 lb).
Write Create Table SQL statements Work Session table The table must have a primary key. The table 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 and named constraints must be used Column DataType Constraint WorkYear number(4) Range 2019 - 2020 WorkWeek number(2) Range 1-52 WorkHours number(4,2) Range 0.5 – 99.99 BID NUMBER(4) ,AUTHID NUMBER(4)
Column name Datatype Description trainer_id Should increment what is the datatype and size?
help please Create a table named BRANCH. The table has the following structureBRANCH_NUM decimal(2,0) NOT NULL default '0'BRANCH_NAME char(50) default NULLBRANCH_LOCATION char(50) default NULLNUM_EMPLOYEES decimal(2,0) deault NULL PRIMARY KEY (`BRANCH_NUM`) (Please type answer no write by hand)
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.
question 5 please use the picture below to answer the following question Assuming all other tables are already created, write a SQL statement to create the following tables and the given constraint(s).