code of create table and insert table only please Create the following table in your database with the following schema:Table: Products| Column NameType+-I product_idI product nameI product_ category | varchar| intvarchar+---------+---------+product_id is the primary key for this table.This table contains data about the company's products.Table: Orders| Column Name| TypeI product idI order date| unit| intI date| int+----+--There is no primary key for this table. It may have duplicate rows.product_id is a foreign key to the Products table.unit is the number of products ordered in order date.Add the following data to your tables:Input:Products table:+--I product idI product nameI product_category I| 1| 2| 3| 4| 5| Leetcode Solutions| Jewels of Stringology | Book| HP| Lenovo| Leetcode KitBook| Laptop| LaptopI T-shirtOrders table:+-----I product id| order dateI unit+| 1| 1| 2| 2| 3| 3| 60| 70| 30| 80| 2| 3| 20| 30| 60| 50| 50| 502020-02-05| 2020-02-10| 2020-01-18| 2020-02-11| 2020-02-17| 2020-02-24| 2020-03-01| 2020-03-04| 2020-03-04| 2020-02-25| 2020-02-27| 2020-03-01| 5| 5| 5 Write an SQL query to get the names of products that have at least 100 units ordered in February 2020and their amount.Return result table in any order.The results should be:Output:+-I product name| unit+--| Leetcode Solutions | 130| Leetcode Kit| 100Explanation:Products with product id = 1 is ordered in February a total of (60 + 70) = 130.Products with product id = 2 is ordered in February a total of 80.Products with product id = 3 is ordered in February a total of (2 + 3)Products with product id = 4 was not ordered in February 2020.Products with product id= 5.= 5 is ordered in February a total of (50 + 50)= 100.

