Starting Out with Java: Early Objects (6th Edition)
6th Edition
ISBN: 9780134462011
Author: Tony Gaddis
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 15, Problem 1AW
What SQL data types correspond with the following Java types?
- int
- float
- String
- double
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Databases are used to store different kinds of data such as names, currency, text, graphics, etc. Determining the appropriate data type for each attribute is important for database performance, storage size, and conducting accurate analysis on databases. As with other programming languages, SQL supports many data types. However, you will mostly use two categories while writing SQL queries: Characters, and numbers.
Consider the following standard SQL data types:
Characters
char
varchar
Numbers
integer
decimal
float
Different data types could be used for the same attribute. For example, both char and varchar could be used to store “names” in a database. Examine the attributes for the Characters and Numbers data types.
Using specific examples, compare data types for each category. For example, why you should choose char rather than varchar or opposite?
A computer store uses a database to track inventory. The database has a table named
Inventory
, with the following columns:
ProductID INTEGER PRIMARY KEY NOT NULL
ProductName TEXT
QtyOnHand INTEGER
Cost REAL
Also assume that the
cur
variable references a
Cursor
object for the database. Write Python code that uses the
Cursor
object to execute an SQL statement that does the following:
For every row in the
Inventory
table in which
Cost
is equal to 1599.99, set the
QtyOnHand
column to 22.
A computer store uses a database to track inventory. The database has a table named
Inventory
, with the following columns:
ProductID INTEGER PRIMARY KEY NOT NULL
ProductName TEXT
QtyOnHand INTEGER
Cost REAL
Also assume that the
cur
variable references a
Cursor
object for the database. Write Python code that uses the
Cursor
object to execute an SQL statement that deletes the row in the
Inventory
table in which
ProductID
is equal to 12.
Chapter 15 Solutions
Starting Out with Java: Early Objects (6th Edition)
Ch. 15.1 - Why do most businesses use a DBMS to store their...Ch. 15.1 - When a Java programmer uses a DBMS to store and...Ch. 15.1 - Prob. 15.3CPCh. 15.1 - Prob. 15.4CPCh. 15.1 - Prob. 15.5CPCh. 15.1 - Prob. 15.6CPCh. 15.1 - What static JDBC method do you call to get a...Ch. 15.2 - Describe how the data that is stored in a table is...Ch. 15.2 - What is a primary key?Ch. 15.2 - What Java data types correspond with the following...
Ch. 15.3 - Prob. 15.11CPCh. 15.3 - Prob. 15.12CPCh. 15.3 - Prob. 15.13CPCh. 15.3 - Prob. 15.14CPCh. 15.3 - What is the purpose of the % symbol in a character...Ch. 15.3 - How can you sort the results of a SELECT statement...Ch. 15.3 - Assume that the following declarations exist:...Ch. 15.3 - How do you submit a SELECT statement to the DBMS?Ch. 15.3 - Prob. 15.19CPCh. 15.3 - Prob. 15.20CPCh. 15.4 - Prob. 15.21CPCh. 15.4 - Prob. 15.22CPCh. 15.5 - The Midnight Coffee Roastery is running a special...Ch. 15.5 - Prob. 15.24CPCh. 15.6 - Prob. 15.25CPCh. 15.6 - Write a statement to delete the Book table you...Ch. 15 - Prob. 1MCCh. 15 - This is a standard language for working with...Ch. 15 - Prob. 3MCCh. 15 - The data that is stored in a row is divided...Ch. 15 - Prob. 5MCCh. 15 - This type of SQL statement is used to retrieve...Ch. 15 - This contains the results of an SQL SELECT...Ch. 15 - This clause allows you to specify search criteria...Ch. 15 - Prob. 9MCCh. 15 - Prob. 10MCCh. 15 - Prob. 11MCCh. 15 - Prob. 12MCCh. 15 - This method is specified in the Statement...Ch. 15 - This SQL statement is used to insert rows into a...Ch. 15 - This SQL statement is used to remove rows from a...Ch. 15 - Prob. 16MCCh. 15 - Prob. 17MCCh. 15 - True/False: Java comes with its own built-in DBMS.Ch. 15 - True/False: A Java programmer that uses a DBMS to...Ch. 15 - True/False: You use SQL instead of Java to write...Ch. 15 - True/False: In SQL, the not-equal-to operator is...Ch. 15 - Prob. 22TFCh. 15 - Prob. 23TFCh. 15 - Prob. 24TFCh. 15 - Prob. 1FTECh. 15 - Prob. 2FTECh. 15 - Prob. 3FTECh. 15 - What SQL data types correspond with the following...Ch. 15 - Look at the following SQL statement. SELECT Name...Ch. 15 - Write a SELECT statement that will return all of...Ch. 15 - Write a SELECT statement that will return the...Ch. 15 - Prob. 5AWCh. 15 - Write a SELECT statement that will return the...Ch. 15 - Write a SELECT statement that will return all of...Ch. 15 - Write a SELECT statement that will return the...Ch. 15 - Write a SELECT statement that will return the...Ch. 15 - Prob. 10AWCh. 15 - Write an SQL statement that does the following:...Ch. 15 - Prob. 12AWCh. 15 - Prob. 13AWCh. 15 - Assuming that conn references a valid Connection...Ch. 15 - Look at the following declaration. String sql =...Ch. 15 - Prob. 16AWCh. 15 - Prob. 17AWCh. 15 - Prob. 18AWCh. 15 - Prob. 1SACh. 15 - Prob. 2SACh. 15 - Prob. 3SACh. 15 - What is a primary key?Ch. 15 - Prob. 5SACh. 15 - What are the relational operators in SQL for the...Ch. 15 - What is the number of the first row in a table?...Ch. 15 - Prob. 8SACh. 15 - Prob. 9SACh. 15 - Customer Inserter Write an application that...Ch. 15 - Customer Updater Write an application that...Ch. 15 - Unpaid Order Sum Write an application that...Ch. 15 - Population Database Make sure you have downloaded...Ch. 15 - Personnel Database Creator Write an application...Ch. 15 - Employee Inserter Write a GUI application that...Ch. 15 - Employee Updater Write a GUI application that...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Suppose that you are defining an ADT class and that you then use this class in a program. You want to separate ...
Problem Solving with C++ (9th Edition)
How are documentation comments different from other types of comments?
Starting Out with Java: From Control Structures through Data Structures (4th Edition) (What's New in Computer Science)
Show a snippet of PHP code for creating a recordset. Explain the meaning of the code.
Database Concepts (8th Edition)
Write the code for the timeTick method in ClockDIsplay that displays hours, minutes, and seconds, or even imple...
Objects First with Java: A Practical Introduction Using BlueJ (6th Edition)
This is a prewritten function that is built into a programming language. a. standard function b. library functi...
Starting Out with Programming Logic and Design (4th Edition)
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
- what do you mean by data types ?arrow_forwardDevelop a two small PL/SQL programs. 1. Enter students ID from the keyboard. The program then finds student's first name, last name and phone, stores them in variables and prints them on the screen. 2. Similar to the above, only this time the program will receive student's first name only (instead of student's ID)Then program finds full name and address and prints it on the screen. For both programs please implement NO_DATA_FOUND and TOO_MANY_ROWS exceptions. (please refer to chapter 8 in PL/SQL by Example book)For number 2 program, display a message "Possibly you have two or more students with the first name ...." in TOO_MANY_ROWS exception block.arrow_forwardWhat SQL data type is equivalent to the Integer data type in Visual Basic?arrow_forward
- Develop a C# solution that retrieves a table definition from a SQL Server database and generates the C# source code representing the table as a C# class. The SQL used to obtain the table information is shown below. SELECT C.object_id, C.name as 'column_name', C.column_id, C.system_type_id, T.name as 'system_type_name', C.max_length, C.is_nullable FROM SYS.columns C, SYS. types T WHERE C.system_type_id = T.system_type_id AND C.object_id = (SELECT object_id FROM SYS. TABLES WHERE name = 'STT001_STUDENT') ORDER BY C. column_id; Query Results: object_id column_name column_id system_type_id system_type_name max_length is_nullable 1205579333 Id 56 1205579333 GPA 108 175 167 167 1205579333 MajorCode 1205579333 FirstName 1205579333 LastName 1 } 2 3 4 5 An example output for this program is shown below. public class Student { public int Id { get; set; } public decimal GPA { get; set; } public string MajorCode { get; set; } public string FirstName { get; set; } public string LastName { get; set;…arrow_forwardVariable means an attribute or characteristics a. TRUE b. FALSEarrow_forwardQuestion 8 Oracle compiler implicitly convert the value from some data type to others. can True Falsearrow_forward
- For the remaining questions, use the following table of people: people (id (pk), firstname, lastname, spouse_id (fk)) The table was created as: CREATE TABLE people (id INT NOT NULL AUTO INCREMENT PRIMARY KEY, firstname VARCHAR(30), lastname VARCHAR (30), spouse id INT, CONSTRAINT spouse fk FOREIGN KEY (spouse id) REFERENCES people (id)); This is some sample data: Participation Activity 9 +---- | id | firstname | lastname | spouse_id | + 1 | Marty 2 | Jennifer | McFly | Parker | McFly | Tannen | McFly | | 3 | Lorraine 4 | Biff 5 | George NULL | NULL | 5 | NULL | 3 | +----+--arrow_forwardWhat is a The values Method?arrow_forwardFor the following database scheme Employee(empNo.fName,IName,address,DOB,sex,position,deptNo) Department(deptNo.deptName,.mgrEmpNo) Project(projNo.projName,deptNo) WorksOn(empNo.projNo.dateWorked.hoursWorked) Write an SQL statement to produce a list of the total hours worked by each employee arranged in order of employee number Iarrow_forward
- What's the connection between keys and data types?arrow_forwardCode should be in Python Prompt the user for a title for data. Output the title.Ex: Enter a title for the data: Number of Novels Authored You entered: Number of Novels Authored Prompt the user for the headers of two columns of a table. Output the column headers.Ex: Enter the column 1 header: Author name You entered: Author name Enter the column 2 header: Number of novels You entered: Number of novels Prompt the user for data points. Data points must be in this format: string, int. Store the information before the comma into a string variable and the information after the comma into an integer. The user will enter -1 when they have finished entering data points. Output the data points. Store the string components of the data points in a list of strings. Store the integer components of the data points in a list of integers.Ex: Enter a data point (-1 to stop input): Jane Austen, 6 Data string: Jane Austen Data integer: 6 Perform error checking for the data point entries. If any of the…arrow_forwardWhen someone says "user-defined data types," what exactly do they mean?arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License