Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
7th Edition
ISBN: 9780134802213
Author: Tony Gaddis
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Textbook Question
Chapter 16, 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?
what do you mean by data types ?
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.
Chapter 16 Solutions
Starting Out with Java: From Control Structures through Objects (7th Edition) (What's New in Computer Science)
Ch. 16.1 - Why do most businesses use a DBMS to store their...Ch. 16.1 - When a Java programmer uses a DBMS to store and...Ch. 16.1 - Prob. 16.3CPCh. 16.1 - Prob. 16.4CPCh. 16.1 - Prob. 16.5CPCh. 16.1 - Prob. 16.6CPCh. 16.1 - What static JDBC method do you call to get a...Ch. 16.2 - Describe how the data that is stored in a table is...Ch. 16.2 - What is a primary key?Ch. 16.2 - What Java data types correspond with the following...
Ch. 16.3 - Prob. 16.11CPCh. 16.3 - Prob. 16.12CPCh. 16.3 - Prob. 16.13CPCh. 16.3 - Prob. 16.14CPCh. 16.3 - What is the purpose of the % symbol in a character...Ch. 16.3 - How can you sort the results of a SELECT statement...Ch. 16.3 - Assume that the following declarations exist:...Ch. 16.3 - How do you submit a SELECT statement to the DBMS?Ch. 16.3 - Prob. 16.19CPCh. 16.3 - Prob. 16.20CPCh. 16.4 - Prob. 16.21CPCh. 16.4 - Prob. 16.22CPCh. 16.5 - The Midnight Coffee Roastery is running a special...Ch. 16.5 - Prob. 16.24CPCh. 16.6 - Prob. 16.25CPCh. 16.6 - Write a statement to delete the Book table you...Ch. 16 - Prob. 1MCCh. 16 - This is a standard language for working with...Ch. 16 - Prob. 3MCCh. 16 - The data that is stored in a row is divided...Ch. 16 - This is a column that holds a unique value for...Ch. 16 - This type of SQL statement is used to retrieve...Ch. 16 - This contains the results of an SQL SELECT...Ch. 16 - This clause allows you to specify search criteria...Ch. 16 - Prob. 9MCCh. 16 - Prob. 10MCCh. 16 - Prob. 11MCCh. 16 - Prob. 12MCCh. 16 - This method is specified in the Statement...Ch. 16 - This SQL statement is used to insert rows into a...Ch. 16 - This SQL statement is used to remove rows from a...Ch. 16 - Prob. 16MCCh. 16 - Prob. 17MCCh. 16 - True/False: Java comes with its own built-in DBMS.Ch. 16 - True/False: A Java programmer that uses a DBMS to...Ch. 16 - True/False: You use SQL instead of Java to write...Ch. 16 - True/False: In SQL, the not-equal-to operator is...Ch. 16 - Prob. 22TFCh. 16 - Prob. 23TFCh. 16 - Prob. 24TFCh. 16 - Prob. 1FTECh. 16 - Prob. 2FTECh. 16 - Prob. 3FTECh. 16 - What SQL data types correspond with the following...Ch. 16 - Look at the following SQL statement. SELECT Name...Ch. 16 - Write a SELECT statement that will return all of...Ch. 16 - Write a SELECT statement that will return the...Ch. 16 - Prob. 5AWCh. 16 - Write a SELECT statement that will return the...Ch. 16 - Write a SELECT statement that will return all of...Ch. 16 - Write a SELECT statement that will return the...Ch. 16 - Write a SELECT statement that will return the...Ch. 16 - Prob. 10AWCh. 16 - Write an SQL statement that does the following:...Ch. 16 - Prob. 12AWCh. 16 - Prob. 13AWCh. 16 - Assuming that conn references a valid Connection...Ch. 16 - Look at the following declaration. String sql =...Ch. 16 - Prob. 16AWCh. 16 - Prob. 17AWCh. 16 - Prob. 18AWCh. 16 - Prob. 1SACh. 16 - Prob. 2SACh. 16 - Prob. 3SACh. 16 - What is a primary key?Ch. 16 - Prob. 5SACh. 16 - What are the relational operators in SQL for the...Ch. 16 - What is the number of the first row in a table?...Ch. 16 - Prob. 8SACh. 16 - Prob. 9SACh. 16 - Customer Inserter Write an application that...Ch. 16 - Customer Updater Write an application that...Ch. 16 - Unpaid Order Sum Write an application that...Ch. 16 - Population Database Make sure you have downloaded...Ch. 16 - Personnel Database Creator Write an application...Ch. 16 - Employee Inserter Write a GUI application that...Ch. 16 - Employee Updater Write a GUI application that...
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Compare and contrast the while and for iteration statements.
Java How To Program (Early Objects)
We have defined four binary logical connectives. a. Are there any others that might be useful? b. How many bina...
Artificial Intelligence: A Modern Approach
Change the class TemperatureList given in Display 11.10 by adding a member function called getSize, which takes...
Problem Solving with C++ (9th Edition)
What is an input file?
Starting Out with Python (3rd Edition)
Contrast the following terms: chief data officer; DBA data administration: database administration open source ...
Modern Database Management (12th Edition)
In what year was Plankalkl designed? In what year was that design published?
Concepts of Programming Languages (11th 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
- 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.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_forwardDevelop 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_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_forwardWhat's the connection between keys and data types?arrow_forward
- For 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_forwardwhat do you mean by data-checking functions ?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