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

Similar questions

Normalise the data : Table: Administrator Field Name Data Field Constraints Description size type varchar Admin ID 15 Primary Key Contains the Admin id Admin char 50 Not null Contains the Name Admin name Not null Contains email Email varchar 20 the Address char 10 Not null Contains the address Phone int 8 Not null Contains the Number phone number Table: Product Field Name Data type Field size Constraints Description Product ID varchar 20 Primary Key Contains the product id Product Name char 25 Not null Contains product name Category char 13 Not null Contains the category CustomerlD varchar 15 Foreign key Contains the customer id
Drow ER diegram please
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...
Find the name and the age of the youngest graduate student (use subquery).
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
Table Name Item Column name Constraint Primary key Datatype Varchar2 Varchar2 Varchar2 Size 6 ID ITEM N AME MANUFACTUR ER 30 PRICE Number Not Null DELIVERY DATE Date Varchar2 STATUS 10 Table Name Customer_ Details Column name ID CUSTOMERNAME Datatype Varchar2 Constraint Foreign Key Size Varchar2 Varchar2 30 30 LOCATION CUSTOMERID Varchar2 Number QUAΝΤΙΤΥ Data for Item table ID ΙTEΜ ΑΜΕ MANUFACTURER PRICE DELIΙVERYΥ DAΤΕ STATUS COMPUTER KEYBO ARD COMP UTER COMPUTER 09001 DELL 35000 12-June-2020 PENDING 09002 INTEX 10000 25-June-2020 PENDING COMPL ETED COMPL ETED COMPL ETED 09003 SAMSUNG 32000 18-Feb-2020 09004 LENOVO 37000 о3-Аргil-2020 0900s LAPTOP DELL 57000 20-May-2020 Data for Customer_ Details table ID CUSTOMERNAME CITY CUSTOMERID C0001 C0002 QUANΤITY 525 09001 KALIFA NIZWA 09002 BARKA 8400 09003 09004 SOHAR C0003 C0001 5250 525 NIZWA 09005 BARKA C0004 3150 6. Write an SQL query to display the ID, ITEMNAME, CUSTOMERNAME and price is not equal 35000 and 37000 . 7. Write an SQL query…
Task 14: List the invoice number and invoice date for each invoice that contains an invoice line for a Wild Bird Food (25 lb).
Table Employee (eid,ename, manager_id,edptid) Show employee with his/her manager name.