Create table syntax : CREATE TABLE TABLE_NAME( column_name data_type, column_name data_type,…

Create the following table in your database with the following schema: Table: Products I Column Name 1 Туре product_id I product name I product category | varchar | int varchar | +---- -------+ product id is the primary key for this table. This table contains data about the company's products. Table: Orders Column Name | Type product_id I order_date | int I date | int unit +-- There is no primary key for this table. It may have duplicate rows. product_id is a foreign key to the Products table. unit is the number of products ordered in order_date. Add the following data to your tables: Input: Products table: I product_id I product_name I product_category I | Leetcode Solutions | Jewels of Stringology | Book | HP | Lenovo | Leetcode Kit Вook 2 | Laptop | Laptop I T-shirt 5 Orders table: I product_id | order date | unit | 2020-02-05 | 2020-02-10 | 2020-01-18 | 2020-02-11 | 2020-02-17 | 2020-02-24 | 2020-03-01 | 2020-03-04 | 2020-03-04 | 2020-02-25 | 2020-02-27 | 2020-03-01 60 | 70 | 30 I 80 | 2 | 3 | 20 | 30 | 60 | 50 I 50 | 50 | 2 | 2 4

Create the following table in your database with the following schema: Table: Products I Column Name 1 Туре product_id I product name I product category | varchar | int varchar | +---- -------+ product id is the primary key for this table. This table contains data about the company's products. Table: Orders Column Name | Type product_id I order_date | int I date | int unit +-- There is no primary key for this table. It may have duplicate rows. product_id is a foreign key to the Products table. unit is the number of products ordered in order_date. Add the following data to your tables: Input: Products table: I product_id I product_name I product_category I | Leetcode Solutions | Jewels of Stringology | Book | HP | Lenovo | Leetcode Kit Вook 2 | Laptop | Laptop I T-shirt 5 Orders table: I product_id | order date | unit | 2020-02-05 | 2020-02-10 | 2020-01-18 | 2020-02-11 | 2020-02-17 | 2020-02-24 | 2020-03-01 | 2020-03-04 | 2020-03-04 | 2020-02-25 | 2020-02-27 | 2020-03-01 60 | 70 | 30 I 80 | 2 | 3 | 20 | 30 | 60 | 50 I 50 | 50 | 2 | 2 4

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter13: Views

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

SQL includes many numerical functions. Two of these functions are FLOOR and CEIL. Use the Internet to research these functions. Are the functions available in Oracle, SQLServer, and Access? Write a paragraph that discusses what the functions do and anydifferences and/or similarities between the functions in Oracle, SQL Server, and Access.Then perform the following tasks: a. Solmaris Condominium Group would like to know the impact of discounting its condofees by 3 percent. Write an SQL statement in Oracle that displays the condo ID, unitnumber, discounted condo fee, discounted condo fee with the CEIL function, anddiscounted condo fee with the FLOOR function. b. Based on your research, will the values in the three columns vary? If so, how? Usethe condo with the ID of 1 to explain your answer. Be sure to cite your references.
A unique identifier for a data row that consists of more than one field is commonly called a: primary plus key composite primary key foreign key none of the above
Following tables support the database of a shopping store. The schema contains four tables i.e.Customer, Product, Order and Order Product. Table details including attributes, primary keys(underline) and foreign keys (bold) are also shown below:CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)PRODUCT(ProdID, ProdName, ProdPrice)ORDER(OrderID, OrderDate, OrderPrice, CustID)ORDER_PRODUCT(OPID, ProdID, OrderID) i. Write SQL queries to create all above mentioned four tables in SQL. Must take care of correct data type and constraints (primary key, foreign key, not null etc.) where necessary. ii. Write a SQL query to get all customers’ data who use “yahoo” email. iii. Write a SQL query to show all product names that are in price range of 500 – 1500 (both inclusive) in descending order.
Following tables support the database of a shopping store. The schema contains four tables i.e.Customer, Product, Order and Order Product. Table details including attributes, primary keys(underline) and foreign keys (bold) are also shown below:CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)PRODUCT(ProdID, ProdName, ProdPrice)ORDER(OrderID, OrderDate, OrderPrice, CustID)ORDER_PRODUCT(OPID, ProdID, OrderID)
Following tables support the database of a shopping store. The schema contains four tables i.e.Customer, Product, Order and Order Product. Table details including attributes, primary keys(underline) and foreign keys (bold) are also shown below:CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)PRODUCT(ProdID, ProdName, ProdPrice)ORDER(OrderID, OrderDate, OrderPrice, CustID)ORDER_PRODUCT(OPID, ProdID, OrderID) 1) What results will be produced by execution of following query? SELECT c.CustName FROM Customer c WHERE c.CustCNIC LIKE ‘35201-%-0’; 2) What is the difference between these two queries A and B? Will they both produce same result or not? And Why? (A) SELECT AVG(p.ProdPrice) FROM Product p;(B) SELECT AVG(DISTINCT p.ProdPrice) FROM Product p; 3) Write a SQL query to show how many orders of amount more than 1000 are placed in the month of August 2021.
Following tables support the database of a shopping store. The schema contains four tables i.e.Customer, Product, Order and Order Product. Table details including attributes, primary keys(underline) and foreign keys (bold) are also shown below:CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)PRODUCT(ProdID, ProdName, ProdPrice)ORDER(OrderID, OrderDate, OrderPrice, CustID)ORDER_PRODUCT(OPID, ProdID, OrderID) iii. Write a SQL query to show all product names that are in price range of 500 – 1500 (both inclusive) in descending order.
please do this Following tables support the database of a shopping store. The schema contains four tables i.e.Customer, Product, Order and Order Product. Table details including attributes, primary keys(underline) and foreign keys (bold) are also shown below:CUSTOMER(CustID, CustName, CustEmail, CustPhone, CustCNIC)PRODUCT(ProdID, ProdName, ProdPrice)ORDER(OrderID, OrderDate, OrderPrice, CustID)ORDER_PRODUCT(OPID, ProdID, OrderID)
https://sqliteonline.com/ : Program link The first requirement: Using the SQL language, transform the following entity model into tables in the database. Entity Manger contains: M-name The name of the manager. M-ID and manager number.The department entity contains: D-name The name of the department. D-ID and department number.Create constraint master key name of the manager when creating the Manger table.Creating the foreign key constraint The name of the manager when creating the Department table. The second requirement: After creating the tables and specifying the primary and foreign key, do the following: * Add a column D_loc to the Department table, specifying the type of column.* Remove the column named M_name from the Manger table* Change the name of the department table to Dep Please:: ******* ATTACH A PICTURE OF THE CODES USED AND PICTURE OF THE PROGRAM SCREEN *******
Topic: Database Software: SQLite Schema Table: CREATE TABLE name_basics (nconst VARCHAR(45) NOT NULL, primaryName VARCHAR(45) NULL, birthYear YEAR(4) NULL, deathYear YEAR(4) NULL, age INT NULL, movieNum INT NULL, PRIMARY KEY (nconst)); CREATE TABLE title_episode (episodeID VARCHAR(45) NOT NULL,parentTconst VARCHAR(45) NULL, seasonNumber INT NULL,episodeNumber INT NULL, PRIMARY KEY (episodeID), CONSTRAINT parentTconst FOREIGN KEY (parentTconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_principals (tconst VARCHAR(45) NOT NULL, ordering INT NULL, nconst VARCHAR(45) NULL, category VARCHAR(45) NULL,job VARCHAR(45) NULL, characters VARCHAR(45) NOT NULL, PRIMARY KEY (tconst, characters), CONSTRAINT nconst FOREIGN KEY (nconst)REFERENCES name_basics (nconst) ON DELETE NO ACTION ON UPDATE NO ACTION, CONSTRAINT tconst FOREIGN KEY (tconst) REFERENCES title_basics (tconst) ON DELETE NO ACTION ON UPDATE NO ACTION); CREATE TABLE title_ratings…
Use the following table to answer the questions below: Table name: Customers Column Name Role Data Type Length Constraint customerID stores the ID of a customer Char 5 Primary key custFName stores the first name of a customer Varchar2 35 Cannot be null custLName Stores the last name of a customer Varchar2 35 Cannot be null custGender Store the gender of a customer Char 1 It should be ‘M’ or ‘F’ custDOB Stores the date of birth of a customer Date custIncome Store the income of a customer Number 4 Write in SQL a command that creates the table Customers according to the above description (2 marks). Write in SQL a statement that adds a new column named accountID of type Char(8). This column should be defined as a foreign key that relates the table Customers to the table Account (1.5 marks). Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990 (1.5 Marks).…
Write SQL code for the following questions: Add a new table called SALES_YourFirstName. Please note that “YourFirstName” is your first name. this table should have a minimum of 4 attributes, with at least one foreign key. Write the code to delete the above table from the database. Show the age of the oldest employee. For each employee show their full name, start date, and the name of the department that they work for. Add a new product to the Products table. The product quantity must be in the range of 1-100. Show the name and email address for Suppliers that have “@money” in their email address. For each product that has a quantity less than 50, show its name, quantity, department name, and supplier name. Show a list of products ordered by quantity, from smallest to largest. Include only the product name and the quantity in stock. Prompt the user to enter a date and show the full name and DOB of employees born on that date. For each supplier, show the number of products that are…
An insurance company needs to store their salespeople’s information who are selling their insurance policies. They already have a database with multiple tables, one of the tables (Salesperson) stores information about each salesperson along with the bonus percent they receive, based on the city where the insurance is sold. The table has the following fields: Salesperson(spID, spName, spBirthDate,spCitySelling, bonusPercent) spID: Unique identification number of the salesperson. spName: Full name of the salesperson. spBirthDate: Birthdate of the salesperson. spCitySelling: The city in which the salesperson is selling the insurance. bonusPercent: The bonus percent received by the salesperson based on the city in which he/she sells the insurance. Each salesperson can sell the insurance in just one city. However, for a city, there can be more than one salesperson appointed. Also, the bonus percent is fixed for each city. For example, all of the salespeople who sells insurance in…

SEE MORE QUESTIONS

Recommended textbooks for you

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

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

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

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

SEE MORE TEXTBOOKS