EBK DATABASE CONCEPTS
7th Edition
ISBN: 9780133777840
Author: AUER
Publisher: VST
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 3.14RQ
Program Plan Intro
SQL:
- SQL stands for “Structured Query Language”.
- The current version of SQL is “ANSI SQL – 92”.
- It contains constructs which are used to define and process
database . They are executed using DBMS-supplied command prompt. - SQL is not a
programming language. It is text-based and it is also called as data sublanguage. In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.
DROP TABLE statement:
“DROP TABLE” statement comes under Data Definition Language. It is used to delete the information and to delete the structure of the table. The syntax to drop a table is as follows.
Syntax:
DROP TABLE table_Name;
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Write the SQL statements necessary to remove the PET_OWNER table from the database. Assume that the PET table also needs to be removed. Do not run these commands in an actual database!
Is this statement true or false? The term "null" refers to a column in a database table that does not contain any data and is thus empty.
Database Access Code Write the codethe best that you can to execute the following SQLstatement against a database. Your code should read thedata from the DB and print out all of the data. Thedatabase is an Access database, setup with an ODBCname of "AccountingDB'. Do the best you can, partialcredit will be given. Put your code in the main methodgiven below. [Hint: SQL will return all accounts from thedatabase.]SOL = "Select AcctNo, Owner, Balance fromAccounts"public static void main (String args[])
Chapter 3 Solutions
EBK DATABASE CONCEPTS
Ch. 3 - Prob. 3.1RQCh. 3 - What is a data sublanguage?Ch. 3 - Prob. 3.3RQCh. 3 - Prob. 3.4RQCh. 3 - Prob. 3.5RQCh. 3 - Why do some standard SQL-92 statements fail to run...Ch. 3 - Use the following tables for your answers to...Ch. 3 - Write an SQL CREATE TABLE statement to create the...Ch. 3 - Prob. 3.9RQCh. 3 - Prob. 3.10RQ
Ch. 3 - Prob. 3.11RQCh. 3 - Is PET or PET_2 a better design? Explain your...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - Prob. 3.15RQCh. 3 - Prob. 3.16RQCh. 3 - Prob. 3.17RQCh. 3 - Write an SQL statement to display the breed, type,...Ch. 3 - Prob. 3.19RQCh. 3 - Prob. 3.20RQCh. 3 - Write an SQL statement to display the breed, type,...Ch. 3 - Write an SQL statement to display the name, breed,...Ch. 3 - Prob. 3.23RQCh. 3 - Prob. 3.24RQCh. 3 - Prob. 3.25RQCh. 3 - Write an SQL statement to display the name and...Ch. 3 - Prob. 3.27RQCh. 3 - Write an SQL statement to count the number of...Ch. 3 - Write an SQL statement to count the number of...Ch. 3 - Prob. 3.30RQCh. 3 - Prob. 3.31RQCh. 3 - Prob. 3.32RQCh. 3 - Prob. 3.33RQCh. 3 - Answer question 3.33, but do not consider any pet...Ch. 3 - Write an SQL statement to display the last name,...Ch. 3 - Write an SQL statement to display the last name,...Ch. 3 - Write SQL statements to (1) create the BREED...Ch. 3 - Prob. 3.38RQCh. 3 - Prob. 3.39RQCh. 3 - Prob. 3.40RQCh. 3 - Write an SQL statement to display the...Ch. 3 - Write SQL statements to add three new rows to the...Ch. 3 - Write SQL statements to add three new rows to the...Ch. 3 - Prob. 3.44RQCh. 3 - Explain what will happen if you leave the WHERE...Ch. 3 - Prob. 3.46RQCh. 3 - Prob. 3.47RQCh. 3 - Prob. 3.48RQ
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
- PLZ help with the following: The manager wants to add a new painter as an artist in the database. What would the insert statement look like? For a painter to be considered in the Artist database, the painter must have painted at least one painting, however, a painting might not be exhibited in a gallery. Based on these business rules, please insert one painting for the painter that you inserted in Q1. sql file CREATE TABLE GALLERY (GAL_NUM char(4),GAL_OWNER varchar(35),GAL_AREACODE char(3),GAL_PHONE char(8),GAL_RATE number);INSERT INTO GALLERY VALUES('5','L. R. Gilliam','901','123-4456',0.37);INSERT INTO GALLERY VALUES('6','G. G. Waters','405','353-2243',0.45 );INSERT INTO GALLERY VALUES('1','N. D. Cosner','203','123-9956',0.67);INSERT INTO GALLERY VALUES('2','S. H. Artwork','415','154-3243',0.30); /* -- */ CREATE TABLE PAINTER (PTR_NUM char(4),PTR_LASTNAME varchar(15) NOT NULL,PTR_FIRSTNAME varchar(15) NOT NULL,PTR_AREACODE char(3),PTR_PHONE char(8));INSERT INTO PAINTER…arrow_forwardCreate a table in your own database using the following statement. CREATE TABLE DateRange (DateID INT IDENTITY, DateValue DATE, DayOfWeek SMALLINT, Week SMALLINT, Month SMALLINT, Quarter SMALLINT, Year SMALLINT ); Write a stored procedure that accepts two parameters: A starting date The number of the consecutive dates beginning with the starting date The stored procedure then inserts data into all columns of the DateRange table according to the two provided parameters.arrow_forwardViews 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?arrow_forward
- simple database composed following les: PATI DRUG, and PRESCRIPTION, is now loaded with this assignment and you are ready to start. Please explore the database and then write the appropriate SQL command to answer the following questions. 1. List all the rows in which the prescription dates occur on or after November 14. 2. How many doctors provide prescriptions with 30 tablets in total? 3. List doctor's details where specialty is either Dermatology or Neurology. (Use IN operator). List the results by the first name in ascending order and the last name in descending order 4. Find all patients rows whose first names include 'George' (Assume case sensitivity). 5. List number of patients that do not have a phone number. 6. How many drugs with price < 40$? 7. How many prescriptions are generated for each patient, limit the listing to patients who have more than 2 prescriptions? 8. List number of female patients born in 1970 9. List the drug codes and prices (rounded to one decimal place).…arrow_forwardCreate an SQL package specification and body called JOB_PKG, containing the following procedures: Create a procedure called ADD_JOB to insert a new job into the JOBS table. The procedure has job id, job title, minimum salary and maximum salary as parameters. Ensure that the value of maximum salary is greater than minimum salary, raise an exception if this rule is violated (create a private procedure for salary validation).arrow_forwardWrite C# code to update data in the database table. The fields are Student_Id, Student_Name, Major, and PhoneNumber.arrow_forward
- 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…arrow_forwardThe following tables provide a very small portion of the data that will be kept in the database. The data needs to be inserted into the database for testing purposes. Write the INSERT commands necessary to place the following data in the tables that were created in item #1. Make sure there are no errors when the script is executed. If it does, you will automatically get a zero for this item.arrow_forwardCreate the following queries for the “books” database. For each query make sure to only include those tables that are necessary to answer the question. Your answers for each of these questions should consist of the SQL query that will produce these lists, NOT the list itself. For each type of book (e.g. biography, children, etc), show the number of those books that are 450 pages or longer. The column heading should be '# of long books'. Modify the answer to the previous question so that only those types for which there are at least 2 long books are displayed For each publisher, list the name of the publisher and total number of pages that the publisher has published in all their books (ie. add up all the pages in all books for each publisher). Show the publishers who have published the most pages at the top of the result list. Modify the previous query so that only publishers who have published at least 1250 pages will show up. List each publisher's name and the numbers of…arrow_forward
- The StayWell Property Management team considers creating a discount scheme for the property owners with more than one property in the system. You will need to provide all the owner IDs ( OWNER_NUM ) and the count of properties of the owners with more than one active property in the database. The output columns should be OWNER_NUM and COUNT(*) respectively. Task Provide a list of owner IDs ( OWNER_NUM ) for owners of 0.00 out of 10.00 more than one active property. O out of 1 checks passed. Review the results below for more details.arrow_forwardWrite a SQL statement to create a view named 'IT_Club_Student' which will contain information about all the students acting in the IT club.arrow_forwardSubmit Result Key Here.. Subm SQL Injection Escaping Challenge To complete this challenge, you must exploit SQL injection flaw in the following form to find the result key. The developer of this level has attempted to stop SQL Injection attacks by escaping apostrophes so the database interpreter will know not to pay attention to user submitted apostrophes Challenge Hint This is the query you are injecting code into! Be aware that your apostrophes are being escaped with a leading backslash before being sent to the interpreter SELECT FROM customers WHERE customerld =" Please enter the Customer Id of the user that you want to look up Get user There were no results found in your searcharrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you