B5. Write a SQL command to perform the following operations by using this schema: BOOKS(BookID. Book Name, Author, Publisher, ISBN); i. Use appropriate datatype and size for creating a table "BOOKS" 11. Insert a new row in the BOOKS table with the values (101,'PIS','ALI','XYZ','A123') iii. Change the Author name ="Ali Al Farsi" for the BookID=101.

B5. Write a SQL command to perform the following operations by using this schema: BOOKS(BookID. Book Name, Author, Publisher, ISBN); i. Use appropriate datatype and size for creating a table "BOOKS" 11. Insert a new row in the BOOKS table with the values (101,'PIS','ALI','XYZ','A123') iii. Change the Author name ="Ali Al Farsi" for the BookID=101.

Database Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter7: Introduction To Structured Query Language (sql)

Section: Chapter Questions

Problem 13P: Write the two SQL command sequences required to: a.Create a temporary table named TEMP_1 whose...

See similar textbooks

Similar questions

Which of the following is a correct statement? a. A commit is issued implicitly when a user exits SQL Developer or SQLPlus. b. A commit is issued implicitly when a DDL command is executed. c. A commit is issued automatically when a DML command is executed. d. All of the above are correct. e. Both a and b are correct. f. Both a and c are correct.
Write the SQL code that will restore the data to its original status: that is, the table should contain the data that existed before you made the changes in Problems 5 and 6.
Write the two SQL command sequences required to: a.Create a temporary table named TEMP_1 whose structure is composed of the EMP_2 attributes EMP_NUM and EMP_PCT. b.Copy the matching EMP_2 values into the TEMP_1 table.
Write the SQL code to delete the row for William Smithfield, who was hired on June 22, 2004, and whose job code is 500. (Hint: Use logical operators to include all of the information given in this problem.)
Database course: a. Write in SQL a command that creates the table Customers according to the above description. b. 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. c. Write in SQL a command that deletes the customers whose date of birth is after 22-Dec-1990. d. Write a SQL query that displays the number of customers who born on the 16th day of a month. e. Write in SQL a query that displays the ids of the customers who have the highest income. f. Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials. (I need the codes to copy them please) Photo is there.
Write SQL retrieval commands for each of the following queries:a. Display the course ID and course name for all courses with an ISM prefix.b. Display all courses for which Professor Berndt has been qualified.c. Display the class roster, including student name, for all students enrolled in section 2714 of ISM 4212.
a)write a SQL command to create the table with appropriate datatype and constraints. b)Write a SQL command to display the name, contact person whose supplierID is 102; c)Write a SQL command to delete all the books which are belong to supplier 101; Write relational algebra expression to display supname,bookname, author, publisher whose supplierno=103. d)Write a SQL command to display all the suppliers’ information whose name starts with ‘A’. Write a SQL command to change the phone number to 97887697 whose supplierId is 103.
Write the SQL command for followingi) Teams ( Teamcode , Teamname, Clubname, total_member, dateofstart, teammanager,teamcoach)ii) Players (Teamcode, playername, dateofbirth, specialposition, Numberofgoal, number of tournaments, Tshirtno)iii) Tournament (Tournament_code, Tname, Year, Hostcountry, numberofteams, winnerteam, goldenboot)iv) Tournament_teams (Tournament_code, teamcode, totalyellocard, totalredcard, numberofgoals)v) Matchdetail (tournament_code, Mtcode, Team1code,team2code, winnerteamecode, matchdate ,team1goal,team2goal,refree)a) Write commands to create the above tables.Teamcode in player table is primary key.Teamcode in players, tournament_Team table is foreign key.b) Show the players of winner team of the year 2010.c) Show the team details of the team which got maximum yellocard.d) Show the team name of the team which won with maximum goal difference with the opposite team in a match.e) Show the details of the oldest team
Write the SQL commands based on the tables given below. a)Display the list of Patientscontaining PatientName, PatientContactand PatientEmailwith Patient’s name begin with ‘S’. b)Display the AppointmentDate, AppointmentTime, PatientName and DentistNamefor all appointmentsin month ofSeptember. c)Add a new attribute called Statusin the Appointments table. The length is 20 characters the default value is ‘Active’. d)Display the Patient Name and the total number of appointments for every patientso farand sort according to the patient’s name. e)Display how much Dentist called Faezahhave charged for the patients’ treatments so far. f)Display the cheapest treatment price. g)Azmi require another follow up appointment for teeth cleaning. Create an SQL statement to add the appointment. The appointment should on the 5thDecember 2021and the time should be the same time for the previous appointment and attended by the same doctor. h)Display all patients that have been treated by ‘Filling and…
Write an SQL statement that will insert an order in the orders table with the following data: cutomerID=3, orderDate = current date, shipAmount=20, taxAmount=23.56, shipDate=a week after current date, shipAddressID=3, cardType=2, cardNumber=4123123412341234, cardExpires=05/2024, billingAddressID=3 Write an SQL statement to delete all orders that are created between 2017-06-01 and 2017-06-07.

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

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

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science

ISBN:

9781305251038

Author:

Joan Casteel

Publisher:

Cengage Learning

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

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

A Guide to SQL

Computer Science

ISBN:

9781111527273

Author:

Philip J. Pratt

Publisher:

Course Technology Ptr

Oracle 12c: SQL

Computer Science