• Using the MySQL client: o Create a new table in the dogs_db database called student (id int, name varchar(50), grade float); o Insert the following 3 new rows into the student table: id 55 66 77 name Carl Davis Dennis Fredrickson Jane Richards grade 61 88 78 O Select all records with a grade between 60 and 80. o Change Carl Davis's grade to 65. o Delete Dennis Fredrickson's row. o Change the grade of all people with an id greater than 55 to 80. • After executing each instruction given above, take a screenshot of your console and place it in a document to send in for review. Number your screenshots 1 to 5 in order of execution.

• Using the MySQL client: o Create a new table in the dogs_db database called student (id int, name varchar(50), grade float); o Insert the following 3 new rows into the student table: id 55 66 77 name Carl Davis Dennis Fredrickson Jane Richards grade 61 88 78 O Select all records with a grade between 60 and 80. o Change Carl Davis's grade to 65. o Delete Dennis Fredrickson's row. o Change the grade of all people with an id greater than 55 to 80. • After executing each instruction given above, take a screenshot of your console and place it in a document to send in for review. Number your screenshots 1 to 5 in order of execution.

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: Put your code in the main method given below. [Hint: SQL will return all accounts from the…

A: table name AccountingDB display all account

Q: Q2: Create the database its name ( your name ) and Create below the table if you know : Id Name…

A: 1. database is created of name XYZ then Create Table marks then Insert into marks

Q: Using the WideWorldDistributors database and the Sales schema create a function that takes InvoiceID…

A: In this question we have to use WideWorldDistributors Database and sales schema. Where we have to…

Q: In this database we have users that can be two types students or instructors. They have groups and…

A: SQL which refers to the one it is a programming language used to communicate with databases. SQL…

Q: create a SQLITE database or use an existing database and create a table in the database called…

A: Create table in SQL Inside a database, the statement CREATE TABLE is utilized to build a new…

Q: Write a stored procedure that accepts two parameters: A starting date The number of the consecutive…

A: The required stored procedure statement is given in the next step.

Q: Part A: MySQL Query/Exec Create StudentsDB database in MySQL server with the following table:…

A: Answer

Q: Design two stored procedures as the following (4 marks) Create a PARAMETER based SELECT QUERY stored…

A: Q: Write query based on given values Note: Please ensure to update correct field names as they are…

Q: List the names of any pair of boats that have the same type. For example, one pair would be Anderson…

A: The Question is of DBMS SQL query in which we have to find out the solution by using a query. A…

Q: ● Create a python file called database_manip.py. Write the code to do the following tasks: ○ Create…

A: To perform the above tasks, we need to connect to a database first. Assuming we are using SQLite3 as…

Q: The code shown below is designed to increment through each row in a database table. Correct the…

A: We have to increment through each row in a database table, for that we can use any of the following…

Q: Computer Science Write a script that creates four login IDs based on the contents of a new table…

A: the code is given below:-

Q: Apex, Salesforce In which you have two types of Record type on Position Object one is for Technical…

A: Given: In which you have two types of Record type on Position Object one is for Technical and one is…

Q: Task 2 Stored PL/SQL procedure Implement a stored PL/SQL procedure PARTSUPPLIER that lists…

A: For task 1 Tab_Sup is supplier table name having columns Sup_name, Sup_key Tab_Part is part table…

Q: Create a database named book-collection-db and table named: bookcollect. Your table should contain…

A: To create a new database in MySQL, you use the CREATE DATABASE statement Use a CREATE TABLE…

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…

Q: Because most events don't have an end time, the company only invoices the events afterward. To…

A: The given is a detailed description of EventHelper that is an organization that provides the medical…

Q: write Command to insert data into this tables create table patients ( patient_id VARCHAR(255),…

A: Hi Student Warm Welcome from my side. Hope you are doing great. Here's your required answer.

Q: 1) Assume the EMPLOYEE table has the following rows ID DEPT SALARY NAME 100 SALES 40000 Smith 101 RD…

A: Establishing a Virtual Private Database (VPD) is essential to preserving the secrecy and security of…

Q: Compulsory Task 1 Follow these steps: ● Create a Python file called database_manip.py. Write the…

A: In this question we have to write a python code for database main file where we need to create a…

Q: Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same…

A: Structured query language SQL is a standard language for storing, manipulating and retrieving data…

Q: Problem: JMS TechWizards is a local company that provides technical services to several small…

A: Note: - As per our guidelines we can only answer one question at a time. Please resubmit the other…

Q: * Fields: * - id - integer, must auto-increment * - val1 - integer (starts at 1 and each record…

A: Create table bench( id int not null AUTO_INCREMENT, val1 int IDENTITY(1,1),

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: SQL CODE FOR TABLE CREATION OF TABLE MAINTENANCES:- CREATE TABLE MAINTENANCES( CAR_ID CHAR(5),…

Q: You have a list of all your contacts details that you would like to store in a database. Your goal…

A: Hi. Triggers are set of statements that runs when a certain event is triggered. A trigger can be…

Q: Task 2: The Car Maintenance team also wants to store the actual maintenance operations in the…

A: The following answer is solved using SQL query

Q: The Car Maintenance team also wants to store the actual maintenance operations in the database. The…

A: According to the Question below the Solution:

Q: Population Database Compile and run CreateCityDB.java which will create a Java DB database named…

A: Java is a popular programming language. Java is used to develop mobile apps, web apps, desktop apps,…

Concept explainers

Intermediate SQL Concepts

A query is a request for data or information from one or more database tables. This information could be presented in the form of pictorials, graphs, or complicated findings which helps in easy interpretation. Structured Query Language (SQL) is the most widely used programming language for retrieving and organizing data from relational databases. Collection of tables with rows and columns is referred to as a database. SQL is the language of databases. It makes it easier to extract specific data from databases, which can then be used for analysis.

Question

• Using the MySQL client:
o Create a new table in the dogs_db database called student (id int,
name varchar(50), grade float);
o
Insert the following 3 new rows into the student table:
id
55
66
77
name
Carl Davis
Dennis Fredrickson
Jane Richards
grade
61
88
78
O
Select all records with a grade between 60 and 80.
o
Change Carl Davis's grade to 65.
o Delete Dennis Fredrickson's row.
o
Change the grade of all people with an id greater than 55 to 80.
• After executing each instruction given above, take a screenshot of your
console and place it in a document to send in for review. Number your
screenshots 1 to 5 in order of execution.
• Modify the Java program Main.java to set the qty for Introduction to Java
to 0.
• Modify the Java program Main.java to delete all books with id > 8000; and
insert: (8001, 'Java ABC', 'Kevin Jones', 3) and (8002, 'Java XYZ', 'Kevin Jones',
5);

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1p

Step 2

Step 3

Step 4

Step 5

Step 6

Step 7

Step 8

Step by step

Solved in 8 steps with 6 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

Population Database Compile and run CreateCityDB.java which will create a Java DB database named CityDB. The CityDB database will have a table named City, with the following columns: CityName & Population. Their Data Types: CHAR(50) Primary Key & DOUBLE. The CityName column stores the name of a city, and the Population column stores the population of that city. After you run the CreateCityDB.java program, the City table will contain 20 rows with various cities and their populations. Next, create an application that connects to the CityDB database and allows the user to select any of the following operations: Sort the list of cities by population, in ascending order. Sort the list of cities by population, in descending order. Sort the list of cities by name. Get the total population of all the cities. Get the average population of all the cities. Get the highest population. Get the lowest population. CreateCityDB.java import java.sql.*; /** This program creates the CityDB…
● Create a python file called database_manip.py. Write the code to do the following tasks: ○ Create a table called python_programming. ○ Insert the following new rows into the python_programming table: id name grade 55 Carl Davis 61 66 Dennis Fredrickson 88 77 Jane Richards 78 12 Peyton Sawyer 45 2 Lucas Brooke 99 ○ Select all records with a grade between 60 and 80. ○ Change Carl Davis’s grade to 65. ○ Delete Dennis Fredrickson’s row. ○ Change the grade of all people with an id below than 55.
You have a list of all your contacts details that you would like to store in a database. Your goal is that when a record is inserted in contacts table, you also want this record to be stored (inserted) in a backup table. Assume you have the two tables created: CONTACTS and CONTACTS_BACKUP. These two (2) tables have the same records. The CONTACTS table have the following columns: CONTACT_ID (Primary_Key), FIRSTNAME, LASTNAME and MOBILE_NO. CONTACTS_ID FIRSTNAME LASTNAME MOBILE_NO 1 100 Princess Kim 813023895 2 101 Henry Packer 811257891 3 102 Petrus Johannes 855698712 4 103 Lukas Shilongo 832584691 The CONTACTS_BACKUP table have the same columns and records as the CONTACTS table. CONTACTS_ID FIRSTNAME LASTNAME MOBILE_NO 100 Princess Kim 813023895 2 101 Henry Packer 811257891 3 102 Petrus Johannes 855698712 4 103 Lukas Shilongo 832584691 You now need to keep both tables in sync so that when a record is inserted into the CONTACTS table it should automatically be inserted into…
Access Assignment Problem: JMS TechWizards is a local company that provides technical services to several small businesses in the area. The company currently keeps its technicians and clients’ records on papers. The manager requests you to create a database to store the technician and clients’ information. The following table contains the clients’ information. Client Number Client Name Street City State Postal Code Telephone Number Billed Paid Technician Number AM53 Ashton-Mills 216 Rivard Anderson TX 78077 512-555-4070 $315.50 $255.00 22 AR76 The Artshop 722 Fisher Liberty Corner TX 78080 254-555-0200 $535.00 $565.00 23 BE29 Bert's Supply 5752 Maumee Liberty Corner TX 78080 254-555-2024 $229.50 $0.00 23 DE76 D & E Grocery 464 Linnell Anderson TX 78077 512-555-6050 $485.70…
Create a PL/SQL anonymous block to insert a new project in DoGood Donor database. Create and use a sequence to handle generating and populating the project ID. The first number issue by the sequence should be 800, and no caching should be used. Use a record variable to handle the data to be added. Data for the new row should be the following: project name is “Covid-19 relief fund”, start date: Feb 1, 2023, end date: Jun 30, 2023, and fundraising goal is half million. Any columns not addressed in the data list are currently unknown.
EventHelpers is a company that specializes in event medical assistance. They can hande any type of medical emergency. The company has a range of employees from first aiders to paramedics with degrees. EventHelpers has contacted you to help them design the database so that they can keep track of which employees went to which events. The company provided you with the following details: • Afirst aider has a certificate, which indicates the expiration date of the certificate. The certificate has to be renewed every three (3) years. • A paramedic has a degree that does not expire. • The company needs the ID, Name, Sumame, Contact details, and the address of each employee. • The company sends several medical assistants, a few first aiders and, depending on the size of the events, 1-3 ambulances, to each event. • Each medical assistant is paid per hour based on their qualificafion. To book EventHelpers for an event, the following details are required: • The name of the event. • The time and…
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain conditions. Under what circumstances would you create a View?
Task 5: The Developers team also wants you to ensure that emails are converted to lowercase after an update operation. Currently, new insertions are guaranteed to have lowercase emails, but there is no such guarantee for legacy emails. Therefore, the team wants to ensure that emails are being retained in a lowercase irrespective of any changes in the database. Create a new TRIGGER called email_update for the USERS table that runs before an UPDATE operation.
The code shown below is designed to increment through each row in a database table. Correct the error in the code.For intRecordCount = 0 To datPeople.Rows.Count' Processing statementsNext
Note: Use MYSQL Create a database named book-collection-db and table named: bookcollect. Your tableshould contain the following columns: Title, Author, Genre (Children’s, Romance,Thriller, Fantasy, etc.), Publisher, Copyright Date, ISBN Number, Category (Fiction/Nonfiction), Overview, Link Where to Buy, and Price. Create 30 rows containing list of bookwith varied genre.
CREATE 3 tables as listed below in your own database. */ CREATE TABLE Customer (CustomerID VARCHAR(20) PRIMARY KEY, CustomerLName VARCHAR(30), CustomerFName VARCHAR(30), CustomerStatus VARCHAR(10)); CREATE TABLE SaleOrder (OrderID INT IDENTITY PRIMARY KEY, CustomerID VARCHAR(20) REFERENCES Customer(CustomerID), OrderDate DATE, OrderAmountBeforeTax INT); CREATE TABLE SaleOrderDetail (OrderID INT REFERENCES SaleOrder(OrderID), ProductID INT, Quantity INT, UnitPrice INT, PRIMARY KEY (OrderID, ProductID)); /* Write a trigger to put the total sale order amount before tax (unit price * quantity for all items included in an order) in the OrderAmountBeforeTax column of SaleOrder. */
true/false INNER JOIN combines two relations. It takes the second relation, and appends it to the end of the first relation. In Corelated Subqueries, subquery is executed independent of the outer query: subquery is executed only once. SELECT * FROM sys.Relations displays information about all the user-defined relations within a database. Given GENDER and STUDENT relations, SELECT Gender, FName, LName FROM GENDER LEFT OUTER JOIN STUDENT ON STUDENT.GenderCode = GENDER.GenderCode ≡ SELECT Gender,FName, LName FROM STUDENT RIGHT OUTER JOIN GENDER ON STUDENT.GenderCode = GENDER.GenderCode The statements select RIGHT('I wish I had attended the practice hours', 9) and select…