Homework Answers
1) CREATE USER 'sample'@'localhost' IDENTIFIED BY 'password';
2) GRANT ALL PRIVILEGES ON YouthLeague . * TO 'sample'@'localhost';
3) REVOKE ALL PRIVILEGES ON sample.table_name FROM ‘sample’@‘localhost’;
Add Answer to:
Create three or more MySQL Data Control language (DCL) Statements using the Youth League Database. 1....
Using SQL and the following info Question 3: Find the people who do not have Viper...
Using SQL and the following info Question 3: Find the people who do not have Viper Certification but are still assigned to Viper class ship Find the fname, lname, and ship_instance_id for all people who do not have Viper certification but are assigned to at least one instance of a Viper class ship (this includes all variants of Viper class ships). Return a row for every ship/person combination. Order your results by fname in ascending order. Use the BSG database...
Using SQL and the following info Question 3: Find the people who do not have Viper...
Using SQL and the following info Question 3: Find the people who do not have Viper Certification but are still assigned to Viper class ship Find the fname, lname, and ship_instance_id for all people who do not have Viper certification but are assigned to at least one instance of a Viper class ship (this includes all variants of Viper class ships). Return a row for every ship/person combination. Order your results by fname in ascending order. Use the BSG database...
Connect to mySQL DBMS, open a SQL script file, navigate to CityJail.sql file and execute it...
Connect to mySQL DBMS, open a SQL script file, navigate to CityJail.sql file and execute it to create tables and populate with the supplied data. If there are any errors in the script fix them. It is your job to find the errors and correct them. This is important. You will need correct data for future exercises in this module. Then answer all questions. Write the answer below each question then take screen shot of the result. This script builds...
Database HW help!!!!!!! Provide the SQL statements for the following queries. (1) Provide the names and...
Database HW help!!!!!!! Provide the SQL statements for the following queries. (1) Provide the names and phones of all swimmers currently in level (of id) 3. +-------+---------+---------------------------+ | FName | LName | EMail | +-------+---------+---------------------------+ | Bobby | Khan | theBKhan1 | | Clara | Johnson | ClaraJohnson_11 | +-------+---------+---------------------------+ 2 rows in set (0.00 sec) (2) Provide the names of swimmers who have signed up to participate in the event '100M Butterfly' of Meet id 1. +-------+---------+ | FName...
SQL I have a database CREATE TABLE vendor ( vid CHAR(2) NOT NULL, vname VARCHAR(25) NOT...
SQL
I have a database
CREATE TABLE vendor
( vid CHAR(2) NOT NULL,
vname VARCHAR(25) NOT NULL,
PRIMARY KEY (vid) );
CREATE TABLE category
( catid CHAR(2) NOT NULL,
catname VARCHAR(25) NOT NULL,
PRIMARY KEY (catid) );
CREATE TABLE product
( pid CHAR(3) NOT NULL,
pname VARCHAR(25) NOT NULL,
price NUMERIC (7,2) NOT NULL,
vid CHAR(2) NOT NULL,
categoryid CHAR(2) NOT NULL,
PRIMARY KEY (pid));
CREATE TABLE region
( rid CHAR NOT NULL,
rname VARCHAR(25) NOT NULL,
PRIMARY KEY (rid)...
Question: Write one SQL statement for the following question: Return number of players whose rating is...
Question: Write one SQL statement for the following question: Return number of players whose rating is over 1000. Background information: This is a chess tournament management database that stores information about chess players, tournaments, sections, registrations, and pairings. Each player has an ID, name, grade (0 to 12) and rating. Each tournament has a number of sections. Each player can register for a section of a tournament In each round of a tournament, players in the same section will be...
Use the SQL statements provided to create your tables. Write one SQL statement for each of...
Use the SQL statements provided to create your tables. Write one
SQL statement for each of the following problems. You can only use
the conditions listed in the tasks. E.g., in task 1, you cannot
manually look up pid of Information Systems undergraduate
program.
Here is the given code:
drop table textbook_schedule cascade constraints;
drop table textbook_author cascade constraints;
drop table schedule cascade constraints;
drop table course cascade constraints;
drop table textbook cascade constraints;
drop table author cascade constraints;
drop...
Using MySQL commands answer the questions listed below using the Premier Products Company schema. 1.Using Views...
Using MySQL commands answer the questions listed below using the Premier Products Company schema. 1.Using Views a) Create a view called part_location that has the following attributes: part_num, part_description, part_quantity, warehouse_name, warehouse_address. This data comes from the part and warehouse entities. b) Write a query using the view that shows the total number of parts ordered from each warehouse. The output should look like this: 2. Using Triggers a) Execute the following SQL to create the customer_audit table in the...
SQL Query Question: I have a database with the tables below, data has also been aded...
SQL Query Question: I have a database with the tables below, data has also been aded into these tables, I have 2 tasks: 1. Add a column to a relational table POSITIONS to store information about the total number of skills needed by each advertised position. A name of the column is up to you. Assume that no more than 9 skills are needed for each position. Next, use a single UPDATE statement to set the values in the new...
I try to insert data into one of the table causes but I got an error...
I try to insert data into one of the table causes but I got an error message, I don't know how to resolve this SQL> CREATE TABLE Causes(cid NUMBER(5) PRIMARY KEY, name VARCHAR2(20) REFERENCES Signup, problem VARCHAR2(256), location VARCHAR2(200),fund NUMBER(30)); Table created. SQL> CREATE TABLE Causes(cid NUMBER(5) PRIMARY KEY, name VARCHAR2(20) REFERENCES Signup, problem VARCHAR2(256), location VARCHAR2(200),fund NUMBER(30)); Table created. SQL> describe Signup; Name Null? Type ----------------------------------------- -------- ---------------------------- USERNAME NOT NULL VARCHAR2(50) PASSWORD VARCHAR2(50) NAME NOT NULL VARCHAR2(100) AGE ...
SQL
I have a database
CREATE TABLE vendor
( vid CHAR(2) NOT NULL,
vname VARCHAR(25) NOT NULL,
PRIMARY KEY (vid) );
CREATE TABLE category
( catid CHAR(2) NOT NULL,
catname VARCHAR(25) NOT NULL,
PRIMARY KEY (catid) );
CREATE TABLE product
( pid CHAR(3) NOT NULL,
pname VARCHAR(25) NOT NULL,
price NUMERIC (7,2) NOT NULL,
vid CHAR(2) NOT NULL,
categoryid CHAR(2) NOT NULL,
PRIMARY KEY (pid));
CREATE TABLE region
( rid CHAR NOT NULL,
rname VARCHAR(25) NOT NULL,
PRIMARY KEY (rid)...
Use the SQL statements provided to create your tables. Write one
SQL statement for each of the following problems. You can only use
the conditions listed in the tasks. E.g., in task 1, you cannot
manually look up pid of Information Systems undergraduate
program.
Here is the given code:
drop table textbook_schedule cascade constraints;
drop table textbook_author cascade constraints;
drop table schedule cascade constraints;
drop table course cascade constraints;
drop table textbook cascade constraints;
drop table author cascade constraints;
drop...
Most questions answered within 3 hours.
-
A student conducting this experiment weighs out 2.80 g of
CoCl2.6H2O.
For this part you will...
asked 5 minutes ago -
Find the mid-range for the given sample data. Listed
below are the amounts of time (in...
asked 14 minutes ago -
If one wants to airlift a “thanksgiving’s” turkey (mass=3kg)
using a balloon. What would be the...
asked 10 minutes ago -
An institute reported that 63% of its members indicate that
lack of ethical culture within financial...
asked 12 minutes ago -
A proposal to your local city council in which you propose how
to use the money...
asked 21 minutes ago -
Book co. has 1.0 million shares of common stock equity with a
par (book) value of...
asked 25 minutes ago -
Find the force, in N, required to tow a plate (0.5 m x 2 m) at...
asked 27 minutes ago -
When submitting the completed project, please show all work and
number each answer accordingly.
When calculating...
asked 25 minutes ago -
Eagle Industries feels that a lockbox system can shorten its
accounts receivable collection period by 2...
asked 44 minutes ago -
A block measures 5.5 cm on each side. What is the volume of the
block in...
asked 43 minutes ago -
what are the differences between these?
a. shear force.
b. shear stress.
c. Bending Moment.
d....
asked 53 minutes ago -
The proportion of adult women in a certain geographical region
is approximately 51%. A marketing survey...
asked 1 hour ago